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 (7,8,33,62,63,101,348,413,414,530,531,532,533,534,535,536,537,539,540,541,542,543,544,545,546,547,548,549,550,551,595,596,597,598,599,600,601,602,603,604,605,804,993,994,1232,1249,1250,1251,1252,1253,1254,1255,1286,1287,1293,1420,1421,1422,1423,1483,1484,1485,1486,2030,2031,2032,2033,2034,2035,2380,2381,2419,2427,2428,2429,2517,2518,2519,2520,2521,2526,2527,2528,2529,2530,2531,2532,2638,2639,2640,2641,2642,2643,2648,2649,2756,2798,2799,2800,2801,2802,2803,2804,2859,2860,2861,2862,2912,2913)
    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