It took me a while but I got it! This works as follows: Since you have no reference to the post other than the URI, we segment out the URI to check for a page with that page_name If there is a page, we get the latest revision child Hack the query to force our … Read more
According to the codex for WP_Query, the solution might be to use the post_parent as the id of the top level post. But as there are a whole lotta top level cpts in your case, I think this solution should help you: How to display only top level posts in loop via WP_Query?. Update: <?php … Read more
Looking on line 1857 of WP_Query’s code, it seems as though sanitization is done for you, so just run with whatever search term is put in. Current version of wordpress is 3.3, in case the code changes down the line.
Meta queries are essentially wrapper for ease of setup, but end results is part of SQL query to run on MySQL database. These operators are those of MySQL, see in documentation: LIKE operator (performs pattern matching) IN() function (checks if value is in set)
“SELECT name FROM wp_venues WHERE name=””.the_field(“venue’).”‘ “; will only return the value of the_field(‘venue’) which is already known. “SELECT * FROM wp_venues WHERE name=””.the_field(“venue’).”‘ “; will select the whole row with all fields. Try too use $wpdb->prepare for security reasons. With $wpdb->get_row you get the whole row as either an object, a numerically indexed array … Read more
As probably there is not so many unpublished posts with images, You could exclude them from Your WP_Query, adding: ‘post_parent’ => ‘-12,-34,-56′ this would add overhead of only one query grabbing id’s of these posts
Core can’t help you here. You’ll have to do a… Custom Query Here’s a save query, that I use on admin UI screens to get the total amounts of month with posts to use them in the custom pagination. Pay attention that I query not only for the published posts, but take into consideration that … Read more
You’ll need to first grab the posts, then grab the attachments that are children of said posts. $my_query = new WP_Query( array( ‘meta_key’ => ‘my_hash’, ‘nopaging’ => true, ‘orderby’ => ‘meta_value’, ‘fields’ => ‘ids’, ‘cat’ => ’60’, )); if ( $post_ids = $my_query->get_posts() ) { $post_ids = implode( ‘,’, $post_ids ); $atts_ids = $wpdb->get_col( “SELECT … Read more
Turns out the “Custom Page Order” plugin was causing the randomization error… or rather, not allowing any randomization as it overrides it completely. Disabled the plug-in. Whenever I need to change orders, I can enable the plugin, shuffle pages around, and then disable. But the need for this is decreasing more and more as we … Read more
Edit: Re-reading your question I noticed I may have mixed some things up, but the point remains that you should combine these separate queries performed inside the loop, by using variables inside the loop to create a comprehensive list of the query arguments that you can use to perform one query outside the loop. I’ve … Read more