UUDISED

Mai 2024
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

SELECT *, DATE_FORMAT(dt1, '%d.%m.%Y') as kp1, IF(dt2, DATE_FORMAT(dt2, '%d.%m.%Y'), 0) kp2 FROM maa_event t1 LEFT JOIN maa_event_text t2 ON t2.event_id=t1.id AND t2.lang_id='est' LEFT JOIN maa_event_group_node t3 ON t3.event_id=t1.id WHERE archive='false' AND t1.pk_alates<=CURDATE() AND t1.pk_kuni>=CURDATE()  GROUP BY t1.id ORDER BY dt1 DESC

Disk full (/tmp/#sql-temptable-466-3b7a8e-735bfd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")