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

SELECT DISTINCT(id)
  FROM piwisq_images
    INNER JOIN piwisq_image_category AS ic ON id = ic.image_id
  WHERE hit > 0
    
     ORDER BY hit DESC, id DESC
  LIMIT 15
; in /home/bonsaipe/public_html/foto/include/dblayer/functions_mysqli.inc.php on line 832