# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
# Termine ORT und Umkreis lesen
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT
 SQL_CALC_FOUND_ROWS
 trm1.*
,trm1.id                    TID
,DATE_FORMAT(trm1.tag,'%w') wotag
,IF ( trm1.festival_kz = '1', trm1.id, IF( trm1.gastgebende_TID IS NOT NULL AND trm1.gastgebende_TID > '0', gastgebende_TID +1, '99999' ) )  festival_id # 2017-05-27
,IF ( trm1.festival_kz = '1', '0', '1' )  festival_sort  # Festivals vor Teilnehmer

#,trm1.mp3_titel
#,trm1.mp3_url
,trm1.html_position_lang
,trm1.html_position_kurz

,ort1.land_kz
,ort1.plz
,ort1.name    ort_name
,ROUND( 6366.0 * ACOS( SIN(0.898996408422) *SIN(RADIANS(ort1.geo_breite)) +COS(0.898996408422) *COS(RADIANS(ort1.geo_breite)) *COS(RADIANS(ort1.geo_laenge) -0.12800157467664 ))) distanz_km
,adr1.id      VIP
,adr1.firma1
,trp1.id          TRP
,trp1.bild_url    trp_bild_url  -- fuer icon_webcam
,typ1.id          TYP
,typ1.name    typ_name
FROM        (bia_termine trm1
            ,bia_orte ort1 )

LEFT JOIN   bia_adressen adr1
ON          adr1.id = trm1.adress_id

LEFT JOIN   bia_treffpunkte trp1
ON          trp1.id = trm1.treffpunkt_id

LEFT JOIN   bia_termintypen typ1
ON          typ1.id = trm1.typ_id

WHERE       trm1.owner_id = '1'
AND         ort1.id = trm1.ort_id
# Filter:

AND        (trm1.gesperrt_bis IS NULL OR trm1.gesperrt_bis <= NOW())
AND         trm1.intern_kz = 0
AND         (trm1.tag >= '2019-03-24' OR  trm1.tag_bis >= '2019-03-24' )
AND         (trm1.tag <= '2020-03-23' OR  trm1.tag_bis <= '2020-03-23' )
#AND         ROUND( 6366.19773095 * ACOS( SIN(0.898996408422) *SIN(RADIANS(ort1.geo_breite)) +COS(0.898996408422) *COS(RADIANS(ort1.geo_breite)) *COS(RADIANS(ort1.geo_laenge) -0.12800157467664 ))) <= '20'
#AND          ort1.id IN (7927,7927,7961,7926,7953,7960,7932,7908,7931,7946,7952,7923,7925,7937,8926,7954,8927,7951,7933,7902,7907,7910,7924,7935,7938,7944,7945,7950,7903,7909,7936,8924,8925,7955,7934,7901,7911,7939,7947,7948,7949,7906,7922,7942,8010,7904,7912,8921,7941,8009,8928,7905,7913,7940,7943,8011,7956,7957,7958,7914,7915,7930,8016,8920,7959,7918,7920,8026,8027,8012,7916,7921,8028,8909,8914,8003,8004,8007,8008,7983,8021,8025,8030,7928,8014,7917,7984,7985,8023,8029,8913,7929,8017,7919,7981,7986,8024,8919,8912,8005,8013,8917,8006,7982,7988,8911,8916)
AND          trm1.ort_id IN (7927,7927,7961,7926,7953,7960,7932,7908,7931,7946,7952,7923,7925,7937,8926,7954,8927,7951,7933,7902,7907,7910,7924,7935,7938,7944,7945,7950,7903,7909,7936,8924,8925,7955,7934,7901,7911,7939,7947,7948,7949,7906,7922,7942,8010,7904,7912,8921,7941,8009,8928,7905,7913,7940,7943,8011,7956,7957,7958,7914,7915,7930,8016,8920,7959,7918,7920,8026,8027,8012,7916,7921,8028,8909,8914,8003,8004,8007,8008,7983,8021,8025,8030,7928,8014,7917,7984,7985,8023,8029,8913,7929,8017,7919,7981,7986,8024,8919,8912,8005,8013,8917,8006,7982,7988,8911,8916)
ORDER BY  trm1.tag, festival_id, trm1.uhr 
LIMIT 0,25
D-44388 Dortmund: 7 Events - remso.org

Town-calendar

D-44388 Dortmund + 20 km  

You have not selected a favourite town. Click the note icon to save D-44388 Dortmund as a cookie.

7 dates for area km.  days from   right

1
TID=26088

up Monday, 01.04.2019  19:00   rollstuhlgerecht   admission free

Søren Thies im Akkordeon-Café Dortmund¶

Akkordeon, Bajan, Mundharmonika   Akkordeon Café Dortmund

D-44135 Dortmund  |  Geschwister-Scholl-Str 33 +
25  views *
10 km von 44388 Dortmund

2
TID=26101

up Sunday, 05.05.2019  11:00

Schifffahrt Santa Monika II

Shantys und maritime Lieder   Shanty-Chor Herten   mp3

D-45711 Datteln  | 
47  views *
18 km von 44388 Dortmund

3
TID=26089

up Monday, 06.05.2019  19:00   rollstuhlgerecht   admission free

PATATRAS im Akkordeon Café Dortmund

Akkordeon, Bajan, Mundharmonika   Akkordeon Café Dortmund

D-44135 Dortmund  |  Geschwister-Scholl-Str 33 +
17  views *
10 km von 44388 Dortmund

4
TID=26099

up Saturday, 25.05.2019  18:00   rollstuhlgerecht

Irish Folk & Shanty evening

Konzert   Shanty-Chor Herten   mp3

D-45699 Herten  |  Hermannstr.16 +
36  views *
15 km von 44388 Dortmund

5
TID=26090

up Monday, 03.06.2019  19:00   rollstuhlgerecht   admission free

Earls of Gray im Akkordeon-Café Dortmund

Akkordeon, Bajan, Mundharmonika   Akkordeon Café Dortmund

D-44135 Dortmund  |  Geschwister-Scholl-Str 33 +
30  views *
10 km von 44388 Dortmund

6
TID=26731

up Saturday, 28.09.2019  17:00   rollstuhlgerecht

Herbstkonzert

Shantys und maritime Lieder   Shanty-Chor Herten   mp3

D-45699 Herten  |  Hermannstr.16 +
10  views *
15 km von 44388 Dortmund

7
TID=26457

up Saturday, 07.12.2019  17:00   rollstuhlgerecht

Maritime und irische Weihnachtslieder

Shantys und maritime Lieder   Shanty-Chor Herten   mp3

D-45699 Herten  |  Hermannstr.16 +
20  views *
15 km von 44388 Dortmund

Enter new date for 44388 Dortmund

Seitenaufrufe «D-44388 Dortmund»

Jan 29% 283
Feb 23% 217
Mrz 26% 251
Apr 0%
Mai 78% 747
Jun 97% 960
Jul 79% 757
Aug 62% 597
Sep 59% 563
Okt 76% 733
Nov 61% 588
Dez 51% 488