25 rows where network_id = "7.4.2"

View and edit SQL

Link building network_id
100460384 Public Video Fitness 7.4.2
100460386 Public Video Fitness 7.4.2
100460387 Public Video Fitness 7.4.2
100466852 Public Video Fitness 7.4.2
ATV-241980 Public Video Fitness 7.4.2
ATV-88380 Public Video Fitness 7.4.2
ATV-88381 Public Video Fitness 7.4.2
ATV-88382 Public Video Fitness 7.4.2
ATV-88383 Public Video Fitness 7.4.2
DMI_AT_00087 Public Video Fitness 7.4.2
DMI_AT_00088 Public Video Fitness 7.4.2
DMI_AT_00338 Public Video Fitness 7.4.2
DMI_AT_00339 Public Video Fitness 7.4.2
DMI_AT_00776 Public Video Fitness 7.4.2
DMI_AT_00977 Public Video Fitness 7.4.2
DMI_AT_01049 Public Video Fitness 7.4.2
RSG-HH001 Public Video Fitness 7.4.2
RSG-HH002 Public Video Fitness 7.4.2
RSG-HH003 Public Video Fitness 7.4.2
RSG-HH004 Public Video Fitness 7.4.2
RSG-HH005 Public Video Fitness 7.4.2
RSG-HH006 Public Video Fitness 7.4.2
RSG-HH007 Public Video Fitness 7.4.2
RSG-HH008 Public Video Fitness 7.4.2
RSG-HH010 Public Video Fitness 7.4.2

Advanced export

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

CSV options:

CREATE TABLE building_networks (
	building VARCHAR(100) NOT NULL, 
	network_id VARCHAR(100) NOT NULL, 
	PRIMARY KEY (building, network_id), 
	FOREIGN KEY(building) REFERENCES building (id), 
	FOREIGN KEY(network_id) REFERENCES network (id)
);