You should not use a direct SQL query, instead try the WP_Query tax queries e.g.: $args = array( ‘post_type’ => ‘post’, ‘tax_query’ => array( ‘relation’ => ‘AND’, array( ‘taxonomy’ => ‘category’, ‘field’ => ‘id’, ‘terms’ => array( 22 ) ), array( ‘taxonomy’ => ‘job’, ‘field’ => ‘name’, ‘terms’ => $terms, ‘operator’ => ‘IN’ ) ) … Read more
Your problem is you have: foreach post where A is true, that has a child where B is true Which is actually: foreach post where A is true that has a child where B is true So this is not something you should be doing in 1 query. Instead you would need to do n … Read more
Got it solved. Probably not the most efficient way but it works! SELECT product_id, meta_value FROM ( SELECT order_meta.order_item_id, order_meta.meta_value AS ‘product_id’ FROM wp_woocommerce_order_itemmeta AS order_meta LEFT JOIN wp_woocommerce_order_items AS order_items ON order_meta.order_item_id = order_items.order_item_id LEFT JOIN wp_term_relationships AS term_rels ON term_rels.object_id = order_items.order_id WHERE term_taxonomy_id = 24 AND order_meta.meta_key = ‘_product_id’ ) AS product_ID … Read more
Special Query: Title, Terms, Content – %LIKE%
I was able to solve my problem with this query, although I bet it can be more efficient (I just couldn’t figure out how to do it.) SELECT DISTINCT p.* FROM wp_posts p LEFT JOIN wp_usermeta um ON p.post_author = um.user_id LEFT JOIN wp_postmeta pm ON p.ID = pm.post_id INNER JOIN ( SELECT txrm.object_id FROM … Read more
Install WordPress Locally WordPress is well-known for its ease of installation. Under most circumstances, installing WordPress is a very simple process and takes less than five minutes to complete. If you wish to install WordPress on local, the following guide will help. Before install WordPress Checking to ensure that you and your web host have … Read more
I was unable to create a WP_Query – I believe it is not possible to solve this using a regular WP_Query – but managed to create an SQL statement that does exactly what I want: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id) … Read more
This is possible, but there’s not a “neat” way to do it. There’s a great write-up here: Display the Most Recent Post in Each Category but as the author points out, it’s a separate query to get the most recent posts for each term. To his great credit, he does deal with caching them, which … Read more
You can use $args = array( ‘post_type’ => ‘post’ ,’posts_per_page’ => 10, ‘category_name’ => ‘orange’ ); $query = new WP_Query( $args ); printf( ‘<h2>Generated SQL:</h2><pre>%s</pre>’, $query->request ); to display the generated SQL query. The above example will give you: <h2>Generated SQL:</h2> <pre> SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE … Read more
This will work fine. global $wpdb; $querydetails = ” SELECT wposts.* FROM $wpdb->posts AS wposts INNER JOIN $wpdb->postmeta AS wpostmeta ON wposts.ID = wpostmeta.post_id WHERE wposts.post_status=”publish” AND wposts.post_type=”match_report” AND wpostmeta.meta_key = ‘report_home-select’ AND wpostmeta.meta_value=”198″ “; $teaminfo = $wpdb->get_results($querydetails, OBJECT); Try it.