4 rows where screengroup = 616

View and edit SQL

Link screengroup screen
Hamburg Berliner Tor Bf - all screens 616 10008875 - S-Bf Berliner Tor, Durchgang, li. 10008875
Hamburg Berliner Tor Bf - all screens 616 10008876 - S-Bf Berliner Tor, Durchgang, re. 10008876
Hamburg Berliner Tor Bf - all screens 616 10008877 - S-Bf Berliner Tor, Durchgang, mi. 10008877
Hamburg Berliner Tor Bf - all screens 616 10008878 - S-Bf Berliner Tor,Durchgang,Zugang Gl.1/2,re. 10008878

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);