[SELECT Plaats, gelegenheid, Locatie, CONCAT( (CASE DATE_FORMAT(datum_begin, '%w') WHEN '0' THEN 'zo' WHEN '1' THEN 'ma' WHEN '2' THEN 'di' WHEN '3' THEN 'wo' WHEN '4' THEN 'do' WHEN '5' THEN 'vr' WHEN '6' THEN 'za' END), ' ', (DATE_FORMAT(datum_begin, '%d')), ' ', (CASE DATE_FORMAT(datum_begin, '%m') WHEN '01' THEN 'januari' WHEN '02' THEN 'februari' WHEN '03' THEN 'maart' WHEN '04' THEN 'april' WHEN '05' THEN 'mei' WHEN '06' THEN 'juni' WHEN '07' THEN 'juli' WHEN '08' THEN 'augustus' WHEN '09' THEN 'september' WHEN '10' THEN 'oktober' WHEN '11' THEN 'november' WHEN '12' THEN 'december' END) ) AS Van, CONCAT( (CASE DATE_FORMAT(datum_eind, '%w') WHEN '0' THEN 'zo' WHEN '1' THEN 'ma' WHEN '2' THEN 'di' WHEN '3' THEN 'wo' WHEN '4' THEN 'do' WHEN '5' THEN 'vr' WHEN '6' THEN 'za' END), ' ', (DATE_FORMAT(datum_eind, '%d')), ' ', (CASE DATE_FORMAT(datum_eind, '%m') WHEN '01' THEN 'januari' WHEN '02' THEN 'februari' WHEN '03' THEN 'maart' WHEN '04' THEN 'april' WHEN '05' THEN 'mei' WHEN '06' THEN 'juni' WHEN '07' THEN 'juli' WHEN '08' THEN 'augustus' WHEN '09' THEN 'september' WHEN '10' THEN 'oktober' WHEN '11' THEN 'november' WHEN '12' THEN 'december' END) ) AS Tot, DATEDIFF(datum_eind, CURRENT_DATE()) + 1 AS 'Rest. dagen*²', Website, evenement_id, programma, type, gewicht FROM evenementen2026 WHERE (CURRENT_DATE() <= datum_eind AND CURRENT_DATE() >= datum_begin) AND gewicht <> 0 AND zichtbaar = 1 ORDER BY gewicht, datum_eind, plaats]