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 = LEFT JOIN directory_categories ON = directory_categories_has_companies.directory_categories_id LEFT JOIN directory_categories AS directory_categories_parent ON directory_categories.parent_id = LEFT JOIN contacts ON contacts.companies_id = WHERE ( published = 1 )ORDER BY companies.priority DESC, ASC LIMIT 180, 20

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