[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 'jan'
WHEN '02' THEN 'feb'
WHEN '03' THEN 'mrt'
WHEN '04' THEN 'apr'
WHEN '05' THEN 'mei'
WHEN '06' THEN 'jun'
WHEN '07' THEN 'jul'
WHEN '08' THEN 'aug'
WHEN '09' THEN 'sept'
WHEN '10' THEN 'okt'
WHEN '11' THEN 'nov'
WHEN '12' THEN 'dec'
END),
' ',
(DATE_FORMAT(datum_begin, ''%y'))
) 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 'jan'
WHEN '02' THEN 'feb'
WHEN '03' THEN 'mrt'
WHEN '04' THEN 'apr'
WHEN '05' THEN 'mei'
WHEN '06' THEN 'jun'
WHEN '07' THEN 'jul'
WHEN '08' THEN 'aug'
WHEN '09' THEN 'sept'
WHEN '10' THEN 'okt'
WHEN '11' THEN 'nov'
WHEN '12' THEN 'dec'
END),
' ',
(DATE_FORMAT(datum_eind, ''%y'))
) AS Tot, website, openingstijden, programma, info, lat, lng, cat, buitenland, land, type, gewicht, ( 6371 * acos( cos( radians() ) * cos( radians( lat ) ) * cos( radians( lng ) - radians() ) + sin( radians() ) * sin( radians( lat ) ) ) ) AS afstand FROM evenementen2024 WHERE zichtbaar = 1 HAVING afstand < 10 ORDER BY afstand, datum_begin]
Actueel Vooruitzicht Terugblik Jaaroverzicht 2024 - 2025 ---------------------- Oktober 2024 November 2024 December 2024 Januari 2025 Februari 2025 Maart 2025 ---------------------- Kerstmarkten 2024 Vuurwerkshows 2024 - 2025 IJsbanen 2024 - 2025 Wintercircussen 2024 - 2025 Winterkermissen 2024 - 2025 IJssculpturen 2024 - 2025 Winterparades 2024 - 2025 Sinterklaas 2024 - 2025 Overig 2024 - 2025 ---------------------- Buitenland tips
