MySQL returned error

Error Description :

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

SQL Query
SELECT product_master.*, product_category.id AS product_category_id, product_category.store_id AS product_category_store_id, product_category.parent_id AS product_category_parent_id, product_category.name AS product_category_name, product_category.image AS product_category_image, product_category.sort_order AS product_category_sort_order, product_category.in_website_menu AS product_category_in_website_menu, product_category.seo_url AS product_category_seo_url, product_category.meta_title AS product_category_meta_title, product_category.meta_description AS product_category_meta_description, product_category.meta_keywords AS product_category_meta_keywords, product_category.variant_option AS product_category_variant_option, product_category.variant_01_id AS product_category_variant_01_id, product_category.variant_02_id AS product_category_variant_02_id, product_category.price_setting AS product_category_price_setting, product_category.admin_user_id AS product_category_admin_user_id, product_category.status AS product_category_status, product_category.created AS product_category_created, product_category.updated AS product_category_updated 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 online_order='Yes' AND latest='Yes' AND product_master.store_id=1) ORDER BY RAND() LIMIT 10