Warning: [mysql error 3065] Expression #1 of ORDER BY clause is not in SELECT list, references column 'giwawa_piwigo.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 = 7
ORDER BY date_available DESC, file ASC, id ASC
; in /home/giwawa/domains/giwawa.com/public_html/photo/include/dblayer/functions_mysqli.inc.php on line 830
Fatal error: Call to a member function fetch_assoc() on boolean in /home/giwawa/domains/giwawa.com/public_html/photo/include/dblayer/functions_mysqli.inc.php on line 891