Warning:  [mysql error 3065] Expression #1 of ORDER BY clause is not in SELECT list, references column 'bonsaipe_piwi582.piwisq_image_category.rank' which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT(image_id)
  FROM piwisq_image_category
    INNER JOIN piwisq_images ON id = image_id
  WHERE
    category_id = 3

   ORDER BY rank ASC
; in /home/bonsaipe/public_html/foto/include/dblayer/functions_mysqli.inc.php on line 832