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 gb7y_image_category
    INNER JOIN gb7y_images ON id = image_id
  WHERE
    category_id = 12
AND (category_id NOT IN (73,88,90,91,101,106,108,110,112,113,116,117,118,122,123,124,125,126,127,144,8,24,47,72,74,3) AND level<=0)
   ORDER BY rank ASC
; in /var/www/clients/client16229/web10182/web/include/dblayer/functions_mysqli.inc.php on line 847