MySQL returned error

Error Description :

Error No : 1
Description : Can't create/write to file '/tmp/#sql-temptable-138055-3554da-b7a.MAI' (Errcode: 28 "No space left on device")

SQL Query
SELECT product_master.*, product_category.name AS product_category_name, product_category.seo_url AS product_category_seo_url FROM product_master LEFT JOIN product_category AS product_category ON(product_category.id=product_master.category_id) WHERE product_master.id!=0 AND (product_master.status='Active' AND product_master.category_id=52 AND online_order='Yes') ORDER BY RAND() LIMIT 10