Update – it may be supported in a meta_query. I need more information – see below. You can’t do it using a meta_query, it’s not supported. Do you have data in meta_data fields? – WordPress queries will exclude posts where any of the orderby (or meta_query) fields is missing. WordPress adds a join condition to … Read more
Yes, it behaves weird. No, shoot me, I can’t get a fix on precisely why and how (stacked joins are probably it). I say flip it. The only posts you don’t want to see are those with true custom key. Query for their IDs separately, feed result into post__not_in, ditch this meta query entirely.
There is no need to craft a custom SQL query in order to achieve this. Since version 4.1, WordPress’s query classes have supported complex/nested meta queries. So you can craft a query like this: $args[‘meta_query’] = array( // Use an OR relationship between the query in this array and the one in // the next … Read more
Multiple meta values can be compared with BETWEEN with an array value: ‘meta_query’ => array( array( ‘key’ => REALIA_PROPERTY_PREFIX .’attributes_area’, ‘value’ => array( $first_val, $second_val ), ‘type’ => ‘numeric’, ‘compare’ => ‘BETWEEN’, ), // inner array. ), // outer array. You can see this in Developer Doc.
OK, the final workaround would be to split query: $sfp_query_args = array( ‘tax_query’ => array( array( ‘taxonomy’ => ‘sfp_post_category’, ‘terms’ => $cat_id_arr ) ), ‘meta_key’ => ‘is_sponsored’, ‘post_type’ => ‘sfpposts’, ‘post_status’ => ‘publish’, ‘showposts’ => (int)$per_page, ‘paged’ => $paged ); …and use “posts_orderby” filter to modify ORDER part: add_filter( ‘posts_orderby’, ‘sfp_modify_orderby’ ); function sfp_modify_orderby( $orderby … Read more
I’ve come across this problem and it seems MySQL doesn’t deal well with the multiple joins to the same table (wp_postmeta) and OR-ed WHERE that WP generates here. I dealt with it by rewriting the join and where as mentioned in the post you link to – here’s a version that should work in your … Read more
You can write your own REST handler for custom queries if you want. In your case, the query can done by doing so: // Register a REST route add_action( ‘rest_api_init’, function () { //Path to meta query route register_rest_route( ‘tchernitchenko/v2’, ‘/my_meta_query/’, array( ‘methods’ => ‘GET’, ‘callback’ => ‘custom_meta_query’ ) ); }); // Do the actual … Read more