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' at line 7

SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    category_id = 142
AND (category_id NOT IN (9,10,13,23,24,30,34,37,38,39,55,85,91,92,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,119,120,121,122,128,130,134,146,160,184,205,206,207,208,218,219,222,223,224,226,232,236,237,238,239,240,241,242,243,245,246,250,251,252,258,259,261,262,263,264,265,266,267,161,162,170,171) AND level<=0)
   ORDER BY rank ASC
; in /home/lesphotoz/www/include/dblayer/functions_mysqli.inc.php on line 847