[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 = 10
AND (category_id NOT IN (213,259,32,17,329,328,362,285,151) AND level<=0)
   ORDER BY rank ASC
;