Error Number: 1021

Disk full (/var/tmp/#sql_a8b_3); waiting for someone to free some space...

SELECT a.id, a.date, a.time, a.title, a.fullnews, a.image_path, b.path, ( SELECT path FROM pages WHERE id = b.parent LIMIT 1 ) AS root_path, MATCH (a.title, a.fullnews, a.tags) AGAINST ('Строительство') AS relev FROM news AS a JOIN pages AS b ON b.id = a.category WHERE a.is_delete = 0 AND a.available = 1 AND a.date <= '2025-02-19' HAVING relev > 0 ORDER BY relev DESC