1054: Unknown column 'trm1.veranstalter_id' in 'on clause'

(
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
# remso - Mitglieder
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT
 '1'             anzeigen
,adr1.id         VIP
,'0'             ITR
,adr1.gewerbeart
,adr1.firma1     gruppe_name
,adr1.land_kz
,adr1.plz
,adr1.ort        ort_name
,adr1.homepage
,adr1.email
,ort1.id  ORT
,IF (ort1.geo_breite IS NOT NULL, '0', '1' ) sort
# ,ROUND(ort1.geo_breite,3) geo_breite
# ,ROUND(ort1.geo_laenge,3) geo_laenge

,'1' remso_mitglied
,COUNT(DISTINCT trm1.id)  anzahl_termine
#,COUNT(DISTINCT fst1.id)  anzahl_festivals
#,COUNT(DISTINCT med1.id)  anzahl_hoerproben

FROM      bia_adressen adr1

LEFT JOIN bia_orte ort1
ON        ort1.id = adr1.ort_id

LEFT JOIN bia_termine trm1
ON        trm1.veranstalter_id = adr1.id
AND       trm1.tag >= CURDATE()
AND       trm1.intern_kz = '0'

WHERE     SUBSTRING(adr1.gewerbeart,6,1)  = 'S'
AND       adr1.loe_kz = 0
GROUP BY  adr1.id

) UNION (

# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
# remso - Interessenten
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT
 IF( adr1.adress_id > 0, '0', '1' ) anzeigen
,'0'             VIP
,adr1.id         ITR
,adr1.gewerbeart
,adr1.firma1     gruppe_name
,adr1.land_kz
,adr1.plz
,adr1.ort        ort_name
,adr1.homepage
,adr1.email
,ort1.id         ORT
,IF (ort1.geo_breite IS NOT NULL, '0', '1' ) sort
# ,' ' geo_breite
# ,' ' geo_laenge

,'0' remso_mitglied
,'0'  anzahl_termine
#,COUNT(DISTINCT fst1.id)  anzahl_festivals
#,COUNT(DISTINCT med1.id)  anzahl_hoerproben

FROM      bia_interessenten adr1

LEFT JOIN bia_orte ort1
ON        ort1.id = adr1.ort_id

WHERE     SUBSTRING(adr1.gewerbeart,6,1)  = 'S'
AND       adr1.loe_kz = 0

# GROUP BY adr1.id
)
ORDER BY  land_kz, plz, ort_name, gruppe_name
LIMIT 0,20