home / PUP_Spotconfigs_2022_01

spotset_weekdays

54 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
5,2 Brandstifter AG 5 So 2
11,2 Goldbach Germany 11 So 2
12,2 Goldbach Germany (1) 12 So 2
13,2 Goldbach Germany (2) 13 So 2
15,2 Goldbach Germany (4) 15 So 2
18,2 Ströer 18 So 2
20,2 Ströer (2) 20 So 2
21,2 Ströer (3) 21 So 2
24,2 Ströer (6) 24 So 2
25,2 Ströer (7) 25 So 2
29,2 X-City Marketing 29 So 2
30,2 X-City Marketing (1) 30 So 2
34,2 mcR&D 34 So 2
35,2 mcR&D (1) 35 So 2
36,2 Brand Community Network (BCN) (4) 36 So 2
37,2 Brand Community Network (BCN) (5) 37 So 2
38,2 Brand Community Network (BCN) (6) 38 So 2
39,2 Brand Community Network (BCN) (7) 39 So 2
40,2 Brandstifter AG (1) 40 So 2
41,2 DUS Airport Media 41 So 2
42,2 Diverse (1) 42 So 2
43,2 Diverse (2) 43 So 2
44,2 Diverse (3) 44 So 2
45,2 Edgar Ambient Media Group GmbH (2) 45 So 2
46,2 Edgar Ambient Media Group GmbH (3) 46 So 2
47,2 Edgar Ambient Media Group GmbH (4) 47 So 2
48,2 El Cartel Media (1) 48 So 2
49,2 Executive Channel Deutschland GmbH (1) 49 So 2
50,2 Flughafen Hamburg GmbH 50 So 2
51,2 Goldbach Germany (5) 51 So 2
52,2 Goldbach Germany (6) 52 So 2
53,2 Goldbach Germany (7) 53 So 2
54,2 Goldbach Germany (8) 54 So 2
55,2 Hygh Mobile Media GmbH (1) 55 So 2
56,2 Hygh Mobile Media GmbH (2) 56 So 2
57,2 SK2 Solutions GmbH (1) 57 So 2
58,2 Ströer (8) 58 So 2
59,2 Ströer (9) 59 So 2
60,2 Ströer (10) 60 So 2
63,2 Ströer (13) 63 So 2
64,2 Ströer (14) 64 So 2
65,2 TV Wartezimmer (1) 65 So 2
66,2 VIEWENTO GmbH (1) 66 So 2
67,2 WallDecaux (1) 67 So 2
68,2 X-City Marketing (2) 68 So 2
69,2 airtango media GmbH (1) 69 So 2
70,2 echion Corporate Communication AG (1) 70 So 2
71,2 inovisco Mobile Media GmbH (1) 71 So 2
72,2 mcR&D (2) 72 So 2
73,2 mcR&D (3) 73 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 9.533ms