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 = '3'
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 = '3'
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 = '3'
WHERE lg.parent_id =
AND lg.ACTIVE = 1
ORDER BY lg.listorder