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 piwi_image_category
    INNER JOIN piwi_images ON id = image_id
  WHERE
    category_id = 47
AND (category_id NOT IN (4,8,26,28,29,30,31,33,34,35,38,39,40,41,116,121,122,123,124,137))
   ORDER BY rank ASC
; in /home/juppycom/public_html/ebay-pictures/2/include/dblayer/functions_mysqli.inc.php on line 847