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` = '1999'
		
				AND
					s.`Zugnr` = '810'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

Stammdaten

Zug-ID 19990100810

Fahrplanjahr 1999 (30.05.1999 — 27.05.2000)

Zuggattung IC (InterCity)

Zugnummer 810

Zugname Saaletal
Die Saale ist der Hauptfluss Thüringens. Sie entspringt im Fichtelgebirge in Bayern, fließt u.a. durch Halle und mündet bei Barby in die Elbe.

Gültig ab 30.05.1999

Verkehrstage Mo-Fr und So

Hinweis Zuschlag EC/IC-zuschlagpflichtig

Höchstgeschwindigkeit 160 km/h

Entfernung 513,347 km

Reisezeit 29 h 35 min

Durchschnittliche Geschwindigkeit 18 km/h

DB-Reiseplan ja

Zuglinie 8

Service

Fahrplan

Bahnhof	an	ab	Hinweis
München Hbf		18:33
Ingolstadt Hbf	19:20	19:21
Nürnberg Hbf	20:26	20:34	Richtungswechsel
Erlangen	20:47	20:48
Bamberg	21:08	21:10
Lichtenfels	21:26	21:27
Kronach	21:39	21:40
Saalfeld(Saale)	22:27	22:29
Rudolstadt(Thür)	22:37	22:38
Jena Saalbf	23:04	23:05	Halt nur im Sommerabschnitt
Jena Paradies	23:03	23:04	Halt nur im Winterabschnitt
Naumburg(Saale)Hbf	23:33	23:35
Halle(Saale)Hbf	00:08

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` = '1999'
		
				AND
					s.`Zugnr` = '1421'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '1505'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '74650'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '1589'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '224'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '69822'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '2667'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '811'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000

Laufplan	Gültig ab	Triebfahrzeug	Heimat	Laufplantag	Verkehrstage	Von	Bis	Vorleistung	Folgeleistung
EFA1	30.05.1999	103	Hamburg	14	Montag	München Hbf	Nürnberg Hbf	1421	1505
EFA1	30.05.1999	103	Hamburg	14	Dienstag, Freitag	München Hbf	Nürnberg Hbf	1421	1505
EFA1	30.05.1999	103	Hamburg	13	Mittwoch	München Hbf	Nürnberg Hbf	74650	1505
EFA1	30.05.1999	103	Hamburg	15	Donnerstag	München Hbf	Nürnberg Hbf	1421	1505
WFA6	01.11.1999	103	Hamburg	10	Montag	München Hbf	Nürnberg Hbf	1589	224
WFA6	01.11.1999	103	Hamburg	10	Dienstag bis Freitag	München Hbf	Nürnberg Hbf	69822	224
SFFA	30.05.1999	103	Frankfurt	5	Montag	Nürnberg Hbf	Halle(Saale)Hbf	2667	811
SFFA	30.05.1999	103	Frankfurt	8	Sonntag	Nürnberg Hbf	Halle(Saale)Hbf	2667	811
SFFA	30.05.1999	103	Frankfurt	5	Dienstag bis Freitag	Nürnberg Hbf	Halle(Saale)Hbf	2667	811

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` = '1999'
		
				AND
					s.`Zugnr` = '1581'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '1581'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '77203'
			
		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` = '1999'
		
				AND
					s.`Zugnr` = '1731'
			
		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
			72	435	Wagenzuglänge: 212,300 m
Summe der Sitzplätze:			507
Zugspitze ab: München Hbf
So-Do 18.10.-17.12., 6.1.-27.4.	Bm	6		72	München Hbf	Nürnberg Hbf	1581	1581	DB
So-Do 18.10.-17.12., 6.1.-27.4.	Bm	5		72
	Bm	7		72		Halle(Saale)Hbf	811/77203	811/1731
	Bpmb	8		75
	Bm	9		72
	Bm	10		72
	ARmz	11	18
	Avm	12	54
Zugspitze ab: Nürnberg Hbf