Warning: [mysql error 3065] Expression #1 of ORDER BY clause is not in SELECT list, references column 'zoqmzxaz_fis_gallery.fisgallery_images.date_available' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT(image_id)
FROM fisgallery_image_category
INNER JOIN fisgallery_images ON id = image_id
WHERE
category_id = 1
AND (category_id NOT IN (4))
ORDER BY date_available DESC, file ASC, id ASC
; in /home/zoqmzxaz/public_html/fis_gallery/include/dblayer/functions_mysqli.inc.php on line 832
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /home/zoqmzxaz/public_html/fis_gallery/include/dblayer/functions_mysqli.inc.php:893
Stack trace:
#0 /home/zoqmzxaz/public_html/fis_gallery/include/section_init.inc.php(318): query2array('\nSELECT DISTINC...', NULL, 'image_id')
#1 /home/zoqmzxaz/public_html/fis_gallery/picture.php(26): include('/home/zoqmzxaz/...')
#2 {main}
thrown in /home/zoqmzxaz/public_html/fis_gallery/include/dblayer/functions_mysqli.inc.php on line 893