home / PUP_Spotconfigs_2022_01

spotset_frequencies

9 rows where frequency_id = 17

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link spotset_id frequency_id
2,17 Brand Community Network (BCN) (1) 2 17 17
37,17 Brand Community Network (BCN) (5) 37 17 17
41,17 DUS Airport Media 41 17 17
42,17 Diverse (1) 42 17 17
44,17 Diverse (3) 44 17 17
47,17 Edgar Ambient Media Group GmbH (4) 47 17 17
50,17 Flughafen Hamburg GmbH 50 17 17
51,17 Goldbach Germany (5) 51 17 17
55,17 Hygh Mobile Media GmbH (1) 55 17 17

Advanced export

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

CSV options:

CREATE TABLE spotset_frequencies (
	spotset_id INTEGER NOT NULL, 
	frequency_id INTEGER NOT NULL, 
	PRIMARY KEY (spotset_id, frequency_id), 
	FOREIGN KEY(spotset_id) REFERENCES spotset (id), 
	FOREIGN KEY(frequency_id) REFERENCES frequency (id)
);
Powered by Datasette · Queries took 7.142ms