[SELECT evenement_id, plaats, gelegenheid, locatie, locatie_overig, 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, website, openingstijden, programma, info, lat, lng, type, gewicht FROM evenementen2026 WHERE plaats LIKE '%'s-Gravenzande%' AND zichtbaar = 1 ORDER BY gewicht, datum_begin]