1064 - 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 'AND lg.active = 1' at line 7

SELECT lg.id,lg.parent_id,lg.name,lgd.title,lgd.description,lg.parent_id,lg.listorder, lg.fotos_groups_id,lg.generic1,lg.generic2,lg.generic3,lg.generic4, lg.generic5,lg.es_comuna,lgd.title_web,lgd.title_seo FROM llistats_groups lg LEFT JOIN llistats_groups_description lgd ON lg.id = lgd.groups_id AND lgd.language_id = '2' WHERE lg.id = AND lg.active = 1
1064 - 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 'AND lg.active = 1' at line 7

SELECT lg.id,lg.parent_id,lg.name,lgd.title,lgd.description,lg.parent_id,lg.listorder, lg.fotos_groups_id,lg.generic1,lg.generic2,lg.generic3,lg.generic4, lg.generic5,lg.es_comuna,lgd.title_web,lgd.title_seo FROM llistats_groups lg LEFT JOIN llistats_groups_description lgd ON lg.id = lgd.groups_id AND lgd.language_id = '2' WHERE lg.id = AND lg.active = 1
1064 - 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 'AND lg.ACTIVE = 1 ORDER BY lg.listorder' at line 5

SELECT lg.id,lg.name,lgd.title,lgd.title_web,lgd.description,lg.parent_id,lg.listorder,lg.fotos_groups_id,lg.active,lg.es_comuna FROM llistats_groups lg LEFT JOIN llistats_groups_description lgd ON lg.id = lgd.groups_id AND lgd.language_id = '2' WHERE lg.parent_id = AND lg.ACTIVE = 1 ORDER BY lg.listorder
No hay elementos