SELECT I.*
FROM images I
JOIN i_tags IT ON (I.image_id = IT.image_id)
WHERE IT.tag_id = 22
ORDER BY v DESC, image_id DESC
LIMIT 1650, 50
Disk full (/tmp/#sql-temptable-1ea96d-160bed3d-9a96a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")