home / PUP_Spotconfigs_2022_02

spotset_weekdays

45 rows where weekdays_id = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link spotset_id weekdays_id
1,2 Brand Community Network (BCN) 1 So 2
2,2 Brand Community Network (BCN) (1) 2 So 2
3,2 Brand Community Network (BCN) (2) 3 So 2
4,2 Brand Community Network (BCN) (3) 4 So 2
6,2 Brandstifter AG 6 So 2
12,2 Goldbach Germany 12 So 2
13,2 Goldbach Germany (1) 13 So 2
15,2 Goldbach Germany (3) 15 So 2
17,2 Piranha Media GmbH 17 So 2
19,2 Ströer 19 So 2
20,2 Ströer (1) 20 So 2
21,2 Ströer (2) 21 So 2
24,2 Ströer (5) 24 So 2
25,2 Ströer (6) 25 So 2
29,2 X-City Marketing 29 So 2
33,2 mcR&D 33 So 2
34,2 Brand Community Network (BCN) (5) 34 So 2
35,2 Brand Community Network (BCN) (6) 35 So 2
36,2 Brand Community Network (BCN) (7) 36 So 2
37,2 Brand Community Network (BCN) (8) 37 So 2
38,2 Brandstifter AG (1) 38 So 2
39,2 Diverse (1) 39 So 2
40,2 Edgar Ambient Media Group GmbH (2) 40 So 2
41,2 Edgar Ambient Media Group GmbH (3) 41 So 2
42,2 El Cartel Media (1) 42 So 2
43,2 Executive Channel Deutschland GmbH (1) 43 So 2
44,2 Goldbach Germany (4) 44 So 2
45,2 Goldbach Germany (5) 45 So 2
46,2 HYGH AG (1) 46 So 2
47,2 ISM Intelligent Signage for Media GmbH 47 So 2
48,2 Piranha Media GmbH (1) 48 So 2
49,2 SK2 Solutions GmbH (1) 49 So 2
50,2 Ströer (7) 50 So 2
51,2 Ströer (8) 51 So 2
52,2 Ströer (9) 52 So 2
55,2 Ströer (12) 55 So 2
56,2 Ströer (13) 56 So 2
57,2 TV-Wartezimmer (1) 57 So 2
58,2 VIEWENTO GmbH (1) 58 So 2
59,2 WallDecaux (1) 59 So 2
60,2 X-City Marketing (1) 60 So 2
61,2 airtango media GmbH (1) 61 So 2
62,2 echion Corporate Communication AG (1) 62 So 2
63,2 inovisco Mobile Media GmbH (1) 63 So 2
64,2 mcR&D (1) 64 So 2

Advanced export

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

CSV options:

CREATE TABLE spotset_weekdays (
	spotset_id INTEGER NOT NULL, 
	weekdays_id INTEGER NOT NULL, 
	PRIMARY KEY (spotset_id, weekdays_id), 
	FOREIGN KEY(spotset_id) REFERENCES spotset (id), 
	FOREIGN KEY(weekdays_id) REFERENCES weekday (id)
);
Powered by Datasette · Queries took 8.524ms