17 rows
where screengroup = 14
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
screengroup
|
screen
|
| 14,10009223 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10009223 - U-Bf Stephanspl., Vert. Messe vor Ausg. re. 10009223 |
| 14,10009224 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10009224 - U-Bf Stephanspl., Vert. Messe, Abg. U 10009224 |
| 14,10009225 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10009225 - U-Bf Stephanspl., Vert. Messe vor Ausg. li. 10009225 |
| 14,10009226 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10009226 - U-Bf Stephanspl., SH Süd, Ausg. Dammtor li. 10009226 |
| 14,10009227 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10009227 - U-Bf Stephanspl., SH Süd, Ausg. Dammtor re. 10009227 |
| 14,10011219 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011219 - U-Bf Stephansplatz, Gl.2 Einf. statt WT - 415 10011219 |
| 14,10011220 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011220 - U-Bf Stephansplatz, Gl.1 Einf. 9. Feld - 410 10011220 |
| 14,10011221 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011221 - U-Bf Stephansplatz, Gl.2 Einf. gg. Fl.5 - 416 10011221 |
| 14,10011222 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011222 - U-Bf Stephansplatz, Gl.2 Ausf. statt WT - 428 10011222 |
| 14,10011223 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011223 - U-Bf Stephansplatz, Gl.1 Ausf. 23. Feld - 413 10011223 |
| 14,10011224 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011224 - U-Bf Stephansplatz, Gl.1 Ausf. 26. Feld - 414 10011224 |
| 14,10011225 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011225 - U-Bf Stephansplatz, Gl.1 Einf. 6. Feld - 409 10011225 |
| 14,10011226 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011226 - U-Bf Stephansplatz, Gl.2 Ausf. gg. Fl.2 - 419 10011226 |
| 14,10011227 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011227 - U-Bf Stephansplatz, Gl.1 S-mitte 20. Feld - 412 10011227 |
| 14,10011228 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011228 - U-Bf Stephansplatz, Gl.1 S-mitte 12. Feld - 411 10011228 |
| 14,10011229 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011229 - U-Bf Stephansplatz, Gl.2 S-mitte gg. Fl.4 - 417 10011229 |
| 14,10011230 |
Hamburg Stephansplatz (Oper/CCH) U-Bf - all screens 14 |
10011230 - U-Bf Stephansplatz, Gl.2 S-mitte statt WT - 418 10011230 |
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)
);