home / PUP_Spotconfigs_2022_01

spotset_frequencies

32 rows where frequency_id = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link spotset_id frequency_id
36,1 Brand Community Network (BCN) (4) 36 1 1
37,1 Brand Community Network (BCN) (5) 37 1 1
38,1 Brand Community Network (BCN) (6) 38 1 1
39,1 Brand Community Network (BCN) (7) 39 1 1
40,1 Brandstifter AG (1) 40 1 1
41,1 DUS Airport Media 41 1 1
42,1 Diverse (1) 42 1 1
43,1 Diverse (2) 43 1 1
44,1 Diverse (3) 44 1 1
45,1 Edgar Ambient Media Group GmbH (2) 45 1 1
46,1 Edgar Ambient Media Group GmbH (3) 46 1 1
47,1 Edgar Ambient Media Group GmbH (4) 47 1 1
48,1 El Cartel Media (1) 48 1 1
49,1 Executive Channel Deutschland GmbH (1) 49 1 1
50,1 Flughafen Hamburg GmbH 50 1 1
51,1 Goldbach Germany (5) 51 1 1
52,1 Goldbach Germany (6) 52 1 1
53,1 Goldbach Germany (7) 53 1 1
54,1 Goldbach Germany (8) 54 1 1
55,1 Hygh Mobile Media GmbH (1) 55 1 1
56,1 Hygh Mobile Media GmbH (2) 56 1 1
57,1 SK2 Solutions GmbH (1) 57 1 1
58,1 Ströer (8) 58 1 1
65,1 TV Wartezimmer (1) 65 1 1
66,1 VIEWENTO GmbH (1) 66 1 1
67,1 WallDecaux (1) 67 1 1
68,1 X-City Marketing (2) 68 1 1
69,1 airtango media GmbH (1) 69 1 1
70,1 echion Corporate Communication AG (1) 70 1 1
71,1 inovisco Mobile Media GmbH (1) 71 1 1
72,1 mcR&D (2) 72 1 1
73,1 mcR&D (3) 73 1 1

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 10.117ms