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 'ASC, date_creation DESC, id ASC' at line 7

SELECT DISTINCT(image_id)
  FROM piwigo_PV_image_category
    INNER JOIN piwigo_PV_images ON id = image_id
  WHERE
    category_id = 111
AND (category_id NOT IN (14,15,23,24,25,26,41,42,43,44,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,66,67,69,70,71,72,73,74,81,82,88,91,92,93,95,96,97,98,101,103,104,105,106,107,108,109,110,112,113,114,115,116,117,120,119,121,124,125,126,127,78,89) AND level<=0)
  ORDER BY rank ASC, date_creation DESC, id ASC
; in /home/pascalvi/www/include/dblayer/functions_mysqli.inc.php on line 830