SELECT I.* FROM images I JOIN i_tags IT ON (I.image_id = IT.image_id) WHERE IT.tag_id = 9 ORDER BY v DESC, image_id DESC LIMIT 52550, 50
Error writing file '/tmp/#sql-temptable-141226-3ba8f-3e8.MAD' (Errcode: 28 "No space left on device")