Error Number: 1021
Disk full (/var/tmp/#sql_6a74_0); 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