Hůlkárna Příslušenství Koncovky ostatní
Koncovky ostatní
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