home / PUP_Spotconfigs_2022_01

spotset_timeranges

34 rows where timerange_id = 25

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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