SELECT
t.ID AS teilnehmer_id,
t.Anrede AS Anrede,
t.Vorname AS Vorname,
t.Name AS Name,
t.Strasse AS Strasse,
t.PLZ AS PLZ,
t.Ort AS Ort,
t.Land AS Land,
t.Email AS Email,
e.Event AS Event,
p.Buchungsdatum AS Buchungsdatum,
d.Datum AS Datum,
d.Id AS datum_id,
u.Uhrzeit AS Uhrzeit,
u.ID as uhrzeit_id,
COUNT(*) AS Buchungen
FROM termin_teilnehmer t,
LEFT JOIN termin_tapes k ON k.ID_Teilnehmer = t.ID,
termin_event e,
termin_datum d,
termin_uhrzeit u,
termin_plan p,
WHERE e.ID = 3
AND p.ID_Teilnehmer = t.ID
GROUP BY t.ID


SELECT
t.*
FROM
termin_teilnehmer t;


SELECT
p.*
FROM
termin_plan p
WHERE


SELECT
u.*
FROM
termin_uhrzeit u
WHERE

SELECT
d.*
FROM
termin_datum d
WHERE
ID_Event = 3;



d.ID_Event = 3
AND d.ID = u.ID_Datum
AND u.ID = p.ID_Uhrzeit


(SELECT COUNT(*) FROM termin_plan p WHERE p.ID_Teilnehmer = t.ID)


SELECT
t.ID AS teilnehmer_id,
t.Anrede AS Anrede,
t.Vorname AS Vorname,
t.Name AS Name,
t.Strasse AS Strasse,
t.PLZ AS PLZ,
t.Ort AS Ort,
t.Land AS Land,
t.Email AS Email,
e.Event AS Event,
COUNT(p.ID) AS Buchungen,
u.ID_Datum AS id_datum,
d.ID_Event AS id_event
FROM termin_teilnehmer t,
termin_event e,
termin_plan p,
termin_datum d,
termin_uhrzeit u
WHERE
d.ID_Event = 3
AND d.ID = u.ID_Datum
AND u.ID = p.ID_Uhrzeit
AND p.ID_Teilnehmer = t.ID
GROUP BY t.ID