Meldung 20.04.2024 05:00:38 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 = ''
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