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

Stammdaten

Zug-ID 20200100153

Fahrplanjahr 2020 (15.12.2019 — 12.12.2020)

Zuggattung ICE (InterCityExpress)

Zugnummer 153

Zugname ICE International

Gültig ab 18.01.2020

Verkehrstage 1.-10.5., 10.-19.8.

Hinweis Verkehrstage sowie an zahlreichen weiteren Einzeltagen

Höchstgeschwindigkeit 120 km/h

Hinweis Fahrplankopf

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

Corona: Zug entfällt 20.3.-31.5.; Zug fährt als ICE 15 weiter nach Frankfurt(M)Hbf

Reisezeit 3 h 13 min

DB-Reiseplan nein

IC/ICE-Typ ICE 3

Zuglinie 78

Service

Fahrplan

Bahnhof	an	ab	Hinweis
Amsterdam C		09:08
Utrecht C	09:33	09:38
Venlo	10:58	11:00	Betriebshalt
Viersen	11:20	11:22
Mönchengladbach Hbf	11:30	11:35
Köln Hbf	12:21
An Einzeltagen Amsterdam ab 09:00, zus. Betriebshalt in 's-Hertogenbosch 09:56/10:06

Karte

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

Verkehrs- tag	Wagen- gattung	Wagen- nummer	Sitzplätze 1. Klasse	Sitzplätze 2. Klasse	ab	bis	weiter nach	aus Zug	in Zug	Verwaltung
			93	324	Wagenzuglänge: 200,325 m
Summe der Sitzplätze:			417
Zugspitze ab: Amsterdam C
	Apmzf	39	47		Amsterdam C	Köln Hbf	Frankfurt(M)Hbf	152	15	DB
	Avmz	38	46
	Bvmz	37		62
	BRmz	36
	Bpmbz	35		54
	Bpmz	33		72
	Bpmz	32		72
	Bpmzf	31		64
Hinweis: Zug fährt an Einzeltagen in umgekehrter Reihung

Hinweise

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