The pre_get_posts function is a simple query modifier for general “post” queries. If you’re looking to modify the SQL directly for these query I suggest using the post_clauses hook. This hook passes an array of SQL clauses such as:
$sql['where'] and sql['join']
Here you can inject your own custom SQL into the specific clauses. That being said, if you are truly writing something custom it might be beneficial to circumvent WordPress entirely and just use $wpdb to grab your results.
Related Posts:
- When should you use WP_Query vs query_posts() vs get_posts()?
- When to use WP_query(), query_posts() and pre_get_posts
- Wp get all the sub pages of the parent using wp query
- How to query for most viewed posts and show top 5
- WP_Query vs get_posts
- Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
- How to uniquely identify queries?
- pre_get_posts with get_posts
- Query Custom Meta Value with Increment
- Get posts by meta data OR title
- Perform query with meta_value date
- Using is_main_query to select custom post type on certain page
- WP_Query ordered by custom field that is a date string?
- Can not switch the queried post in pre_get_posts hook
- Pass the same object to multiple widgets in a template with one query
- Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
- Retrieve or Query Pages by ID
- How do you query wordpress posts using a math formula between multiple meta field values?
- How to implement time filter to show random post 1 month for one category and 3 months for other categories
- Page navigation doesn’t show when query category
- Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
- How to query a custom post type with a taxonomy filter but display post type archive page?
- Store sticky post’s ids in a transient
- Change query_posts to WP_Query in page but does not work
- Custom Query num_rows returns wrong amount
- Slow page loads due to WordPress Core Query
- Filtering out child category posts from parent category archive not working
- Query Page Content From Theme Options?
- How can I override one post and make it display content for another post?
- Include current post into loop
- pre_get_posts – Trying to get property of non-object warning
- Filter post query to only show direct children of category
- Should I reset $wp_query?
- Why doesn’t my WP Meta Query return any results?
- Elementor posts custom query based on tag [closed]
- `offset` WP_Query argument dont work via `pre_get_posts`
- Filter products on category AND tag
- Get posts that match defined arrays of tags
- I need query_posts() to order results first by a meta value and then by post ID
- How to show post title in content editor in backend?
- My entry results are not consistently alphabetized
- Merge two queries and remove duplicate
- Using the same WP_Query for shop and widgets in WooCommerce shop
- Modify query to exclude certain ids and certain parents and its corresponding children
- Ordering Posts by parent category, name ascending
- wp_query – Modify $query to include duplicate content
- Optimising specific Query with ACF meta objects
- How to organize a WP_Query’s list of posts by category and display category title?
- When should you use WP_Query vs query_posts() vs get_posts()?
- How to query post ids liked by the Author
- WordPress Query showing multiple titles
- Query Posts by date range with fixed beginning and end
- custom query to get posts
- Custom post types loop on a page template
- Pre_get_post on CPT archive page
- Search query alteration not working for meta values
- Modify WordPress Search
- When to use WP_query(), query_posts() and pre_get_posts
- Get post ids from WP_Query?
- Should I use Pre Get Posts or WP_Query
- Nested meta_query with multiple relation keys
- Using pre_get_posts with WP_Query
- order by numeric value for meta value
- Some doubts about how the main query and the custom query works in this custom theme?
- Return only Count from a wp_query request?
- WP_Query orderby post__in remains ineffective in the Loop [closed]
- WP Query where title begins with a specific letter
- What is “main query”? [duplicate]
- WP_Comment_Query pagination, delving into the unknown
- Usage of the new “posts_clauses” filter in WordPress 3.1?
- Reduce or prevent calling of update_meta_cache
- How to add taxonomy filter on the query fly?
- Make a WP Query search match exactly the search term
- Using OR conditions in meta_query for query_posts argument
- WP_Query: query posts by ids from array?
- Query Posts in a Predefined Order
- Sort posts by category name and title
- Order posts by ID in the given order
- What is the most efficient way of querying posts based on visits and date for current day?
- Order Search Results Page by meta_value If no Value Return Remaining Results
- Custom WP_Query order by post_meta and (author) user_meta
- Query WooCommerce orders where meta data does not exist
- Query Multiple Post types each with own meta query
- WP_Query for WooCommerce Products
- How-to exclude terms from the main query the most performant way?
- Get posts by menu ID
- Get the number of posts from the current page results
- Changing Posts Per Page and offset with pre_get_posts
- How to exclude latest x posts from a paginated query?
- WordPress Custom Query to show posts from last x years
- author.php with ACF and CPTs
- Slow SQL_CALC_FOUND_ROWS Query
- Problem with ‘post__not_in’
- “pre_get_posts” firing on every query
- RSS feed with specific keyword
- When should you use wp_reset_postdata vs wp_reset_query?
- How to know which one is the main query?
- Identify which loop you are hooking into; primary or secondary?
- get query’s query string
- Meta Query with date and time on the same Day before given time