Warning:  [mysql error 3065] Expression #2 of ORDER BY clause is not in SELECT list, references column 'prieyah27096com39345_album.piwigo_images.date_available' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT id ,date_creation FROM piwigo_images
INNER JOIN piwigo_image_category ON id = image_id
    WHERE (category_id NOT IN (20,312,313,314,315,316,317,318) AND category_id IN (-1) AND id IN (-1))
   AND date_creation BETWEEN '2009-05-27' AND '2009-05-27 23:59:59'
   ORDER BY date_creation ASC, date_available DESC, file ASC, id ASC in /var/www/html/bayramgocmen/album/include/dblayer/functions_mysql.inc.php on line 656