Looking at the code of the function generating the SQL for the term part of queries https://developer.wordpress.org/reference/classes/wp_tax_query/get_sql_for_clause/, it seems like a 0 = 1 is a symptom of bad parameters given in the query, so while you think you are passing the right parameters, apparently you don’t.
Only way to move forward is probably to debug what exactly happens in that function to understand what fails.
Side note: It is always a bad idea to use unsanitized url parameters, additionally the use of cat as parameter seems like a bad idea unless you truly mean it to collide with the general post categories.
Related Posts:
- Custom tax_query filter not working for Woocommerce product categories
- Display All Products by Category with WooCommerce
- Retrieve Product category ‘NAME’ by product category ID – WooCommerce?
- Woocommerce get category image full size
- How to tax query X number of posts related by tag first, then by category if not enough in tag-related
- Programmatically create product category and add thumbnail in woocommerce
- Create product category and keyword search form in woocommerce? [closed]
- How do I edit pre_get_post for the category the user is currently in?
- Display WooCommerce product categories in a 4 columns custom menu [closed]
- Use get_term_children to get the sub category of a parent category for the current post
- Hide uncategorized products from the shop page
- Remove word “Category” from WooCommerce product page [closed]
- Filtering search results
- WooCommerce change category url and product base
- Output link to category from WP_Query loop of woocommerce products
- Display “add to cart” button on every listing in product category page?
- How to get product count with respect to categories in WooComerce
- Get woocommerce catogry
- Set post categories to include parents when setting child category
- Linking products to categories
- Woocommerce category show subcategories only/omit posts for specific category
- ?cat=-1 Indexed Versions Of Homepage
- Warning: sizeof (): Parameter must be an array or an object that implements Countable, On products pages
- Omit specific product categories from WooCommerce shortcode
- WC 3.x Get categories from variable product of the cart
- Multiple Domain Names – One WP Install (non-Multisite) – Default Each Domain name to Product Category WooCommerce
- Hide woocommerce category name from specific pages
- need to add custom field in more products
- How to redefine the sorting of product categories by menu_order?
- Pagination not visible on woocommerce’s category page
- Pagination is not working properly in Product Category/Tag pages
- Best way of getting WooCommerce category path
- How to recreate a copy of a product category in WooCommerce? [closed]
- Get parrent category name
- Sorting category products not working
- Change thumbnail image depending product category
- Woocommerce custom category pages
- Woocommerce custom category page with pagination [closed]
- Categories are not listing their respective products
- Display single category name in woocommerce loop
- Building Menu from Woocommerce Product Categories
- Include WooCommerce product to all child categories
- woocommerce related products by specific categories [closed]
- Do not show sub categories in the loop on archive-product.php
- List just subcategory and products of active category page in Woocommerce
- Display all product tags associated with a specific product category
- why get_the_post_thumbnail( the_ID()) echos extra post id
- Filter WooCommerce archive pages by an additional category
- How do order product categories – on a parent category page – in Woocommerce?
- Woocommerce filter function not updating
- Remove any product that is featured from regular display loop [WooCommerce]
- Two Sections on Woocommerce Catergory Page [closed]
- Woocommerce search form with category select
- Template for product-category page [closed]
- WooCommerce shared categories
- displaying the last product comment in the woocommerce category
- Displaying Single Product Page Parent and Child Category
- Woocommerce only display child category when parent is checked (on add new product page)
- Conditional label Woocommerce archive [unsolved]
- Show audio player only in specific post type category
- How to make product image inherit from category image
- How to show given products only using product id array from specific category page in woocommerce
- How to set acf color field as background color to product category
- How to target all woocommerce categories that don’t have any subcategories in them?
- WooCommerce REST API not returning the default products category
- In if…else condition, the else statement shows even if if statement is correct
- How to show WooCommerce Categories on ‘shop’ page instead of products?
- How can I display all products from all categories on one page with woocommerce?
- How to add all subcategories as submenu in WordPress menu
- How to edit woocommerce sub-category page
- Get WooCommerce product category list in functions.php
- Is there a reason to put a product in both the Child and Parent Categories?
- WordPress category title not update in navigation menu
- WooCommerce showing active product categories on single product page
- selecting categories that have products with tag/category
- Restrict retrieved terms by category?
- Woocommerce Category Sort Dropdown
- Woocommerce: all products of all categories instead products of one category
- How to load terms of a custom taxonomy of a product in woocommerce cart page
- How to get WooCommerce Product Categories and its children’s children?
- Woocommerce change tag_id to name
- Woocommerce product catalog, products with different description
- set a parent category in a product woocommerce
- Display related posts with same category or same tag return blank
- Match two taxonomies to display a specific content
- Category menu that filters out empty categories
- woocommerce – products by category slug? [closed]
- How can I add a Categories page link to a menu? [closed]
- Custom Woocommerce Category view
- Displaying categories and subcategories without link
- WooCommerce category display in custom page
- Sorting Woocommerce products by category and attributes
- Woocommerce custom taxonomy order
- Update wordpress menu with woocommerce products
- How to get Woocomerce categories count
- Get all categories
- Woocommerce Force the category choice before creating new product? [duplicate]
- Categories and products woocommerce wordpress
- Function to reference post meta in place of category Woocommerce
- Restricted category in Woocommerce [closed]