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 ) AND ( directory_categories.uri = 'directories'OR directory_categories_parent.uri = 'directories')ORDER BY companies.priority DESC, ASC LIMIT 0, 20

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