error GROUP BY id_category ORDER BY `level_depth` ASC, c.`position` ASC' at line 7

[alexsci7]

Salve a tutti,

per caso a qualcuno di voi è mai capitato questo errore???

 

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 id_category ORDER BY `level_depth` ASC, c.`position` ASC' at line 7

 

SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite

FROM `ps_category` c

LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 5)

LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)

WHERE (c.`active` = 1 OR c.`id_category` = 1)

AND `level_depth` <= 5

AND cg.`id_group` IN ()

GROUP BY id_category

ORDER BY `level_depth` ASC, c.`position` ASC

 

Spero in qualche anima buona in grado di risolvere..

saluti e grazie in anticipo