SELECT pt.name, pt.slug, p.id, pt.field1, i.image
	    FROM pages p 
	    INNER JOIN pages_text pt ON p.id = pt.page_id AND pt.language_id = 1
	    INNER JOIN images i ON p.id = i.page_id
	    WHERE p.status != 'deleted'
	    AND p.category = 'offers'
	    AND p.top_offer = 'yes'
	    ORDER BY RAND()
	    LIMIT 9
	    

Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")