Meldung 20.04.2024 11:24:15  
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 = 'en' 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-04-20' OR trm1.tag_bis >= '2024-04-20' ) AND (trm1.tag <= '2025-04-20' OR trm1.tag_bis <= '2025-04-20' ) 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

Town-calendar

Menu Menu

 remso.eu   Town-calendar

Event dates reported by groups themselves

  icon Person  Login  |  Registration 

- + 20 km

Printed on 20.04.2024   Current status on   www.remso.eu/?ORT=

such_umkreis

km radius: 20   from date:

pull the corner to enlarge Pfeil Nordost

11:24 | 5 events for this selection

Page views «- »

Jan 24% 11
Feb 40% 18
Mrz 89% 40
Apr 9% 4
Mai 0%
Jun 0%
Jul 0%
Aug 0%
Sep 31% 14
Okt 31% 14
Nov 31% 14
Dez 97% 45

Share town-calendar + 20 km

to mail