Warning:  [mysql error 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 'groups, show_title, id_line, width
FROM piwigo_PV_stuffs
LEFT JOIN piwigo_PV_u' at line 1

SELECT DISTINCT id, name, path, datas, groups, show_title, id_line, width
FROM piwigo_PV_stuffs
LEFT JOIN piwigo_PV_user_group
  ON user_id = 2
WHERE (users IS NULL OR users LIKE "%guest%")
  AND (groups IS NULL OR groups REGEXP CONCAT("(^|,)",group_id,"(,|$)"))
  AND level <= 0
  AND on_picture = "true"
ORDER BY pos ASC
; in /home/pascalvi/www/include/dblayer/functions_mysqli.inc.php on line 830