Purus
Impregnace na boty i vybrané oblečeníDotaz: SELECT PPVL.id, PPVL.value, PPVL.uri, COUNT(R.product_id) AS count, V.id FROM product_properties_values V INNER JOIN product_properties_related R ON R.product_properties_values_id = V.id INNER JOIN product_properties_values_lang PPVL ON PPVL.product_properties_values_id = V.id AND PPVL.lang_id = 1 WHERE V.group_id = AND R.product_id IN ( SELECT id FROM product WHERE active = 1 AND JSON_CONTAINS(property_id, 4409) ) GROUP BY V.id HAVING count > 0 ORDER BY V.rank ASC, PPVL.valueChyba: 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 'AND R.product_id IN ( SELECT id...' at line 7