# ~~~~~~~~~~~~~~~~~~~~~~~~~~
# 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

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


956 futue events in 331 places and 16 nations.

21 readers and 33 search engines have visited us in the last 60 minutes and called 758 pages. Every 4.7 seconds a page.

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.

New project: Data import from our members

In future, remso will offer the option to upload event datas via comma separated value (CSV). For the test phase, I am looking for webmasters who can create CSV files from their spreadsheet program..

Please write a short messsage to me: osmer.kh at osmer.de


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 Witten

icon

Auf der Reeperbahn nachts um halb eins

Shanty-Chor Brinkum e.V.

icon

Die Windjammer kommen

Kammerchor Hannover e.V.

icon

Ich glaube nicht an das Recht des Stärkeren

Schifferchor Rekum von 1978 e.V.

icon

He du alter Seebär

test HR4 x   p510_de | remso's gast | 0.074 sec