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

SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    category_id = 98
AND (category_id NOT IN (73,14,21,43,75,108,113))
  ORDER BY date_available DESC, file ASC, id ASC, hit DESC
; in /home/arty16/domains/arty16.com/public_html/gallery/include/dblayer/functions_mysqli.inc.php on line 830