I’m going to answer my own question:
SELECT ID FROM wpyw_posts
WHERE ID NOT IN (
SELECT wpyw_term_relationships.object_id
FROM wpyw_term_relationships
INNER JOIN wpyw_term_taxonomy ON wpyw_term_taxonomy.term_id = wpyw_term_relationships.term_taxonomy_id
WHERE wpyw_term_taxonomy.taxonomy = 'product_tag'
) AND wpyw_posts.post_type="product"
Related Posts:
- Get WooCommerce product attribute taxonomies in a SQL query on WordPress database
- How to get all products from an order including variations via SQL query?
- How to Order by random on a SQL query
- get woocommerce product image url and price from database [closed]
- Update WooCommerce stock status with SQL query if stock value is greater than 0
- Woocommerce change the price of products in the database
- Query product’s image path by category WooCommerce database?
- How to speed up “My Account > Orders Page” on Site with More than 200,000 orders?
- Alter the cost of products using phpmyadmin sql query
- Woocommerce order_complete email dont send after changing order status via sql
- Use a woocommerce hook to create a table and populate it with a query
- Is it possible to extract all product columns except for one?
- Get the product list of a given Category ID
- Correct function to get the user’s latest Woocommerce Subscription?
- Move payment options at checkout in WooCommerce [closed]
- Is it safe to delete from db orphaned posts i.e. whose post_parent no longer exists?
- WooCommerce – Hook after Loading Variation in Admin Edit page?
- WooCommerce conditional meta query
- Add a custom button with custom link after add to cart for every product
- Redirect woocommerce single-product page
- Username field is not shown in Woocommerce’s registration contact form
- Woocommerce Membership Expiry Date
- Show all author products from specific category
- Redirect user to cart page when add to cart button is clicked
- Woo API REST : product variation price is read-only?
- Disable Local Attributes woo commerce
- Problems with varibel price [closed]
- Custom Admin Email Subject for Woocommerce (3.8.0) Orders
- Woocommerce custom endpoints
- Replacing products on Woocommerce Product Category with Search Results from SearchWP [closed]
- Creating custom permalink tags for WooCommerce
- Add Custom Slug Tags Per Page
- How to override Woocommerce functionality in Reports section?
- how can use woocommerce add to cart popup?
- Add custom field to Woocommerce add new attribute / edit page
- woocommerce axios react
- Woocommerce hook on address field change [closed]
- Maintenance mode just for WooCommerce shop pages [closed]
- relocate woocommerce notices/messages on Cart page
- Custom email template for a specific product category
- WooCommerce 4: Gallery size is too large in mobile
- Same request Mysql/Php not same result
- WooCommerce Registration redirect based on page ID
- Woocommerce Backend Search by Title and SKU
- Get woocommerce coupon code
- Woocommerce change price in cart when discounted
- Woocommerce Remove Tax by Product Type
- get_posts $args won’t accept array as one of the criteria?
- WooCommerce print subcategory of product
- Woocommerce – sell a certain category by unit, another by weight? How?
- Add custom parameters to Woocommerce add to cart link
- How to automatically change the status of product from draft to published when stock qty change from 0 > 1
- Woocommerce checkout page issue – Payment methods not loading – strange “Credit/Debit Card Secure Payment” form
- Woocommerce: How to change the attribute values per product
- Delete method giving 500 error, for this endpoint /wc/store/cart/items
- In woocommerce product details not showing
- Re-arrange the Woocommerce checkout page layout
- How to sort products by price ASC and place all no price products to the end? (Woocommerce)
- WordPress | Woocommerce | use “category display type” in if statement
- Parameters in woocommerce_before_add_to_cart_button hook
- Woocommerce – get daily sales meta
- How to save one API response to WooCommerce order meta data
- WooCommerce and ACF: How to Redirect Upon Add to Cart – Partially Working Example
- Woocommerce: Search by custom attribute
- How to change user role after login?
- WooCommerce free shipping twice a week
- Product overlapping header
- remove add to cart for free (0 $) product woocommerce
- merge tabs in woocommerce
- How to import products to Woo Commerce given that WP All Import keeps timing out
- WooCommerce subscriptions give option of manual renewal on checkout [closed]
- Awesome Support Custom Field for show Woocommerce orders
- How to make a custom redirect in WooCommerce?
- Firstname and lastname greyout or hidden Billing details at next checkout like username is hidden [closed]
- How to use woo commerce login to authenticate code php pages?
- Site with WooCommerce section moved to HTTPS – all pages except home and main store are 404s
- Multiple quantities with options
- how to add custom reviews button in woocommerce order complete generated mail
- Click Count on Download a File
- How to add coupon expiry date into the followup emails?
- Not all strings are translated
- Custom Woocommerce checkout filed yields a Json error when validating [closed]
- access Woo commerce | WordPress methods externally
- How to display Woocommerce catagories
- Woocommerce set single city to sell to
- eCommerce solution doesn’t want to display its shortcodes or any content where it’s set to [closed]
- Woocommerce hidden fields with meta keys and values. how?
- How do I make a diagonal strikethrough on wordpress? [closed]
- Woocommerce – Remove ‘Buy Product’ Button from shop page [closed]
- Add woocommerce.css in template?
- Translate Woocommerce tab
- Woocommerce -> gallery images per variation without a plugin? [closed]
- Why is my WordPress admin not working
- Create bookings after subscription renewal
- Change variants URL
- Woocommerce products permalink based on SKU
- Woocommerce ajax checkout get wc_checkout_params is not defined
- Struggling with Per-Item Shipping and Classes
- Woocommerce deleted and replaced my WordPress front/page. How do I restore my original page?
- Snippet to Log “Payment Failed” in Syslog [closed]