13 rows where building = "RSG-HH010"

View and edit SQL

id ▼ title name_publisher building network
10014158 10014158 - Cardio Screen 1 Reihe1 Cardio Screen 1 Reihe1 RSG-HH010 37
10014159 10014159 - Cardio Screen 2 Reihe1 Cardio Screen 2 Reihe1 RSG-HH010 37
10014160 10014160 - Cardio Screen 3 Reihe 1 Cardio Screen 3 Reihe 1 RSG-HH010 37
10014161 10014161 - Cardio Screen 4 Reihe 1 Cardio Screen 4 Reihe 1 RSG-HH010 37
10014162 10014162 - Cardio Screen 5 Reihe 2 Cardio Screen 5 Reihe 2 RSG-HH010 37
10014163 10014163 - Cardio Screen 6 Reihe 2 Cardio Screen 6 Reihe 2 RSG-HH010 37
10014164 10014164 - Cardio Screen 7 Reihe 2 Cardio Screen 7 Reihe 2 RSG-HH010 37
10014165 10014165 - Cardio Screen 8 Reihe 2 Cardio Screen 8 Reihe 2 RSG-HH010 37
10014166 10014166 - Cardio Screen 9 Reihe 3 Cardio Screen 9 Reihe 3 RSG-HH010 37
10014167 10014167 - Functional Screen 1 Functional Screen 1 RSG-HH010 37
10014168 10014168 - Functional Screen 2 Functional Screen 2 RSG-HH010 37
10014169 10014169 - Functional Screen 3 Functional Screen 3 RSG-HH010 37
10014170 10014170 - Functional Screen 4 Functional Screen 4 RSG-HH010 37

Advanced export

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

CSV options:

CREATE TABLE screen (
	id VARCHAR(8) NOT NULL, 
	title VARCHAR(250), 
	name_publisher VARCHAR(250), 
	building VARCHAR, 
	network VARCHAR, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(building) REFERENCES building (id), 
	FOREIGN KEY(network) REFERENCES network (id)
);
CREATE INDEX ix_screen_name_publisher ON screen (name_publisher);
CREATE INDEX ix_screen_network ON screen (network);
CREATE INDEX ix_screen_building ON screen (building);