wp-query - Read For Learn

Order posts by date and then by custom field

add_filter(‘posts_orderby’, ‘posts_orderby’); function posts_orderby($orderby_for_query) { global $wpdb; $prefix = $wpdb->prefix; $orderby_for_query = “LEFT(” . $prefix . “posts.post_date, 10) DESC, ” . $orderby_for_query; return $orderby_for_query; } This produces this query: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) WHERE 1=1 AND wp_posts.post_type=”post” AND (wp_posts.post_status=”publish”) AND (wp_postmeta.meta_key = ‘my_post_rating’ ) GROUP BY wp_posts.ID ORDER … Read more

How to use filter hook posts_join for querying taxonomy terms in posts_where?

Well, after trying different things, I came up with the following. When we use posts_join there is no need to add the prefix $wpdb-> plus the table being queried. We just need the column name. In this case, we just need name and taxonomy, like this: BEFORE $where .= ” OR ($wpdb->term_taxonomy.taxonomy IN (‘category’) AND … Read more

On Taxonomy Template page, want to add Post_Type

You can use pre_get_posts filter hook to check if you are on the taxonomy page and if so just add your custom post type to the query something like this: function add_my_type( $query ) { if ( $query->is_tax(‘YOUR_TAXONOMY’) ) { $query->set( ‘post_type’, array(‘post’,’YOUR_CUSTOM_POST’) ); } } add_filter( ‘pre_get_posts’, ‘add_my_type’ );

Use postin and postnot_in together?

post__in and post__not_in are mutually exclusive. Note: you cannot combine post__in and post__not_in in the same query. http://codex.wordpress.org/Class_Reference/WP_Query As your question is written, the solution you reject– that of using array_diff— is the obvious answer. If it is true that that solution won’t work you will need a filter on posts_where (probably) that will provide … Read more

Sorting Posts by custom field

To expand on @pieter-goosen’s comment, you do indeed want to use pre_get_posts. In your example, by using WP_Query, you’re overwriting the entire query and just resetting most parts of it to default. In fact, you’re probably not seeing a specific category of posts at all. You should be seeing all posts since that’s the default … Read more

How Do I Use WP_Query to Run This Database Query as Search Result?

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

How to get the parent’s taxonomy?

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

Sorting a list of posts displayed under a list of associated terms (which should be sorted without initial articles)

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

Pagination not working on Custom Page Template

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

Post queries by latitude and longitude

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

+ More