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 (103,139,140,145,146,159,191,192,193,197,284,286,287,301,302,307,313,314,320,1066,1067,1077,1088,1089,1090,1092,1109,1110,1113,1114,1117,1124,1125,1192,1193,1194,1195,1196,1197,1270,1271,1272,1273,1274,1307,1308,1312,1313,1327,1328,1332,1333,1779,1780,1781,1782,1783,1784,1785,1814,1815,1816,1923,1924,1926,1927,1993,2101,2102,2103,2104,2105,2106,2114,2115,2116,2129,2130,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,2235,2238,2306,2307,2327,2328,2329,2330,2516,2537,2538,2539,2808)
    AND (category_id NOT IN (20,312,313,314,315,316,317,318)) ORDER BY date_available DESC, file ASC, id ASC
; in /var/www/html/bayramgocmen/album/include/dblayer/functions_mysql.inc.php on line 656