1. Get the order ids for all orders that have a shipping state of "New Jersey".
SELECT orders.ID
FROM `wp_posts` orders
INNER JOIN `wp_postmeta` meta ON meta.post_id = orders.ID
WHERE
orders.post_type = 'shop_order' AND
meta.meta_key = '_shipping_state' AND
meta.meta_value = 'NJ';
| <?php | |
| /* | |
| Plugin Name: Use Names for Thumbnail Images | |
| Plugin URI: http://its.furman.edu/ | |
| Description: Generates resized images with names instead of dimensions (image-large.jpg instead of image-500x456.jpg). | |
| Version: 1.0 | |
| Author: Evan Hildreth | |
| Author URI: http://its.furman.edu/ | |
| */ |