Error!

MySQL Error: Error writing file '/tmp/MYfd=1235' (OS errno 28 - No space left on device)
SQL Statement: SELECT taxonomy.*, count(DISTINCT contents.id) as count FROM contents JOIN content_taxonomy on content_taxonomy.content_id = contents.id JOIN content_locations on content_locations.content_id=contents.id JOIN locations on content_locations.location_id=locations.id JOIN taxonomy on taxonomy.id=content_taxonomy.taxonomy_id JOIN asset_packages on asset_packages.resource_id = contents.id WHERE contents.content_type_id = 2543 AND taxonomy.child_of = '12043' and contents.publish_date <= '2024-06-04 03:00:00' and contents.published=1 and contents.magazine_id=11 and asset_packages.published = 1 and asset_packages.resource = contents.resource_id and asset_packages.expire_at>= '2024-06-04 03:00:00' and locations.state='BW' and locations.country='DE' group by content_taxonomy.taxonomy_id ORDER BY taxonomy.ignore_flag,taxonomy.tag asc