# ~~~~~~~~~~~~~~~~~~~~~~~~~~
# Veranstaltungsreihen lesen
# ~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT
 trm1.veranstaltungsreihe
,COUNT(*)     anzahl_events
,MIN(tag)     min_tag
,MAX(tag)     max_tag

FROM    bia_termine trm1
WHERE   trm1.veranstaltungsreihe IS NOT NULL
AND     trm1.veranstaltungsreihe > '@'
AND     trm1.tag  >= CURDATE()
AND    (trm1.tag_bis IS NULL OR trm1.tag_bis  >= CURDATE())
AND     trm1.intern_kz  = 0
AND    (trm1.gesperrt_bis IS NULL OR trm1.gesperrt_bis <= NOW())
GROUP BY trm1.veranstaltungsreihe
sounding calendar for europe - remso.eu

14 Leser und 129 Suchmaschinen haben uns in den letzten 60 Minuten besucht.

Series of events:   EuropaCup (2)   HRIV FutureCup (3)   Mühlentag (4)   Swiss Skate Tour (5)


Sorry, this should not happen!

Today (24.5.) early in the morning, events in the detail display were reported erroneously as not (more) available. The program saw a blocking period for all events, that means the date / time, before an event may not be published. The bug is fixed.


1015 futue events in 351 places and 16 nations.

Where is something going on? Enter the zip code or the name of your home- or holiday place and find the best events within a radius of 20km. Oder ein Datum in der Form TT.MM., deinen Verein oder den Titel einer Veranstaltung.

Free of charge: Enter public events of your association and your city yourself.


Here's what's on the ears. Click here

The audio samples are provided by the participants and are available on their servers.

Shanty-Chor "Die Landratten"

icon

Leise kommt die Nacht

Shanty-Chor-Spaden e.V.

icon

Über alle sieben Meere

Shanty-Chor Berlin e.V.

icon

Wir sind der Shanty-Chor Berlin

test HR4 x   p510_de | remso\'s gast | 0.069 sec