home / PUP_Spotconfigs_2022_01

spotset_timeranges

34 rows where timerange_id = 37

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Advanced export

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

CSV options:

CREATE TABLE spotset_timeranges (
	spotset_id INTEGER NOT NULL, 
	timerange_id INTEGER NOT NULL, 
	PRIMARY KEY (spotset_id, timerange_id), 
	FOREIGN KEY(spotset_id) REFERENCES spotset (id), 
	FOREIGN KEY(timerange_id) REFERENCES time_range (id)
);
Powered by Datasette · Queries took 8.222ms