SQL: SELECT DISTINCT SQL_CACHE product_parameter.id AS id, product_parameter_value.id AS id_product_parameter_value, COALESCE(product_parameter_lang.title, product_parameter_lang_alt.title) AS title, COALESCE(value_lang.title, value_lang_alt.title) AS value_title, product_parameter.unit AS unit, product_parameter.position, (SELECT COUNT(*) AS count FROM product_product_parameter WHERE product_product_parameter.id_product_parameter = product_parameter.id AND product_product_parameter.id_product_parameter_value = product_parameter_value.id ) AS product_count FROM product_parameter_in_group LEFT JOIN product_parameter ON product_parameter_in_group.id_product_parameter = product_parameter.id LEFT JOIN category ON category.id_product_parameter_group = product_parameter_in_group.id_product_parameter_group LEFT JOIN product_parameter_lang ON product_parameter.id = product_parameter_lang.id_product_parameter AND product_parameter_lang.id_lang = 1 LEFT JOIN product_parameter_lang AS product_parameter_lang_alt ON product_parameter_lang.id_lang IS NULL AND product_parameter_lang_alt.id_product_parameter = product_parameter.id AND product_parameter_lang_alt.id_lang = 1 INNER JOIN product_parameter_value ON product_parameter.id = product_parameter_value.id_product_parameter LEFT JOIN product_parameter_value_lang AS value_lang ON product_parameter_value.id = value_lang.id_product_parameter_value AND value_lang.id_lang = 1 LEFT JOIN product_parameter_value_lang AS value_lang_alt ON value_lang.id_lang IS NULL AND value_lang_alt.id_product_parameter_value = product_parameter_value.id AND value_lang_alt.id_lang = 1 WHERE fast_find = 1 AND category.id IN () ORDER BY product_parameter.position ASC,product_parameter.id ASC,value_lang.title ASC
Fatal error: Uncaught exception 'MysqlException' with message 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY product_parameter.position ASC,product_parameter.id ASC,value_la' at line 32 in SELECT DISTINCT SQL_CACHE product_parameter.id AS id, product_parameter_value.id AS id_product_parameter_value, COALESCE(product_parameter_lang.title, product_parameter_lang_alt.title) AS title, COALESCE(value_lang.title, value_lang_alt.title) AS value_title, product_parameter.unit AS unit, product_parameter.position, (SELECT COUNT(*) AS count FROM product_product_parameter WHERE product_product_parameter.id_product_parameter = product_parameter.id AND product_product_parameter.id_product_parameter_value = product_parameter_value.id ) AS product_count FROM product_parameter_in_group LEFT JOIN product_parameter ON produc in /home/velox_sport/public_html/cms/inc/class/db/db.php on line 132