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 J2M_image_category
    INNER JOIN J2M_images ON id = image_id
  WHERE
    category_id = 214
AND (category_id NOT IN (20,21,22,26,27,28,31,34,35,44,45,50,55,56,60,65,67,69,70,71,75,80,101,107,112,113,114,115,116,120,121,123,124,125,127,133,134,159,166,171,172,173,174,175,176,183,184,185,186,188,194,201,202,217,219,226,230,231,242,256,257,258,259,260,264,265,278,296,297,298,299,307,308,309,314,321,322,326,327,337,328,329,330,331,332,333,334,335,336,351,352,353,354,355,356,357,358,363,225,359,182) AND level<=0)
   ORDER BY rank ASC
; in /home/jeanmarcqn/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 847