Hůlkárna Switch Sticks

Switch Sticks

Dotaz: SELECT PPV.id, COUNT(P.id) AS count, PPV.value_cs AS name FROM product_properties_values PPV INNER JOIN product_properties_related PPR ON PPR.product_properties_values_id = PPV.id LEFT JOIN product P ON P.id = PPR.product_id WHERE P.active = 1 AND PPV.group_id = '16' AND (P.category_id IN () OR P.id IN (SELECT product_id FROM product_multicategory WHERE category_id IN ())) GROUP BY PPV.id HAVING COUNT(P.id) > 0 ORDER BY name, PPV.rank ASC
Chyba: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') OR P.id IN (SELECT product_id FROM product_multicategory WHERE category_id ...' at line 10