( ! ) Warning: [mysql error 3065] Expression #1 of ORDER BY clause is not in SELECT list, references column 'fan-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 image_id=id
  WHERE image_id IN (854,855,856,857,858,859,1231,1232,1785,1787,1852,1853,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033)
    AND (category_id NOT IN (79)) ORDER BY date_available DESC, file ASC, id ASC
; in /wwwroot/www.drowtales.com/html/fan-gallery/include/dblayer/functions_mysql.inc.php on line 656
Call Stack
#
Time
Memory
Function
Location
1
0.0001
229288
{main}(  )
.../index.php:0
2
0.0195
701720
include( '/wwwroot/www.drowtales.com/html/fan-gallery/include/section_init.inc.php' )
.../index.php:27
3
0.0210
710960
array_from_query(  )
.../section_init.inc.php:336
4
0.0210
711096
pwg_query(  )
.../functions_mysql.inc.php:201
5
0.0214
711344
my_error(  )
.../functions_mysql.inc.php:90
6
0.0214
712024
trigger_error
(  )
.../functions_mysql.inc.php:656