The generated SQL is available via the request property:
echo $the_query->request;
where $the_query is a \WP_Query instance.
Check out how it’s formed in the class here.
Also available via the posts_request filter for unsuppressed filtering.
Related Posts:
- WP_Query leaking absurd amounts of memory
- Fatal error: Class ‘ms\WP_Query’ not found on plugin initialization [closed]
- Register custom query args parameter for WP_Query()
- How to add multiple custom URL variables?
- Getting wrong relationship value in $args in wp_Query?
- Check for featured image in WP_Query
- Why Does get_posts() Return an Empty Set?
- How to get data from WordPress $wpdb into React Gutenberg Blocks Frontend?
- get_posts / WP_Query Memory size of 134217728 bytes exhausted
- How to ensure “the_content” filter runs only for the main displayed content?
- add_filter and remove_filter added before and after wp_query
- How to get all images and their thumbnails from wp media library
- How to create a dynamic page based on form data with a plugin?
- How to Display Custom Post Type’s Gallery (images ) in Through WP_Query
- Handling form request from plugin file
- Cannot search post by taxonomy
- How to get orders with used coupon in WooCommerce
- WP_Query with tax_query, order by most ‘matches’
- WP_Query returns no results
- Finding posts containing matching array elements in a meta field usign WP_Query
- Create a custom display order in the main menu
- manage_posts_custom_column, showing serial number using increment in loop
- Error : “Cannot use object of type WP_Post as array in”
- Proper way to run wp_query from inside a plugin
- using new WP_Query in save_post function alters $post
- Slow WP_query due to nested wp_query. Need Suggestions
- ORDER BY wp_post custom column name in wp_query
- How to create database table, add data, update and delete using wpdb via plugins?
- Elementor custom Query with ACF fields to show matching woocommerce products custom fields
- WP_Query filters
- How to fetch only current hour posts?
- How to get Metabox custom field to show checked if value is updated using post meta query?
- WordPress pre_get_posts with combined results of two queries (OR)
- Search: how to extend the existing search to include a custom table
- how to get all the child category name in a specified category name?
- how to invoke wordpress API from other existing PHP system
- How I can use order by of the custom post title?
- How to query children by post name/slug
- 400 Bad Request, in wordpress theme development, wp_ajax
- Prevent WordPress automatically processing certain URL queries
- Store custom meta box data as serialized array
- how to load the comment template from a plugin
- How remove trashed WooCommerce orders from wc_get_orders() result?
- Auto-complete or auto-suggest from stored data in database
- Get post thumbnail in WP_Query
- Pagination not working with custom wp_query
- Get Posts by IDs (optionally)
- Adjust query on single
- WP_Query order posts by category
- Is it possible to use the MySQL’s ORDER BY FIELD() clause as part of the pre_get_posts hook?
- Multiple dynamic Tax Query – pass taxonomy argument from array
- WP_Query not ordering correctly
- How to check category name available or not
- Home page is not loading, where in other pages are displaying on the site
- how to create a shortcode from a variable in plugin
- User meta query using Wildcard
- Group By in a Metaquery
- WP Query date_query with several date range
- Making Woocommerce optimized for more than 500k products
- Post Pagination does not working on WP-Query
- WP Query Relations / Compare
- pull data from wordpress database
- How can I query 3 posts from diferente categories (one of each category)
- Query only title/field/featured media of posts [closed]
- Custom MySQL query to pull out Advanced Custom Fields?
- post_results filter confused by pagination in sidebar and main section
- Can’t get query string in ajax call
- Get custom wp_query search results to appear on search.php
- loop and in admin header problem
- How do I query posts and have their related taxonomies returned in the results?
- Best Way to Inventory the Media Library of a 200+ Multisite Installation?
- $_GET vs get_query_var()
- What is the meta_query key name for the woo product average rating? [closed]
- get the queried_object of an url
- Return custom product in ajax call loop
- filter on get_posts efficiently
- Default table collation on plugin activation?
- How to auto-upgrade my plugin?
- 404 errors after plugin options update and category base change
- How to determine, from plugin script, if active theme has The Post Title
- How to avoid loading same script twice?
- Is there any way to check for user login and send him to login?
- Add a class to a dynamic sidebar’s wrapper
- how to search users by ajax live search
- Creating Admin Plugin – Content of a page is displayed at global scope as well
- Naming conventions when using (PHP5) namespaces?
- Readme.txt seems to be cached but not the version
- Issue on Checkbox with Custom Option Page
- How to get post meta in functions?
- Plugin access to average users not only admin
- Rewrite not working since upgrade to 5.9
- ACF Field value in wordpress login message filter
- Using meta_key & meta_value in add_rewrite_rule
- Custom Registration Form and Passwords
- Fullwidth slider using background image Flexslider WordPress
- Plugin files not updated (cache cleared)
- How to add additional field in a table row after creating a table?
- WordPress plugin tables become corrupt
- How can i call from custom fields to the category editor?
- Is it possible to convert various image types from remote URLs to WebP and then serve them immediately?