class.mysql.php : 1021 - Disk full (/tmp/#sql-temptable-24ffc3-564f9b-5374c3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") - SELECT ogl.id, ogl.ident, ogl.title, ogl.category, ogl.city, ogl.city_rw, ogl.country, ogl.cost, ogl.cost_notice, ogl.cost_currency, ogl.for_free, ogl.status, ogl.display, ogl.forever, ogl.urgent, ogl.create_date, ogl.whole_country, ogl.company_id, pay.pay_expire AS view_till, pay_promoted.pay_expire AS promoted_till, (SELECT GROUP_CONCAT(ph.photo_filename ORDER BY ph.photo_main = 'YES' DESC) FROM oglo2_announcement_photos AS ph WHERE ph.photo_announcement_id = ogl.id) AS photos FROM oglo2_announcement AS ogl LEFT JOIN oglo2_announcement_payments AS pay ON ogl.ident=pay.pay_ident AND pay.pay_type='VIEW' INNER JOIN oglo2_announcement_payments AS pay_promoted ON ogl.ident=pay_promoted.pay_ident AND pay_promoted.pay_type='PROMOTED' AND pay_promoted.pay_expire >= NOW() LEFT JOIN oglo2_company AS comp ON (comp.company_id = ogl.company_id AND comp.company_uid > 0) WHERE (ogl.status='ACCEPT' OR ogl.status='NOT_CONFIRMED') AND ogl.display = 'TRUE' AND (((pay.pay_create <= '2024-09-04' OR pay.pay_create <= '2025-08-30' OR pay.pay_create IS NULL) AND pay.pay_expire >= '2024-09-04') OR ogl.forever = 'TRUE') AND ((ogl.city LIKE '%sokolow-podlaski%' OR ogl.city_rw LIKE '%sokolow-podlaski%') OR (ogl.whole_country = 'TRUE'))  AND ogl.category IN (1415,1416,1417,1261) ORDER BY RAND() LIMIT 4