24 rows
where screengroup = 3
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 3,10008879 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008879 - U-Bf Berliner Tor, V-Eb. Ri.Hbf. LiPl. li. 10008879 |
| 3,10008880 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008880 - U-Bf Berliner Tor, V-Eb. Abg.z.Gl. re. 10008880 |
| 3,10008881 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008881 - U-Bf Berliner Tor, V-Eb. v. Gel. re. 10008881 |
| 3,10008882 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008882 - U-Bf Berliner Tor, V-Eb. Ausg.b. Stroh. N 10008882 |
| 3,10008883 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008883 - U-Bf Berliner Tor, V-Eb. v. Gel. 2.v.re. 10008883 |
| 3,10008884 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008884 - U-Bf Berliner Tor, V-Eb. v. Gel. 3.v.re. 10008884 |
| 3,10008885 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008885 - U-Bf Berliner Tor, V-Eb. Ri.Hbf. LiPl. re. 10008885 |
| 3,10008886 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008886 - U-Bf Berliner Tor, V-Eb. Ri.Hbf. HBStr. li. 10008886 |
| 3,10008887 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008887 - U-Bf Berliner Tor, V-Eb. gg.Ausg.b. Stroh.re 10008887 |
| 3,10008888 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008888 - U-Bf Berliner Tor, V-Eb. gg.Ausg.b. Stroh.li 10008888 |
| 3,10008889 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008889 - U-Bf Berliner Tor, V-Eb. v. Gel. li. 10008889 |
| 3,10008890 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008890 - U-Bf Berliner Tor, V-Eb. Abg.z.Gl. li. 10008890 |
| 3,10008891 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008891 - U-Bf Berliner Tor, V-Eb. Ausg. b. Strohh. 10008891 |
| 3,10008892 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10008892 - U-Bf Berliner Tor, V-Eb. Ri.Hbf. HBStr. re. 10008892 |
| 3,10010884 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010884 - U-Bf Berliner Tor, Gl. 4, Stationsmitte, 2. Fl. 10010884 |
| 3,10010885 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010885 - U-Bf Berliner Tor, Gl. 1, Ausf. v. Kiosk - 065 10010885 |
| 3,10010886 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010886 - U-Bf Berliner Tor, Gl. 1, Stationsmitte 2. Fl. 10010886 |
| 3,10010887 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010887 - U-Bf Berliner Tor, Gleis 1, Stationsmitte, gg 58 10010887 |
| 3,10010888 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010888 - U-Bf Berliner Tor, Gl. 4, Stationsmitte, 3. Fl. 10010888 |
| 3,10010894 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010894 - U-Bf Berliner Tor, Gl. 4, Einf., 1. Fl. - 067 10010894 |
| 3,10010895 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010895 - U-Bf Berliner Tor, Gl. 2 Rtg. Billstedt RS 74 10010895 |
| 3,10010896 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010896 - U-Bf Berliner Tor, Gleis 3, Stationsmitte, RS 58 10010896 |
| 3,10010951 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010951 - U-Bf Berliner Tor, Gl. 1, 1.Fl. re. von Wandöffn. 10010951 |
| 3,10010952 |
Hamburg Berliner Tor U-Bf - all screens 3 |
10010952 - U-Bf Berliner Tor, Gl. 4, gg. Fl.59 Ausf. - 075 10010952 |
CREATE TABLE screengroup_screens (
screengroup INTEGER NOT NULL,
screen VARCHAR(8) NOT NULL,
PRIMARY KEY (screengroup, screen),
FOREIGN KEY(screengroup) REFERENCES screengroup (id),
FOREIGN KEY(screen) REFERENCES screen (id)
);