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 IN (29,41,42,176,177,203,210,212,219,227,228,230,456,339,340,345,388,389,390,451,452,453,454,455,458,457,459,463,464,465,466,467,468,469,470,471,476,477,478,479,480,481,482,496,497,498,499,503,504,505,506,507,508,509,512,521,522,527,528,529,533,534,535,544,545)
    AND (id IN (-1))
   AND date_creation BETWEEN '2013-01-01' AND '2013-12-31 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