You can not query for multiple meta fields using meta_key and meta_value parameters, you have to use meta_query parameter. Using multiple meta_key and meta_value parameters will use only the first found pair, that is why in your code the condition about “offer_type NOT LIKE deal” is ignored. So, the correct query should be: $args = … Read more
The code you found modifies the main query on pre_get_posts and unsets the search terms so WP_Query doesn’t run a real search query. What you want is // Filter the search SQL that is used in the WHERE clause of WP_Query. apply_filters_ref_array( ‘posts_search’, array( $search, &$this ) ); which runs previously in WP_Query::get_posts(). This later … Read more
I would do this as follows: Back up the entire DB (or certainly the wp_posts table!) Run this query to get all posts that have a featured image: SELECT wp_posts.* FROM wp_postmeta INNER JOIN wp_posts ON (wp_postmeta.post_id = wp_posts.ID) AND meta_key=’_thumbnail_id’; Export the results to a plain SQL file with SQL inserts Do your search … Read more
‘orderby’ => ‘date meta_value_num’, ‘meta_key’ => $meta_key, ‘order’ => ‘DESC’
Afaik, there’s no relation key for meta_query. Use compare instead and maybe also specify a type to speed things up with skipping types that are out of scope. EDIT $args = array( ‘post_type’ => ‘product’, ‘meta_query’ => array( // Used to set two meta keys IN RELATION TO EACH OTHER ‘relation’ => ‘OR’, array( ‘key’ … Read more
Since I couldn’t find the way to grab the custom post’s title and add it to the sorting/ordering by meta_key, I edited my custom post type to include a hidden field that grabs the title of the post and sets it as a custom meta value when the user adds a new custom post. So, … Read more
Okay! So, having spent all the night in order to find a right solution… finally.. I did it. Here is the right method, that works in my situation. The $wpbd method is pretty cool and complicated at the same time. While using this method do not forget to cache queries properly with php-apc or memcache. … Read more
In case I am right about that possible optimisation, I have opened a ticket on Trac and submitted a patch: http://core.trac.wordpress.org/ticket/26281 My plugin’s page query time goes from 10+ seconds to 20ms… I hope there are no edge cases.
Maybe I’m looking too simply, but your code sets the order_by for the query here: ‘orderby’ => ‘meta_value_num’, If you change that to “post_date” it should put them in date order, though you may want to look at the other sorting options here: WordPress get_posts function
Assuming that you will have a loop to display the results of the query, you could loop through the repeater at that point and display only the row that has the correct value.