Datenbanksuche — Datenbank Fernverkehr

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '720'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

Stammdaten

Zug-ID 19910100720

Fahrplanjahr 1991 (02.06.1991 — 30.05.1992)

Zuggattung IC (InterCity)

Zugnummer 720

Zugname Burggraf
Burggraf: Amt aus dem Lehnswesen des Mittelalters.

Gültig ab 02.06.1991

Verkehrstage Mo-Fr und So

Höchstgeschwindigkeit 160 km/h

Entfernung 567,349 km

Reisezeit 5 h 57 min

Durchschnittliche Geschwindigkeit 96 km/h

DB-Reiseplan ja

Zuglinie 1

Service

Fahrplan

Bahnhof	an	ab	Hinweis
München Hbf		18:18
Ingolstadt Hbf	18:58	18:59
Nürnberg Hbf	20:03	20:11	Richtungswechsel
Würzburg Hbf	21:06	21:16
Aschaffenburg Hbf	22:06	22:08
Hanau Hbf	22:20	22:21
Frankfurt(M)Hbf	22:38	22:50	Richtungswechsel
Frankfurt Flughafen	23:01	23:03
Mainz Hbf	23:22	23:24
Bingerbrück	23:39	23:40
Koblenz Hbf	00:15

Karte

Laufplan

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '781'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '14188'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '14089'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '14188'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '14171'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '3018'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '30101'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '14171'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '827'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '2406'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

Laufplan	Gültig ab	Triebfahrzeug	Heimat	Laufplantag	Verkehrstage	Von	Bis	Vorleistung	Folgeleistung
SA04	02.06.1991	103	Hamburg 1	4	Montag	München Hbf	Nürnberg Hbf	781	14188
SA01	02.06.1991	103	Hamburg 1	5	Sonntag	München Hbf	Nürnberg Hbf	781	14089
SA04	02.06.1991	103	Hamburg 1	4	Dienstag bis Freitag	München Hbf	Nürnberg Hbf	781	14188
SF43	02.06.1991	103	Frankfurt 1	24	Montag	Nürnberg Hbf	Frankfurt(M)Hbf		14171
SF43	02.06.1991	103	Frankfurt 1	44	Sonntag	Nürnberg Hbf	Frankfurt(M)Hbf	3018	30101
SF43	02.06.1991	103	Frankfurt 1	24	Dienstag bis Freitag	Nürnberg Hbf	Frankfurt(M)Hbf		14171
SA01	02.06.1991	103	Hamburg 1	32	Montag	Frankfurt(M)Hbf	Koblenz Hbf	827	2406
SA01	02.06.1991	103	Hamburg 1	19	Sonntag	Frankfurt(M)Hbf	Koblenz Hbf	827	2406
SA01	02.06.1991	103	Hamburg 1	32	Dienstag bis Freitag	Frankfurt(M)Hbf	Koblenz Hbf	827	2406

Wagenreihung

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '721'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '67'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

[DEBUG-INFO] 

		SELECT DISTINCT
			s.`Zug-ID`              AS zug_id,
			s.`Fahrplanjahr`        AS fahrplan_jahr,
			s.`Gattung`             AS zug_gattung,
			s.`Zugnr`               AS zug_nummer,
			s.`Gültig ab`           AS fahrplan_gueltigab,
			s.`Startbahnhof ZLS`    AS bahnhof_start,
			s.`Zielbahnhof ZLS`     AS bahnhof_ziel,
			s.`Verkehrstage`        AS fahrplan_vt,
			s.`Hinweis VT`          AS fahrplan_vthinweis,
			s.`Vmax`                AS zug_vmax,
			s.`km`                  AS fahrplan_km,
			s.`Reisezeit`           AS fahrplan_zeit,
			s.`Reiseplan`           AS zug_reiseplan,
			s.`Mo`                  AS vt_montag,
			s.`Di`                  AS vt_dienstag,
			s.`Mi`                  AS vt_mittwoch,
			s.`Do`                  AS vt_donnerstag,
			s.`Fr`                  AS vt_freitag,
			s.`Sa`                  AS vt_samstag,
			s.`So`                  AS vt_sonntag,
			s.`Servicehinweis`      AS service_hinweis,
			s.`Restaurant`          AS service_restaurant,
			s.`Bistro`              AS service_bistro,
			s.`Quickpick`           AS service_quickpick,
			s.`Getränke`            AS service_getraenke,
			s.`Minibar`             AS service_minibar,
			s.`Rollstuhl`           AS service_rollstuhl,
			s.`Fahrrad`             AS service_fahrrad,
			s.`Gepäck`              AS service_gepaeck,
			s.`Telefon`             AS service_telefon,
			s.`Linie`               AS zug_linie,
	
			IFNULL(f.`FreigabeF`,0) AS status_fahrplan,
			IFNULL(l.`Freigabe`,0)  AS status_laufplan,
			IFNULL(r.`freigabe`,0)  AS status_reihungen,
			IFNULL(i.`ID`,0)        AS status_fotos
		FROM
			`Stammdaten` AS s
	
		LEFT JOIN
			`Fotos` AS i
		ON
			i.`Zug-ID` = s.`Zug-ID`
	
		LEFT JOIN
			`Fahrplan_Neu` AS f
		ON
			f.`Zug-ID`    = s.`Zug-ID`
		AND
			f.`Position`  = 1
	
		 AND f.`FreigabeF` IN (1,98,99,10)
	 LEFT JOIN 
			(	SELECT DISTINCT
					`Zug-ID`,
					1 AS freigabe
				FROM
					`Laufplan`
				WHERE
		
		  `FreigabeL` IN (1,98,99)
	
				GROUP BY
					`Zug-ID`
			) AS l
			ON
				l.`Zug-ID` = s.`Zug-ID`
		 LEFT JOIN 
		(SELECT
			r3.`Zug-ID`         AS `Zug-ID`,
			MAX(r3.`FreigabeR`) AS freigabe
		FROM (
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung` AS r1
		WHERE
	
		  r1.`FreigabeR` IN (1,98,99)
	
		UNION
		SELECT
			`Zug-ID`,
			`FreigabeR`
		FROM
			`Reihung_Neu` AS r2
	
		WHERE
	
		  r2.`FreigabeR` IN (1,98,99)
	
		) AS r3
		GROUP BY
			r3.`Zug-ID`
		) as r
	ON
		r.`Zug-ID` = s.`Zug-ID`
	
		WHERE
			s.`Gattung`      IS NOT NULL
		AND
			s.`Zugnr`        IS NOT NULL
		AND
			s.`Zugnr`        !=     '0'
		AND
	
		  s.`FreigabeS` IN (1,98,99)
	
			AND
				s.`Fahrplanjahr` = '1991'
		
				AND
					s.`Zugnr` = '52'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

Verkehrs- tag	Wagen- gattung	Wagen- nummer	Sitzplätze 1. Klasse	Sitzplätze 2. Klasse	ab	bis	aus Zug	in Zug	Verwaltung
			120	523	Wagenzuglänge: 265,100 m
Summe der Sitzplätze:			643
Zugspitze ab: München Hbf, Frankfurt(M)Hbf
	Apm	23	48		München Hbf	Koblenz Hbf	721	721	DB
	Avm	22	54
	ARmz	21	18
	Bm	20		72
	Bm	19		72
	Bpmb	18		75
	Bpm	17		80
	Bm	15		72
	Bm	14		72
Bedarf	Bpm	601		80		Frankfurt(M)Hbf	67	52
Zugspitze ab: Nürnberg Hbf

Weitere Züge mit gleicher Zugnummer

D 720 Leipzig — Rostock (Gültig ab: 02.06.1991; täglich)