The tag has no usage guidance.

learn more… | top users | synonyms

3
votes
2answers
291 views

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 user follows I have extended the WP_Query as follows: class ...
2
votes
1answer
128 views

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 seems to work (YAY!). I just need to verify that: This is really the only ...
0
votes
1answer
21 views

Wp query show post by author name or post title or post content

I have to create a search query which allows me to filter all posts where author name and post titles or post content has the word from search textbox. So if i search wordpress it should list all the ...
0
votes
1answer
76 views

Help with SQL query, how to add taxonomie terms with value stored in options?

i need your help in making SQL What i have: custom post type ( company ) taxonomie ( category ) applyed to cpt ( and has ct section select field ) custom taxonomie ( section ) applyed to nothing ...
0
votes
1answer
171 views

Use posts_where to exclude posts ids from wp_query

I want to use posts_where to exclude an array of posts ids from all queries in my site. The array containing the posts ids depends on the user that is logged in. Can someone please tell me how to ...
0
votes
1answer
233 views

using posts_where for meta data on pre_get_posts

Let's say you have some code which filters posts by using pre_get_posts e.g. add_action( 'pre_get_posts', 'be_exclude_category_from_blog' ); function be_exclude_category_from_blog( $query ) { ...
0
votes
0answers
50 views

Get posts with parent post that have specific meta value

I am not sure if this can be done with wp query but here goes. My guess it would need a SELF JOIN but no idea how to start. Consider this example. I need a set of post who have a meta value of foo ...
0
votes
0answers
133 views

Avoid changing menu query with suppress_filters => false

I recently had to change qTranslate for qTranslate X since the former is not being updated. This broke my menu and after searching I found it was because qTranslate X sets suppress_filters to false. ...
0
votes
0answers
31 views

Check if the value of “meta2” is smaller than the value of “meta1”

function my_query($where) { global $wpdb; $where .= " AND SELECT $wpdb->posts.* FROM $wpdb->posts AS p, $wpdb->postmeta AS pm1, $wpdb->postmeta AS pm2 WHERE p.ID ...