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 (31,39,43,44,66,67,68,71,72,73,104,115,122,123,124,127,136,137,138,152,158,161,177,179,180,190,220,225,226,228,231,234,324,326,332,334,345,346,347,366,370,371,372,373,374,375,376,377,385,386,387,388,389,390,404,405,406,407,410,411,429,430,431,432,464,466,467,468,469,470,471,472,473,649,651,676,677,678,679,680,695,717,718,719,723,725,730,731,732,746,747,748,750,751,752,753,754,755,756,757,758,761,762,765,770,771,772,773,774,775,777,779,782,783,784,806,807,808,809,811,812,814,815,816,817,821,822,823,827,828,829,830,831,832,833,834,835,836,837,841,842,847,848,851,854,855,856,857,860,861,862,863,864,865,866,867,868,869,870,871,872,885,886,887,888,889,890,891,893,894,911,934,935,936,937,952 in /var/www/html/bayramgocmen/album/include/dblayer/functions_mysql.inc.php on line 656