Warning:  [mysql error 3065] Expression #1 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 image_id
  FROM piwigo_image_category INNER JOIN piwigo_images ON image_id=id
  WHERE image_id IN (14,15,16,17,35,38,40,41,42,128,133,143,144,147,156,157,162,163,169,170,172,173,186,187,189,202,208,217,218,222,242,243,244,245,246,256,257,265,272,273,274,289,290,308,310,378,380,381,520,521,522,523,524,525,526,527,528,529,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,581,582,583,584,585,586,587,588,589,590,591,592,593,594,606,607,608,609,610,611,612,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,650,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,687,688,724,749,780,786,938,939,940,941,947,948,1134,1135,1136,1137,1138,1139,1140,1141,1148,1149,1150,1151,1152,1207, in /var/www/html/bayramgocmen/album/include/dblayer/functions_mysql.inc.php on line 656