The transition from URL to SQL in WP is quite long and elaborate.
In a very nutshell:
- URL gets rewritten into a GET request
- GET request gets converted into query variables
- query variables are used to instance main query
- main query generates SQL
There are a lot of nuances to this process, hooks that fire during it, and logic within. This essentially is WordPress, the very core of its core.
Also note that WP_Query
might easily generate more than one SQL query, both for logical and performance reasons.
If I follow your question right you have some extension customizing query with its own GET argument. Simply put there is no way to just “tell” WordPress to give you a “clean” query in this case. You would need to study what exact customization is being done and how it should be handled for your purposes, without breaking function it performs.
Related Posts:
- How to import woocommerce custom fields data into another site?
- Include WP_Query in my own PHP file?
- How to use update and delete query in wordpress
- How to make WordPress plugin check for database changes and then do something?
- retrieve thumbnail from post ID of best selling product in category
- WP_Query | Help me create a search term with an ‘OR’ relation?
- simple wordpress ajax plugin not working when not logged in
- Using Cookie Data For WP_Query Loop
- Use wc_enqueue_js only on specific pages – nested add_action
- Show only one post for each author ( Page loads too slow )
- Modern Tribe Calendar wp-query with meta query not working at all
- if statement on database query
- WordPress Ajax Custom Query – High CPU LOAD
- Display related products with custom output
- Looking for most performant way to execute several similar WP queries within shortcodes
- Query String being Removed Creating a Pagination Issue within a Custom Plugin
- How to select WooCommerce products by post_meta and order them
- Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
- Why is variable not working on custom sql query using wpdb?
- How can I use wp_query to show all product data using just the products ID?
- Get WooCommerce product details and transfer them to a custom DB table
- woocommerce subscriptions – get expiration date [closed]
- How to securely provide a $_POST var in WP_Query with PHP 7?
- Create WP_Query to search for posts by their categories or their parent/child categories
- Automated Cart Update With Alert Box Each Time
- PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
- WooCommerce/WordPress: how hide entire table form after submit (Admin Dashboard)?
- Display a specific category of products in shop page and disable code for specific actions
- WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
- Update results, Before deleting the related category [closed]
- How to auto fetch customer details in Woocommerce in checkout page
- Sum the total amount of a specific product purchased per user and display in table
- I want to add custom add to cart link [closed]
- get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
- wp query foreach deleting record returning only first or last item
- inserting a post from an extern php file but post content doesn’t show on wp site
- Redirect to another page using contact form 7? [closed]
- Custom array from a query only write the last row of the query
- Extend Woocommerce Widget Class – WC_Widget_Product_Categories
- wpdb prepare insert table doesn’t work
- Change product_base programmatically
- email alert for product availability
- Can a plugin redirect product page based on IF condition?
- How to display SQL query that ran in WC_Order_Query?
- Hide posts if user is added to it WP_query
- Custom route and query
- WP_Query multiple post results
- Where to copy woocommerce files to in my custom theme to avoid editing the core plugin?
- custom post type with role Vendor
- Woocommerce custom Plugin in wordpress [closed]
- Toolbar Hidden in a Virtual Page
- select a single val though a table in wordpress
- Add a custom WooCommerce settings tab with sections
- How to WP_Query posts order by parent title?
- Modify WooCommerce used to get all orders in dashboard
- Output product category link from WP_Query
- How to work Woocommerce pagination inside shortcode?
- WP_Query for woocommerce products with a pattern as a post_title
- Payment field disappears on custom Paypal plugin
- Passing in MySQL prepare statement parameter separately throwing error
- Convert a column of a table containing an Array as response in HTML
- I am having errors with checkout on wordpress
- product_type_options get saved value [closed]
- Usermeta data unserialize, extract and display in table in WordPress
- how to get data from two different table from wordpress database
- How can I update the price when someone enters postcode or zip code in woocommerce checkout page?
- Looping through and combining calls to Woocommerce REST API
- get_filtered_term_product_counts – Get product terms if any products
- How do I remove an action hook inside a class that is called by another class?
- Need help with format of nested array in MySQL
- WP_Query To Display Product Of Brand On Taxonomy Page
- The plugin generated 225 characters of unexpected output during activation
- Woocommerce Related Product by 2 taxonomy
- append data to mysql table via submit button coded in php – not working
- Help on Wp_query to print an term
- Query doesn’t display text data with apostrophes
- wp_query beginner
- How to detect if a revision was made by woocommerce or wordpress?
- SQL Query Search page
- How can I display a query in a page?
- Send data from plugin to external database
- WooCommerce – Print Processing orders [closed]
- Custom query_posts() parameter
- MySQL update text field with ‘
- How to edit the default database of WordPress [closed]
- Ajax Load More or View More functionality for woocommerce category layout by template overriding
- How keep woocommerce users separeted in multisite install and keep admins on network
- Custom field fetch error on woocommerce pdf invoice
- How to set variable to specific field when querying
- Variable ++ in query loop
- Execute multiple PHP Snippets causes error?
- Woocommerce Convert existing order to the cart
- How to get data from WordPress $wpdb into React Gutenberg Blocks Frontend?
- Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
- How to add SVG icon above product tab title
- How can I apply_filters from inside a function?
- How can i programmatically change the SKU of a product based on product variation?
- WordPress Query Crashes Browser
- how to check for wordpress Query errors
- Login user into magento using wordpress account