Well, perhaps the answer could not be found in the WP_Query class for what I was trying to accomplish. Below is the final code that I plugged in to my functions.php file. I ultimately ended up search the WP_Query Class found in the wp_includes/query.php file. What I discovered is that there are a number of … Read more
What I’m trying to do (for instance): list all the concerts which belong to artists of the “pop” genre. You can do it in two steps: // 1. Get all the pop artist IDs $artist_ids = get_posts( array( ‘fields’ => ‘ids’, ‘post_type’ => ‘artist’, ‘genre’ => ‘pop’ ) ); // 2. Get all the concerts … Read more
This is a really interesting question, which can result in a very expensive, resource intensive process which can really slow your page down dramatically PRELUDE All my code in this question is based on the following post type and taxonomy, so before you run any code, make sure to adjust the post type and taxonomy … Read more
MOST IMPORTANT EDIT When I tested your code, I always added the page header name, and never realized that this was one thing that you didn’t add. You should always name a custom page template so that wordpress knows it’s a page template. So you need to edit your custom page template and add the … Read more
Close. You need another INNER JOIN and should escape all your variables using $wpdb->prepare. I’ve also included a more efficient Haversine formula (source) to calculate the radius. If you use kilometers, then change the $earth_radius to 6371. Also, a great way to debug is to echo the sql and paste it into phpMyAdmin (or whatever … Read more
not sure if you’ll have tried this yet but you could consider grabbing the two sets of posts separately then merging them. Finally use get_posts to create a combined list sorted the way you want. Something like this might work for you (you may want to add in a posts per page argument to the … Read more
you could use wp_list_pluck(); if ( $exclude_featured ) $args[‘post__not_in’] = wp_list_pluck( $exclude_featured->posts, ‘ID’ ); $args[‘posts_per_page’] = 999; query_posts( $args ); endif; while ( have_posts() ) : the_post(); …
You can filter the orderby part of the query to get what you want (trying to pass it via the orderby parameter will not work, it will be filtered out). This simple example adds the meta_value sort order before the standard title sort order. add_filter( ‘posts_orderby’, ‘wpse15168_posts_orderby’ ); $query = new WP_Query( array( ‘meta_key’ => … Read more
You can order them manually after the query is complete: $ids = array (60, 23, 78, 46, 105, 130) $args = array ( ‘posts_per_page’ => -1, ‘post__in’ => $ids, ‘orderby’ => ‘none’ ); $query = new WP_Query ( $args ); $ordered_posts = array(); foreach($ids as $rpid) foreach($query->posts as $index => $fpid) if($fpid->ID === $rpid) $ordered_posts[] … Read more
Since WordPress 4.1 it is possible to build nested meta, date and tax queries. I’ve not tested it but the code bellow should work. Also, I recommend to replace PHP date() function with current_time from WordPress to get the current date taking in account the blog time zone configuration: After the chat with you, it … Read more