Warning:  [mysql error 3065] Expression #3 of ORDER BY clause is not in SELECT list, references column 'prieyah27096com39345_album.piwigo_images.file' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT id ,date_available FROM piwigo_images
INNER JOIN piwigo_image_category ON id = image_id
WHERE category_id IN (593,594,595,596,597,598,599,600,601,602,603,604,636)
    AND (id IN (-1))
   AND date_available IS NOT NULL
   ORDER BY date_available DESC, date_available DESC, file ASC, id ASC in /var/www/html/bayramgocmen/album/include/dblayer/functions_mysql.inc.php on line 656