Oups !

... [MYSQL Error] :
Request URI : /fr/collection-de-noel-c41.html
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 ') GROUP BY p.id_product HAVING categories_online = 1 ORDER BY cp.order ASC, p.na' at line 1
Query : SELECT p.*, ((IFNULL(c4.online,0) + IFNULL(c3.online,0) + IFNULL(c2.online,0) + IFNULL(c1.online,0)) = (IF(IFNULL(c1.id_category,0)>0,1,0) + IF(IFNULL(c2.id_category,0)>0,1,0) + IF(IFNULL(c3.id_category,0)>0,1,0) + IF(IFNULL(c4.id_category,0)>0,1,0)) ) AS "categories_online" FROM category_product cp LEFT JOIN category c4 ON c4.id_category = cp.id_category LEFT JOIN category c3 ON c4.id_parent = c3.id_category LEFT JOIN category c2 ON c3.id_parent = c2.id_category LEFT JOIN category c1 ON c2.id_parent = c1.id_category INNER JOIN product p ON p.id_product = cp.id_product INNER JOIN manufacturer m ON p.id_manufacturer = m.id_manufacturer LEFT JOIN season s ON p.id_season = s.id_season WHERE c1.id_parent IS NULL AND (p.product_type = "virtual" OR (p.product_type IN ("regular","bundle") AND NOT EXISTS(SELECT id_product FROM `virtual` WHERE id_subproduct = p.id_product) AND NOT EXISTS(SELECT id_product FROM bundle WHERE id_subproduct = p.id_product AND bundle_only = 1) ) ) AND p.online = 1 AND cp.id_category IN () GROUP BY p.id_product HAVING categories_online = 1 ORDER BY cp.order ASC, p.name_fr ASC, FIELD(cp.id_category,)
Params for markers :

Array
(
    [0] => 
)