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
- Getting the gallery images from products in woocommerce?
- add_filter to modify woocommerce_cart_item_name hyperlink
- Get product details by url key in WordPress woocommerce
- How to get rid of the hover zoom in WooCommerce single products
- How do I display certain products via their category on a section of a page using PHP?
- Programmatically change Payment Methods WooCommerce
- pre_get_posts with WooCommerce Shortcode Query
- Reverse engineering of WooCommerce Storefront filters
- Use WooCommerce function in other WordPress plugin
- Add product description (content) to WooCommerce customer processing order email
- Woocommerce – disable «place order» until user checks Privacy Policy
- Calling calculate_shipping() with ajax in woocommerce
- Adding product SKU before cart item name in WooCommerce
- Accessing parameters when adding filter
- Woocommerce: How to remove page title from storefront theme homepage
- Remove checkout fields with Woocommerce depending on one of several shipping methods
- Replace one coupon to another after coupon added
- WooCommerce Multi-Currency shortcode not working
- Filter WooCommerce Orders query with user meta data
- rating, share and review issue for single WooCommerce page
- Delete All Product Images in phpmyadmin
- Custom PLU field in woocommerce email
- I want to get the value of a select attribute in the checkout page, and then use it to show or not the delivery data
- Display Advanced Custom Fields value in Woocommerce admin order details
- Some images aren’t shown on wordpress after installation on host
- How to display text between product thumbnail and CTA button on WooCommerce “Shop” page
- Multiple archive product exist
- WordPress & WooCommerce: Localhost, Staging and production environments and how to sync them without losing data
- PayPal Express on product page in WooCommerce – doesn’t seem to work on product page?
- Woocommerce – Want to block a user agent from accessing specific product pages
- Reset all stock status in woocommerce
- How to – proper WordPress 301 redirects?
- Additional fields on Woocommerce’s rating system
- Woocommerce product image [closed]
- Question on WooCommerce Syntax
- woocommerce_new_product action doesn’t fire
- Change The Woocommerce Product Categories Dropdown Widget Placeholder Text
- how to create additional button on single product page
- minimum order item for certain products exempting 2 other products (in bulk)
- Is it possible to checkout with 2 different shipping options on a single order? [closed]
- Sender e-mail address, for new order email to customer, is suddenly wrong [closed]
- Pass class to Woocommerce shortcode [relative_products] [closed]
- Undo WooCommerce CSV import
- A Woo commerce extension has deleted my old theme.How to undo? [closed]
- How can I remove a WooCommerce Product Tab’s sub section in wp-admin?
- is_shop doesn’t work for woocommerce [closed]
- Woocommerce Advanced Shipping (WAS) condition is not being called when selecting “Ship to different address” [closed]
- Need a SQL query to update meta_key=’_price’ with value in meta_key=’_regular_price’
- Strip string from $_product->get_title() to get a cleaner mini-cart
- Product page attributes dropdown show price
- Smart Design for Blog + Woocommerce + LearnDash + Forum/Bodyboss
- Ajax add to cart not updating Elementor mini cart totals
- I want to store user password (during registration) in an other table in the same database in addition to the user table MD5 Hash
- How to edit the default woo-commerce Store page meta title tag “Products”
- Unable to add product to the cart
- WooCommerce – 500k Jump in Order Number?
- Custom Email via Hook only for completed order
- Woocommerce : Add name filed of checkout page to buyers wordpress display name
- Need help with woocommerce roles
- Change WooCommerce product and variation prices programatically without affecting performance
- Help to locate a woocommerce hook method
- woocommerce_product_quick_edit_save hook not fired
- Changing Title Tag on Shop Archive Page (current solution reverting to Title of First Product in Loop)
- WooCommerce return 404 in the product page
- What is the meta_key for woocommerce discount amount?
- Files names changed (with strange characters) after being uploaded to cpanel
- woocommerce_add_to_cart custom function called several times
- Order Woocommerce Products by On Sale and Alphabetically
- How to track product price changes?
- Woocommerce Flexslider touch functionality on desktop not working
- Customer Email Address
- How to echo woocomerce attributes values in dropdown box
- Add new page in WooCommerce My Account page
- Adding time of order to Admin email for new order
- Uninitialised Parameters using woocommerce_checkout_update_order_meta hook
- Woocommerce customer role doesn’t change if user is already a subscriber [closed]
- Tags pages for different Custom Post Types and WooCommerce Products sharing Post Tags
- Hide add to cart when product variation has no price or is unavailable
- get_posts only getting most recent product
- How to get the WooCommercer product variation image
- how add css class to product boxes li, for img, add cart button, decs, price… [closed]
- How can I hide the entire “Shipping Details” block on the admin side of Woocommerce? [closed]
- Decrease stock quantity when a variation is sold using Woocommerce
- WooCommerce show decimals in totals [closed]
- Woocommerce Mandatory Field on Shipping Details [closed]
- Create a shortcode to show product tag name on tag archive
- Critical error on woocommerce checkout page
- Can’t add variable products since update WooCommerce [closed]
- Add custom ID to WooCommerce product tab