[SELECT Plaats, gelegenheid, Locatie, CONCAT( (CASE DATE_FORMAT(datum_begin, '%w') WHEN '0' THEN 'zondag' WHEN '1' THEN 'maandag' WHEN '2' THEN 'dinsdag' WHEN '3' THEN 'woensdag' WHEN '4' THEN 'donderdag' WHEN '5' THEN 'vrijdag' WHEN '6' THEN 'zaterdag' 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), ' ', (DATE_FORMAT(datum_begin, '%Y')) ) AS Van, CONCAT( (CASE DATE_FORMAT(datum_eind, '%w') WHEN '0' THEN 'zondag' WHEN '1' THEN 'maandag' WHEN '2' THEN 'dinsdag' WHEN '3' THEN 'woensdag' WHEN '4' THEN 'donderdag' WHEN '5' THEN 'vrijdag' WHEN '6' THEN 'zaterdag' 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), ' ', (DATE_FORMAT(datum_eind, '%Y')) ) AS Tot, CONCAT( (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 Vanmaand, CONCAT( (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 Totmaand, CONCAT( (DATE_FORMAT(datum_begin, '%Y')) ) AS Vanjaar, CONCAT( (DATE_FORMAT(datum_eind, '%Y')) ) AS Totjaar, DATEDIFF(datum_eind, CURRENT_DATE()) AS 'Rest. dagen*²', Website, evenement_id, programma, type, cat, gewicht FROM evenementen2017 WHERE evenement_id=Apeldoorn]