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