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

Stammdaten

Zug-ID 20210102060

Fahrplanjahr 2021 (13.12.2020 — 11.12.2021)

Zuggattung IC (InterCity)

Zugnummer 2060

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 13.12.2020

Verkehrstage täglich

Hinweis Verkehrstage Sa ab Stuttgart Hbf; Leipzig Hbf-Nürnberg Hbf Mo-Fr und So, 17.1.-28.3.: So

Höchstgeschwindigkeit 160 km/h

Reisezeit 7 h 11 min

DB-Reiseplan nein

IC/ICE-Typ IC 2

Zuglinie 61

Service

Fahrplan

Bahnhof	an	ab	Hinweis
Leipzig Hbf		15:49
Weißenfels	16:17	16:19
Naumburg(Saale)Hbf	16:29	16:31
Jena Paradies	16:58	17:00
Jena-Göschwitz	17:05	17:07
Saalfeld(Saale)	17:34	17:36
Kronach	18:24	18:26
Lichtenfels	18:38	18:40
Bamberg	18:55	18:57
Erlangen	19:16	19:18
Nürnberg Hbf	19:33	19:41	Richtungswechsel
Ansbach	20:06	20:07
Crailsheim	20:33	20:35
Ellwangen	20:49	20:50
Aalen Hbf	21:00	21:02
Schwäbisch Gmünd	21:16	21:18
Schorndorf	21:32	21:34
Stuttgart Hbf	21:53	21:59	Richtungswechsel
Vaihingen(Enz)	22:14	22:16
Mühlacker	22:22	22:24
Pforzheim Hbf	22:32	22:34
Karlsruhe-Durlach	22:52	22:54
Karlsruhe Hbf	23:00

Karte

Laufplan

Laufplan	Gültig ab	Triebfahrzeug	Heimat	Laufplantag	Verkehrstage	Von	Bis	Vorleistung	Folgeleistung	Hinweis!
	13.12.2020	147	DB		Montag, Dienstag, Mittwoch, Donnerstag, Freitag, Sonntag	Leipzig Hbf	Karlsruhe Hbf
	13.12.2020	147	DB		Samstag	Nürnberg Hbf	Karlsruhe Hbf

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` = '2021'
		
				AND
					s.`Zugnr` = '2063'
			
		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` = '2021'
		
				AND
					s.`Zugnr` = '2037'
			
		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` = '2021'
		
				AND
					s.`Zugnr` = '2239'
			
		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` = '2021'
		
				AND
					s.`Zugnr` = '2165'
			
		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` = '2021'
		
				AND
					s.`Zugnr` = '78626'
			
		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` = '2021'
		
				AND
					s.`Zugnr` = '2065'
			
		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
			70	392	Wagenzuglänge: 134,470 m
Summe der Sitzplätze:			462
Zugspitze ab: Leipzig Hbf, Stuttgart Hbf
	DBpbzfa	1		56	Nürnberg Hbf/Leipzig Hbf/Stuttgart Hbf	Karlsruhe Hbf	2063/2037/2239/2165	78626/2063/2065	DB
	DBpza	2		112
	DBpza	3		112
	DBpza	4		112
	DApza	5	70
Zugspitze ab: Nürnberg Hbf