No results found for second level category

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:

  1. Custom tax_query filter not working for Woocommerce product categories
  2. Display All Products by Category with WooCommerce
  3. Retrieve Product category ‘NAME’ by product category ID – WooCommerce?
  4. Woocommerce get category image full size
  5. How to tax query X number of posts related by tag first, then by category if not enough in tag-related
  6. Programmatically create product category and add thumbnail in woocommerce
  7. Reflect nested categories in appearance > menus
  8. Create product category and keyword search form in woocommerce? [closed]
  9. Remove child products from woocommerce category page [closed]
  10. How do I edit pre_get_post for the category the user is currently in?
  11. Display WooCommerce product categories in a 4 columns custom menu [closed]
  12. How to select product category while adding new product in woocommerce? [closed]
  13. Use get_term_children to get the sub category of a parent category for the current post
  14. Hide uncategorized products from the shop page
  15. Remove word “Category” from WooCommerce product page [closed]
  16. Filtering search results
  17. WooCommerce change category url and product base
  18. Output link to category from WP_Query loop of woocommerce products
  19. display woocommerce all category title on home page
  20. Add Icons to the Product Category Sidebar Widget WooCommerce
  21. Add Product categories to WordPress menu without losing hierarchy
  22. Display “add to cart” button on every listing in product category page?
  23. How to get product count with respect to categories in WooComerce
  24. Custom page for WooCommerce’s /product-category/
  25. Getting categories id for all products in cart
  26. Get woocommerce catogry
  27. get_cat_ID() not wokring
  28. Display child categories in WooCommerce
  29. WooCommerce duplicate sub categories and product slugs
  30. Set post categories to include parents when setting child category
  31. WooCommerce IF statements not working
  32. Linking products to categories
  33. Woocommerce category show subcategories only/omit posts for specific category
  34. ?cat=-1 Indexed Versions Of Homepage
  35. Warning: sizeof (): Parameter must be an array or an object that implements Countable, On products pages
  36. Omit specific product categories from WooCommerce shortcode
  37. products nested by subcategories in a current category archive
  38. WC 3.x Get categories from variable product of the cart
  39. Multiple Domain Names – One WP Install (non-Multisite) – Default Each Domain name to Product Category WooCommerce
  40. Hide woocommerce category name from specific pages
  41. Hide woocommerce category name from specific pages
  42. need to add custom field in more products
  43. How to redefine the sorting of product categories by menu_order?
  44. Pagination not visible on woocommerce’s category page
  45. Pagination is not working properly in Product Category/Tag pages
  46. Best way of getting WooCommerce category path
  47. How to recreate a copy of a product category in WooCommerce? [closed]
  48. Get parrent category name
  49. Sorting category products not working
  50. Remove product category placeholder image (Woocomerce)
  51. Categories for each brands
  52. Change thumbnail image depending product category
  53. Unwanted Duplicate Product Categories in WooCommerce
  54. Woocommerce custom category pages
  55. Customize WordPress widget – Product Category
  56. WordPress/Woocommerce only show category in shop to a single role
  57. WooCommerce – How to show specific category first-rest of products-specific category last
  58. Woocommerce custom category page with pagination [closed]
  59. Categories are not listing their respective products
  60. Display single category name in woocommerce loop
  61. Building Menu from Woocommerce Product Categories
  62. Include WooCommerce product to all child categories
  63. woocommerce related products by specific categories [closed]
  64. Do not show sub categories in the loop on archive-product.php
  65. List just subcategory and products of active category page in Woocommerce
  66. List a maximum of ‘x’ product categories with qty of ‘y’ in each column
  67. Display all product tags associated with a specific product category
  68. why get_the_post_thumbnail( the_ID()) echos extra post id
  69. How to access deleted term inside delete_product_cat action
  70. Apply WordPress function on specific woocommerce product categories only
  71. Filter WooCommerce archive pages by an additional category
  72. Grandchild Term Things Grandfather Term is It’s Parent
  73. How do order product categories – on a parent category page – in Woocommerce?
  74. Woocommerce filter function not updating
  75. Adding custom ID field to the categories
  76. How can i change what one category displays?
  77. Remove any product that is featured from regular display loop [WooCommerce]
  78. Two Sections on Woocommerce Catergory Page [closed]
  79. Woocommerce search form with category select
  80. How to display product with two condition, category and brand taxonomy
  81. Show different menu on each woocommerce category page
  82. Template for product-category page [closed]
  83. WooCommerce shared categories
  84. displaying the last product comment in the woocommerce category
  85. Displaying Single Product Page Parent and Child Category
  86. Woocommerce only display child category when parent is checked (on add new product page)
  87. category description not showing in my woocommerce
  88. Conditional label Woocommerce archive [unsolved]
  89. Show audio player only in specific post type category
  90. How to make product image inherit from category image
  91. How to show given products only using product id array from specific category page in woocommerce
  92. Shop Category Pages missing s
  93. How to set acf color field as background color to product category
  94. How to target all woocommerce categories that don’t have any subcategories in them?
  95. WooCommerce REST API not returning the default products category
  96. In if…else condition, the else statement shows even if if statement is correct
  97. How to show WooCommerce Categories on ‘shop’ page instead of products?
  98. Show the parent taxonomy by creating shortcode in woocommerce?
  99. How can I display all products from all categories on one page with woocommerce?
  100. How to add all subcategories as submenu in WordPress menu
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)