Find Irish media and creative businesses

DB Error: selectList query failed

SELECT DISTINCT companies.* FROM companies LEFT JOIN directory_categories_has_companies ON directory_categories_has_companies.companies_id = companies.id LEFT JOIN directory_categories ON directory_categories.id = directory_categories_has_companies.directory_categories_id LEFT JOIN directory_categories AS directory_categories_parent ON directory_categories.parent_id = directory_categories_parent.id LEFT JOIN contacts ON contacts.companies_id = companies.id WHERE ( published = 1 )ORDER BY companies.priority DESC, companies.name ASC LIMIT 20, 20

Can't create/write to file '/tmp/#sql_c0a_21.MAI' (Errcode: 28 "No space left on device")