Ok I find a solution. I use posts_where
filter in pre_get_posts
. With this filter I can remove the term related WHERE
part from the default SQL query.
function custom_loops($query) {
if (is_tax( 'service_photo_location' )){
$query->set( 'posts_per_page', 10);
$query->set( 'post__in', $ids);
$query->set( 'orderby', 'title');
$query->set( 'order', 'ASC');
add_filter( 'posts_where', function ( $where ) {
$where = str_replace("AND ( wp_term_relationships.term_taxonomy_id IN (778) )", "", $where);
return $where;
}, 10, 2 );
}
remove_action( 'pre_get_posts', 'custom_loops' );
}
add_action('pre_get_posts', 'custom_loops');
Related Posts:
- Modify Taxonomy pages to exclude items in child taxonomies
- Removing taxonomy query by pre_get_posts
- Modify Taxonomy pages to exclude items in child taxonomies
- Sticky Posts exceed posts per page limit
- Theres a way to use $query->set(‘tax_query’ in pre_get_posts filter?
- Obliterate the main query and replace it
- Post injection – how to exclude the original post
- Adding meta_key via pre_get_posts causes navigation to disappear
- Sorting posts that has a meta value first then the rest of the posts
- pre_get_posts on a page
- How pre_get_posts filter by roles in WP Admin
- Weird problem with pre_get_posts and $query->is_page()
- SQL Statement generated by WP_Query not producing expected results
- Why is ‘pre_get_posts’ having no effect?
- Date Query to Pull Current and Future Posts
- pre_get_posts all posts and custom post type with certain tag
- Using Sessions to Filter Posts – bad thing?
- pre_get_posts and the blog page
- Archive by custom post type and custom date field
- pre_get_post filter returns results when there should not be
- Trying to exclude first 5 posts from the first page on the homepage
- Exclude a WordPress post from pre_get_posts if a field is null
- Why the ‘date_query’ is not working in ‘pre_get_posts’ hook?
- Only show certain post types in recent posts widget
- pre_get_posts for exclude category
- pre_get_posts: using tax_query only for certain post type
- pre_get_posts dont firing… Anybody knows whats the wrong with my code?
- Restrict Search Query To After Specific Date
- Include posts from feature category in pre_get_posts
- WP_Error not displaying errors
- Show all posts even if URL points to a single one
- How to achieve post_status__not_in?
- Ordering by meta_key
- Using a pre_get_posts filter to search for multiple strings on all meta values
- Using different parameters for different queries with pre get posts in functions.php
- how to restrict posts_request filter to the main query only
- Automatically applying a pre_get_posts filter for child categories only
- How to override a query and display specific page by ID?
- pre_get_posts variables
- Another query in pre_get_post cause memory issue
- pre_get_posts having no effect on my category archive
- pre_get_posts returns non property object when using posts__not_in
- Override tax_query with pre_get_posts to include other term_ids on a single category
- $query->is_main_query() is causing query’s tax_query to be ignored
- Menu disappears when meta_key changed [closed]
- pre_get_posts with multiple queries
- How to show the last and newest modified post in a custom category?
- Altering the main query using get_post_meta() in pre_get_posts
- Why query by specific date with variables doesn’t return same result that with harcoded integers?
- Sort WordPress Archive by multiple oderby arguments in pre_get_posts action
- Exclude post type with pre_get_posts?
- Exclude page by title for non admins
- problem with setting tax_query in pre_get_posts
- Add terms to a taxonomy archive from within the same taxonomy
- Tax query get first product with attribute value in pre_get_posts
- Problem ID to exclude specific posts from category
- Modify author archive query to combine two queries
- Change post order on archive to be displayed by most commented being ignored by theme
- Complex query using pre_get_posts
- Super confusing ‘pre_get_posts’ behavior with $query->set
- Having trouble with settings terms as array in pre_get_posts
- Override main query for page template
- Querying custom taxonomy on category-specific page is overwritten by function
- how to get content from other site and show it?
- Insert a variable in pre_get_posts
- Set a custom number of posts on the first page
- Why does this query not SELECT post IDs like a normal query would?
- Please ensure me that I’m not crazy using the pre_get_posts [closed]
- How to pass >= condition filter to my year custom tax_query
- What is the proper way to use pre_get_post?
- Querying posts globally based on custom taxonomy with its own taxonomymeta table
- pre_get_posts has php notice when not on CPT archive
- Duplicating event posts in wordpress
- Using pre_get_posts with WP_Query
- Using pre_get_posts on true pages and static front pages
- multiple orderby in pre_get_posts action
- Using multiple taxonomies to sort Custom Posts
- “pre_get_posts” firing on every query
- SQL QUERY needed to get POST category (taxonomy) ? – MUST be SQL statement
- Custom post type with tags
- Filter query posts by the count of metas for a meta key
- Using pre_get_posts on a specific core/query block
- Using pre_get_posts to filter out posts, pagination problem
- Custom taxonomies making WP very slow – Way to fix?
- Shortcode to show thumbnail and link for 3 random posts
- Force is_search to always TRUE
- How to use $query->set with post__in?
- Make blog page show 10 on first page, 9 on every other page
- WP Query – order posts by meta field first and then order the rest
- post__in not working with pre_get_posts, but post__not_in does work
- Displaying number of search results for each post type
- WP_Query – How to get all posts of specific days of week by custom field date?
- Filter WooCommerce archive pages by an additional category
- Exclude Posts Using Meta Query and User Meta
- Showing taxonomies with terms that are attached to custom post
- Taxonomy Terms That Don’t Exist Display Results
- Get taxonomy url, name, post count & image
- Get list of CPT posts in *current* post’s taxonomy term
- Trying to add function with pre_get_posts for plugin search [closed]
- How to use orderby on meta_value when using Pods custom database table storage