Error 1021:
Disk full (/tmp/#sql_2d0_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

On query:
SELECT SQL_CALC_FOUND_ROWS i.title as title, i.image as file FROM actors_on_images aoi, images i WHERE aoi.moderated=1 AND i.id = aoi.image_id AND aoi.actor_id= 992 ORDER BY i.id LIMIT 0, 12