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