Meldung 29.03.2024 00:11:18  
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '14104,,,14045,,,14059,,,14060,,,14216,,,13650,,,13726,,,14141,,,14096,,,14038,,,' at line 60
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ # Termine *ORT und Umkreis lesen # ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ SELECT SQL_CALC_FOUND_ROWS trm1.* ,trm1.id TID ,DATE_FORMAT(trm1.tag,'%w') wotag ,DATE_FORMAT(trm1.tag_bis,'%w') wotag_bis ,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.id ORT ,ort1.land_kz ,ort1.plz ,ort1.name ort_name ,ort1.kfz_kennzeichen ort_kfz_kennzeichen ,ort1.geo_breite ort_geo_breite ,ort1.geo_laenge ort_geo_laenge ,ROUND( 6366.0 * ACOS( SIN(0) *SIN(RADIANS(ort1.geo_breite)) +COS(0) *COS(RADIANS(ort1.geo_breite)) *COS(RADIANS(ort1.geo_laenge) -0 ))) distanz_km ,adr1.id VIP ,adr1.firma1 ,trp1.id TRP ,trp1.bild_url trp_bild_url -- fuer icon_webcam ,trp1.bild_titel trp_bild_titel #,typ1.id TYP #,IF( ueb1.bezeichnung2 IS NOT NULL, ueb1.bezeichnung2, 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 #LEFT JOIN bia_uebersetzungen ueb1 #ON ueb1.tabelle = 'termintypen' #AND ueb1.tabelle_id = trm1.typ_id #AND ueb1.sprache = 'nl' 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 >= '2024-03-29' OR trm1.tag_bis >= '2024-03-29' ) AND (trm1.tag <= '2025-03-29' OR trm1.tag_bis <= '2025-03-29' ) AND trm1.ort_id IN (,14104,,,14045,,,14059,,,14060,,,14216,,,13650,,,13726,,,14141,,,14096,,,14038,,,14062,,,14090,,,13832,,,14034,,,14159,,,7074,,,14148,,) ORDER BY trm1.tag, festival_sort, festival_id, trm1.uhr LIMIT 0,25

Stadkalender

Menu Menu

 remso.eu   Stadkalender

Evenementdata gerapporteerd door groepen zelf

  icon Person  Login  |  Registratie 

- + 20 km

Gedrukt op 29.03.2024   Huidige status op   www.remso.eu/?ORT=

such_umkreis

km radius: 20   vanaf datum:

trek aan de hoek om te vergroten Pfeil Nordost

00:11 | 5 Evenementen voor deze selectie

Paginaweergaven «- »

Jan 97% 11
Feb 27% 3
Mrz 91% 10
Apr 0%
Mai 9% 1
Jun 0%
Jul 0%
Aug 0%
Sep 18% 2
Okt 82% 9
Nov 55% 6
Dez 55% 6

Deel stadkalender + 20 km

aan mail