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 piwif2_image_category
    INNER JOIN piwif2_images ON id = image_id
  WHERE
    category_id = 47
AND (category_id NOT IN (1,4,7,6,8,9,10,11,12,13,14,17,16,18,19,20,21,22,23,24,25,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65))
   ORDER BY rank ASC
; in /home/positi9/public_html/fireandice/piwigo2/include/dblayer/functions_mysqli.inc.php on line 847