1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 6
SELECT e.id,e.active,e.listorder,e.group_id,e.lat,e.lon,e.autor,e.link,e.generic1,e.generic2,e.generic3,e.generic4,e.generic5,e.json as json_llistat,
e.inscripcions,e.fotos_groups_id,e.published,ed.language_id,ed.titol,ed.titol2,ed.titol3,ed.descripcio,ed.descripcio2,ed.json,
ed.descripcio3,ed.descripcio4,ed.descripcio5,ed.download,e.image,e.ids_documentacio
FROM llistats e
LEFT JOIN llistats_description ed ON e.id = ed.llistats_id AND ed.language_id = '1'
WHERE e.id =
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 6
SELECT e.id,e.active,e.listorder,e.group_id,e.lat,e.lon,e.autor,e.link,e.generic1,e.generic2,e.generic3,e.generic4,e.generic5,e.json as json_llistat,
e.inscripcions,e.fotos_groups_id,e.published,ed.language_id,ed.titol,ed.titol2,ed.titol3,ed.descripcio,ed.descripcio2,ed.json,
ed.descripcio3,ed.descripcio4,ed.descripcio5,ed.download,e.image,e.ids_documentacio
FROM llistats e
LEFT JOIN llistats_description ed ON e.id = ed.llistats_id AND ed.language_id = '1'
WHERE e.id =
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 6
SELECT e.id,e.active,e.listorder,e.group_id,e.lat,e.lon,e.autor,e.link,e.generic1,e.generic2,e.generic3,e.generic4,e.generic5,e.json as json_llistat,
e.inscripcions,e.fotos_groups_id,e.published,ed.language_id,ed.titol,ed.titol2,ed.titol3,ed.descripcio,ed.descripcio2,ed.json,
ed.descripcio3,ed.descripcio4,ed.descripcio5,ed.download,e.image,e.ids_documentacio
FROM llistats e
LEFT JOIN llistats_description ed ON e.id = ed.llistats_id AND ed.language_id = '1'
WHERE e.id =
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 6
SELECT e.id,e.active,e.listorder,e.group_id,e.lat,e.lon,e.autor,e.link,e.generic1,e.generic2,e.generic3,e.generic4,e.generic5,e.json as json_llistat,
e.inscripcions,e.fotos_groups_id,e.published,ed.language_id,ed.titol,ed.titol2,ed.titol3,ed.descripcio,ed.descripcio2,ed.json,
ed.descripcio3,ed.descripcio4,ed.descripcio5,ed.download,e.image,e.ids_documentacio
FROM llistats e
LEFT JOIN llistats_description ed ON e.id = ed.llistats_id AND ed.language_id = '1'
WHERE e.id =
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 6
SELECT e.id,e.active,e.listorder,e.group_id,e.lat,e.lon,e.autor,e.link,e.generic1,e.generic2,e.generic3,e.generic4,e.generic5,e.json as json_llistat,
e.inscripcions,e.fotos_groups_id,e.published,ed.language_id,ed.titol,ed.titol2,ed.titol3,ed.descripcio,ed.descripcio2,ed.json,
ed.descripcio3,ed.descripcio4,ed.descripcio5,ed.download,e.image,e.ids_documentacio
FROM llistats e
LEFT JOIN llistats_description ed ON e.id = ed.llistats_id AND ed.language_id = '1'
WHERE e.id =
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND pi.groups_id=58
AND l.active = 1
...' at line 6
SELECT pi.products_id,pi.llistats_id,pi.listorder
FROM products_llistats pi
LEFT JOIN products p ON pi.products_id=p.id
LEFT JOIN llistats l ON l.id = pi.llistats_id
WHERE pi.products_id=
AND pi.groups_id=58
AND l.active = 1
ORDER BY pi.listorder