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

Stammdaten

Zug-ID 20210102274

Fahrplanjahr 2021 ( — )

Zuggattung IC (InterCity)

Zugnummer 2274

Gültig ab

Verkehrstage täglich

Hinweis Verkehrstage So ab Berlin Südkreuz

Höchstgeschwindigkeit 160 km/h

Hinweis Fahrplankopf 16., 17.1., ab 11.9. ohne Halt in Flughafen BER - Terminal 1-2

Reisezeit 4 h 42 min

DB-Reiseplan nein

IC/ICE-Typ IC 2K (Stadler KISS)

Zuglinie 17

Service SnackPoint/Imbiss im ZugZug mit Stellplätzen im FahrradabteilRollstuhlstellplätze im Zug

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` = '2273'
			
		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` = '78534'
			
		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` = '2179'
			
		ORDER BY
			s.`Fahrplanjahr`,
			s.`Zugnr`
		LIMIT
			10000
Verkehrs-
tag		Wagen-
gattung		Wagen-
nummer		Sitzplätze
1. Klasse		Sitzplätze
2. Klasse		abbisaus Zugin ZugVerwaltung
28252
Summe der Sitzplätze:280
Zugspitze ab: Dresden Hbf
 DBpdzfa152Dresden Hbf/Berlin SüdkreuzWarnemünde2273/785342179DB
 DBpbza474
 DBpza594
 DABpzfa62832
Zugspitze ab: Flughafen BER - T 1-2
Hinweis: 16.1.-26.3. ab Dresden Hbf in umgekehrter Reihung

Hinweise

Für diesen Zug ist noch kein Laufplan verfügbar.