SELECT i.id as id, i.image,
 					i.link as link,
 					it.name as name,
 					it.text as text
 			FROM images i INNER JOIN images_text it
 			ON i.id = it.image_id
 			WHERE it.language_id=2
 			AND i.page_id = 1143
 			ORDER BY i.main, it.name
			

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