home / PUP_Spotconfigs_2022_02_v09

spotset_timeranges

25 rows where timerange_id = 29

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link spotset_id timerange_id
1,29 Brand Community Network (BCN) 1 15-18 Uhr 29
2,29 Brand Community Network (BCN) (1) 2 15-18 Uhr 29
3,29 Brand Community Network (BCN) (2) 3 15-18 Uhr 29
4,29 Brand Community Network (BCN) (3) 4 15-18 Uhr 29
5,29 Brand Community Network (BCN) (4) 5 15-18 Uhr 29
6,29 Brandstifter AG 6 15-18 Uhr 29
12,29 Goldbach Germany 12 15-18 Uhr 29
13,29 Goldbach Germany (1) 13 15-18 Uhr 29
14,29 Goldbach Germany (2) 14 15-18 Uhr 29
15,29 Goldbach Germany (3) 15 15-18 Uhr 29
18,29 Piranha Media GmbH 18 15-18 Uhr 29
21,29 Ströer (1) 21 15-18 Uhr 29
23,29 Ströer (3) 23 15-18 Uhr 29
25,29 Ströer (5) 25 15-18 Uhr 29
35,29 Brand Community Network (BCN) (5) 35 15-18 Uhr 29
36,29 Brand Community Network (BCN) (6) 36 15-18 Uhr 29
37,29 Brand Community Network (BCN) (7) 37 15-18 Uhr 29
38,29 Brand Community Network (BCN) (8) 38 15-18 Uhr 29
39,29 Brandstifter AG (1) 39 15-18 Uhr 29
45,29 Goldbach Germany (4) 45 15-18 Uhr 29
46,29 Goldbach Germany (5) 46 15-18 Uhr 29
49,29 Piranha Media GmbH (1) 49 15-18 Uhr 29
52,29 Ströer (8) 52 15-18 Uhr 29
54,29 Ströer (10) 54 15-18 Uhr 29
56,29 Ströer (12) 56 15-18 Uhr 29

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.304ms