8 rows where screengroup = 484

View and edit SQL

Link screengroup screen
Wandsbek Quarree - all screens 484 10014240 - Wandsbek quarree – untergeschoss 10014240
Wandsbek Quarree - all screens 484 10014241 - Wandsbek quarree – Erdgeschoss 10014241
Wandsbek Quarree - all screens 484 10014242 - Wandsbek quarree – Erdgeschoss 10014242
Wandsbek Quarree - all screens 484 10014243 - Wandsbek quarree – Erdgeschoss 10014243
Wandsbek Quarree - all screens 484 10014244 - Wandsbek quarree – Erdgeschoss 10014244
Wandsbek Quarree - all screens 484 10014245 - Wandsbek quarree – Obergeschoss 10014245
Wandsbek Quarree - all screens 484 10014246 - Wandsbek quarree – Obergeschoss 10014246
Wandsbek Quarree - all screens 484 10014247 - Wandsbek quarree – Obergeschoss 10014247

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