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 id = image_id
  WHERE
    category_id = 477
AND (category_id NOT IN (20,312,313,314,315,316,317,318) AND category_id IN (-1) AND id IN (-1))
   ORDER BY date_available DESC, file ASC, id ASC
; in /var/www/html/bayramgocmen/album/include/dblayer/functions_mysql.inc.php on line 656

Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7

SELECT
  c.*, nb_images, date_last, max_date_last, count_images, count_categories
  FROM piwigo_categories c INNER JOIN piwigo_user_cache_categories
  ON id = cat_id and user_id = 2
  WHERE id_uppercat = 477
AND (id IN (-1))
  ORDER BY rank
; in /var/www/html/bayramgocmen/album/include/dblayer/functions_mysql.inc.php on line 656