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 ' file ASC, id ASC' at line 8

SELECT id
  FROM piwigo_images i
    INNER JOIN piwigo_image_category ic ON id=ic.image_id
  WHERE category_id IN (1,4)
  AND (category_id NOT IN (17,38,39,22,40))
  GROUP BY id
  HAVING COUNT(DISTINCT category_id)=2
ORDER BY , file ASC, id ASC in /var/www/vhosts/pedregateam.enpreproduccion.com/media.pedregateam.com/include/dblayer/functions_mysqli.inc.php on line 847