4 rows where screengroup = 22

View and edit SQL

Link screengroup screen
Hamburg Elbbrücken U-Bf - all screens 22 10008898 - U-Bf Elbbr., Sto.1, V-Ebene 0, Schalterh. B 10008898
Hamburg Elbbrücken U-Bf - all screens 22 10008899 - U-Bf Elbbr., Sto.3, V-Ebene 0, Schalterh. C 10008899
Hamburg Elbbrücken U-Bf - all screens 22 10008900 - U-Bf Elbbr., Sto.4, V-Ebene 0, Schalterh. D 10008900
Hamburg Elbbrücken U-Bf - all screens 22 10008901 - U-Bf Elbbr., Sto.2, V-Ebene 0, Schalterh. A 10008901

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