posts-where Archives

WordPress

IT Nursery

When querying a combination of posts and other meta fields, is there a better solution than directly modifying the WHERE value?

This question is a follow up to a question I recently asked. I’ve implemented what seemed to be the only solution, and it ...

June 2, 2022
0 Comments

WordPress

IT Nursery

How to search for posts IN OR title OR content OR author?

I have looked at many posts and questions regarding searches for custom meta, but I want to search for posts and include those ...

May 29, 2022
0 Comments

WordPress

IT Nursery

How do I create my own nested meta_query using posts_where / posts_join?

Some of my posts (not all) have a price as a meta key/value. Today I use the pre_get_posts action so that my users ...

May 26, 2022
0 Comments

Custom time range for the posts_where filter

I’m creating a function that displays the most viewed posts and would like to be able to show posts based on how old ...

May 24, 2022
0 Comments

Extending WP_Query — Optimise SQL query

I’m storing posts, a user follows in a custom table that has the columns id, post_id and user_id. To fetch posts that a ...

May 11, 2022
0 Comments

Custom query incorrectly returning everything [closed]

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, ...

May 10, 2022
0 Comments

Order wp_query by calculated field

Hi I’m working on a store locator. I have a custom post “clinics” where I save clinic details (address,.., lat, lng). Each time ...

May 10, 2022
0 Comments

Search ONLY by meta key / meta values

I’m almost there on this one. On functions.php i have this: function base_home_product_post_type( $query ) { if($query->is_search() && $_POST['box'] == 'sku') { $query->query_vars...

May 9, 2022
0 Comments

Is there any difference between hooks posts_where with posts_join and posts_search performance wise?

I want to know which filter hook I should use that performs faster. I did try both several times and I noticed that ...

May 4, 2022
0 Comments

WordPress

IT Nursery

Prevent pre_get_posts filter on specific post type

I am running into one issue with pre_get_post filter. Actually I have 4 post types. Post, Pages, Events, and Venue. I created one ...

April 25, 2022
0 Comments