MySQL returned error

Error Description :

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

SQL Query
SELECT commercial_property.*, enquiry_type.name AS enquiry_type_name FROM commercial_property LEFT JOIN enquiry_type AS enquiry_type ON(enquiry_type.id=commercial_property.property_sub_type) WHERE commercial_property.id!=0 AND (commercial_property.status='Active' AND commercial_property.show_property='Yes') ORDER BY RAND(1996551194) LIMIT 10