Can't create/write to file '/tmp/#sql_83a_0.MYI' (Errcode: 28)

---

SELECT t1.*, t2.thumbnail FROM SC_products t1 LEFT JOIN SC_product_pictures t2 ON t1.default_picture=t2.photoID WHERE t1.enabled=1 and ( t1.productID='4907' or t1.productID='4978' or t1.productID='5282' or t1.productID='5068' or t1.productID='5196' or t1.productID='5060' or t1.productID='5209' or t1.productID='5190' or t1.productID='5124' ) ORDER BY RAND() LIMIT 5