[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 evenementen2025 WHERE plaats LIKE '%'s-Gravenzande%' AND zichtbaar = 1 ORDER BY gewicht, datum_begin]