SELECT DISTINCT(id),path,file,date_available
       ,tn_ext,name,filesize,storage_category_id,average_rate
  FROM phpwebgallery_images AS i
    INNER JOIN phpwebgallery_image_category AS ic ON id=ic.image_id
   WHERE category_id = 8
   ORDER BY date_available DESC, file ASC, id ASC
  LIMIT 80,20
;
[mysql error 1226] User 'navires' has exceeded the 'max_questions' resource (current value: 40000)