home / PUP_Spotconfigs_2022_01

spotset_timeranges

34 rows where timerange_id = 41

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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