OEA show event

Wettkampf - Wettkampf-Tageszeit ist mit Lauf-Tageszeiten nicht konsistent: 6 Datensätze

where c.id in (19401, 19401, 19401, 19401, 19401, 19401)

Nr.	Id	Event_id	Oler_id	Corder	Cdate	Name	Category_id	Timeofday_id	Runid	Competition_id	Rorder	Rdate	Name	Category_id	Timeofday_id
1	19401	19259	1	1	1990-05-12	24-h-OL 1990	3	4	21812	19401	1	1990-05-12 10:00:00	24-h-OL 1990	3	4
2	19401	19259	1	1	1990-05-12	24-h-OL 1990	3	4	23338	19401	2	1990-05-12 12:45:00	24-h-OL 1990	3	4
3	19401	19259	1	1	1990-05-12	24-h-OL 1990	3	4	23339	19401	3	1990-05-12 16:45:00	24-h-OL 1990	3	4
4	19401	19259	1	1	1990-05-12	24-h-OL 1990	3	4	23340	19401	4	1990-05-12 20:45:00	24-h-OL 1990	3	4
5	19401	19259	1	1	1990-05-12	24-h-OL 1990	3	4	23341	19401	5	1990-05-12 21:45:00	24-h-OL 1990	3	4
6	19401	19259	1	1	1990-05-12	24-h-OL 1990	3	4	23342	19401	6	1990-05-12 21:59:00	24-h-OL 1990	3	4

Wettkampf - Team-Wettkampf, aber nicht ausreichend Sieger: 1 Datensätze

where r.id in (19401)

Nr.	Id	Event_id	Oler_id	Corder	Cdate	Name	Category_id	Description	Team	WinnerCount
1	19401	19259	1	1	1990-05-12	24-h-OL 1990	3	Staffel	1	0

Lauf - Ergebnis ist OK, aber keine Platzierung: 6 Datensätze

Nr.	Id	Competition_id	Oler_id	Forename	Rorder	Rdate	Name	Category_id	Result_id	Runningtime
1	21812	19401	1	Veikko	1	1990-05-12 10:00:00	24-h-OL 1990	3	1	00:00:00
1	23338	19401	1	Veikko	2	1990-05-12 12:45:00	24-h-OL 1990	3	1	00:00:00
1	23339	19401	1	Veikko	3	1990-05-12 16:45:00	24-h-OL 1990	3	1	00:00:00
1	23340	19401	1	Veikko	4	1990-05-12 20:45:00	24-h-OL 1990	3	1	00:00:00
1	23341	19401	1	Veikko	5	1990-05-12 21:45:00	24-h-OL 1990	3	1	00:00:00
1	23342	19401	1	Veikko	6	1990-05-12 21:59:00	24-h-OL 1990	3	1	00:00:00

where r.id in (21812, 23338, 23339, 23340, 23341, 23342)