1,090 rows
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
spotset_id
|
timerange_id
|
| 1,2 |
Brand Community Network (BCN) 1 |
00-06 Uhr 2 |
| 1,11 |
Brand Community Network (BCN) 1 |
06-09 Uhr 11 |
| 1,17 |
Brand Community Network (BCN) 1 |
09-12 Uhr 17 |
| 1,24 |
Brand Community Network (BCN) 1 |
12-15 Uhr 24 |
| 1,29 |
Brand Community Network (BCN) 1 |
15-18 Uhr 29 |
| 1,35 |
Brand Community Network (BCN) 1 |
18-21 Uhr 35 |
| 1,40 |
Brand Community Network (BCN) 1 |
21-24 Uhr 40 |
| 1,44 |
Brand Community Network (BCN) 1 |
ganztägig 44 |
| 2,2 |
Brand Community Network (BCN) (1) 2 |
00-06 Uhr 2 |
| 2,11 |
Brand Community Network (BCN) (1) 2 |
06-09 Uhr 11 |
| 2,17 |
Brand Community Network (BCN) (1) 2 |
09-12 Uhr 17 |
| 2,24 |
Brand Community Network (BCN) (1) 2 |
12-15 Uhr 24 |
| 2,29 |
Brand Community Network (BCN) (1) 2 |
15-18 Uhr 29 |
| 2,35 |
Brand Community Network (BCN) (1) 2 |
18-21 Uhr 35 |
| 2,40 |
Brand Community Network (BCN) (1) 2 |
21-24 Uhr 40 |
| 2,44 |
Brand Community Network (BCN) (1) 2 |
ganztägig 44 |
| 3,2 |
Brand Community Network (BCN) (2) 3 |
00-06 Uhr 2 |
| 3,11 |
Brand Community Network (BCN) (2) 3 |
06-09 Uhr 11 |
| 3,17 |
Brand Community Network (BCN) (2) 3 |
09-12 Uhr 17 |
| 3,24 |
Brand Community Network (BCN) (2) 3 |
12-15 Uhr 24 |
| 3,29 |
Brand Community Network (BCN) (2) 3 |
15-18 Uhr 29 |
| 3,35 |
Brand Community Network (BCN) (2) 3 |
18-21 Uhr 35 |
| 3,40 |
Brand Community Network (BCN) (2) 3 |
21-24 Uhr 40 |
| 3,44 |
Brand Community Network (BCN) (2) 3 |
ganztägig 44 |
| 4,2 |
Brand Community Network (BCN) (3) 4 |
00-06 Uhr 2 |
| 4,11 |
Brand Community Network (BCN) (3) 4 |
06-09 Uhr 11 |
| 4,17 |
Brand Community Network (BCN) (3) 4 |
09-12 Uhr 17 |
| 4,24 |
Brand Community Network (BCN) (3) 4 |
12-15 Uhr 24 |
| 4,29 |
Brand Community Network (BCN) (3) 4 |
15-18 Uhr 29 |
| 4,35 |
Brand Community Network (BCN) (3) 4 |
18-21 Uhr 35 |
| 4,40 |
Brand Community Network (BCN) (3) 4 |
21-24 Uhr 40 |
| 4,44 |
Brand Community Network (BCN) (3) 4 |
ganztägig 44 |
| 5,2 |
Brandstifter AG 5 |
00-06 Uhr 2 |
| 5,11 |
Brandstifter AG 5 |
06-09 Uhr 11 |
| 5,17 |
Brandstifter AG 5 |
09-12 Uhr 17 |
| 5,24 |
Brandstifter AG 5 |
12-15 Uhr 24 |
| 5,29 |
Brandstifter AG 5 |
15-18 Uhr 29 |
| 5,35 |
Brandstifter AG 5 |
18-21 Uhr 35 |
| 5,40 |
Brandstifter AG 5 |
21-24 Uhr 40 |
| 5,44 |
Brandstifter AG 5 |
ganztägig 44 |
| 6,44 |
Diverse 6 |
ganztägig 44 |
| 7,44 |
Edgar Ambient Media Group GmbH 7 |
ganztägig 44 |
| 8,44 |
Edgar Ambient Media Group GmbH (1) 8 |
ganztägig 44 |
| 9,44 |
El Cartel Media 9 |
ganztägig 44 |
| 10,44 |
Executive Channel Deutschland GmbH 10 |
ganztägig 44 |
| 11,2 |
Goldbach Germany 11 |
00-06 Uhr 2 |
| 11,11 |
Goldbach Germany 11 |
06-09 Uhr 11 |
| 11,17 |
Goldbach Germany 11 |
09-12 Uhr 17 |
| 11,24 |
Goldbach Germany 11 |
12-15 Uhr 24 |
| 11,29 |
Goldbach Germany 11 |
15-18 Uhr 29 |
| 11,35 |
Goldbach Germany 11 |
18-21 Uhr 35 |
| 11,40 |
Goldbach Germany 11 |
21-24 Uhr 40 |
| 11,44 |
Goldbach Germany 11 |
ganztägig 44 |
| 12,11 |
Goldbach Germany (1) 12 |
06-09 Uhr 11 |
| 12,17 |
Goldbach Germany (1) 12 |
09-12 Uhr 17 |
| 12,24 |
Goldbach Germany (1) 12 |
12-15 Uhr 24 |
| 12,29 |
Goldbach Germany (1) 12 |
15-18 Uhr 29 |
| 12,35 |
Goldbach Germany (1) 12 |
18-21 Uhr 35 |
| 12,40 |
Goldbach Germany (1) 12 |
21-24 Uhr 40 |
| 12,44 |
Goldbach Germany (1) 12 |
ganztägig 44 |
| 13,2 |
Goldbach Germany (2) 13 |
00-06 Uhr 2 |
| 13,11 |
Goldbach Germany (2) 13 |
06-09 Uhr 11 |
| 13,17 |
Goldbach Germany (2) 13 |
09-12 Uhr 17 |
| 13,24 |
Goldbach Germany (2) 13 |
12-15 Uhr 24 |
| 13,29 |
Goldbach Germany (2) 13 |
15-18 Uhr 29 |
| 13,35 |
Goldbach Germany (2) 13 |
18-21 Uhr 35 |
| 13,40 |
Goldbach Germany (2) 13 |
21-24 Uhr 40 |
| 13,44 |
Goldbach Germany (2) 13 |
ganztägig 44 |
| 14,11 |
Goldbach Germany (3) 14 |
06-09 Uhr 11 |
| 14,17 |
Goldbach Germany (3) 14 |
09-12 Uhr 17 |
| 14,24 |
Goldbach Germany (3) 14 |
12-15 Uhr 24 |
| 14,29 |
Goldbach Germany (3) 14 |
15-18 Uhr 29 |
| 14,35 |
Goldbach Germany (3) 14 |
18-21 Uhr 35 |
| 14,44 |
Goldbach Germany (3) 14 |
ganztägig 44 |
| 15,11 |
Goldbach Germany (4) 15 |
06-09 Uhr 11 |
| 15,17 |
Goldbach Germany (4) 15 |
09-12 Uhr 17 |
| 15,24 |
Goldbach Germany (4) 15 |
12-15 Uhr 24 |
| 15,29 |
Goldbach Germany (4) 15 |
15-18 Uhr 29 |
| 15,35 |
Goldbach Germany (4) 15 |
18-21 Uhr 35 |
| 15,40 |
Goldbach Germany (4) 15 |
21-24 Uhr 40 |
| 15,44 |
Goldbach Germany (4) 15 |
ganztägig 44 |
| 16,44 |
Hygh Mobile Media GmbH 16 |
ganztägig 44 |
| 17,44 |
SK2 Solutions GmbH 17 |
ganztägig 44 |
| 18,1 |
Ströer 18 |
00-01 Uhr 1 |
| 18,3 |
Ströer 18 |
01-02 Uhr 3 |
| 18,4 |
Ströer 18 |
02-03 Uhr 4 |
| 18,5 |
Ströer 18 |
03-04 Uhr 5 |
| 18,6 |
Ströer 18 |
04-05 Uhr 6 |
| 18,8 |
Ströer 18 |
05-06 Uhr 8 |
| 18,9 |
Ströer 18 |
06-07 Uhr 9 |
| 18,13 |
Ströer 18 |
07-08 Uhr 13 |
| 18,14 |
Ströer 18 |
08-09 Uhr 14 |
| 18,16 |
Ströer 18 |
09-10 Uhr 16 |
| 18,19 |
Ströer 18 |
10-11 Uhr 19 |
| 18,21 |
Ströer 18 |
11-12 Uhr 21 |
| 18,22 |
Ströer 18 |
12-13 Uhr 22 |
| 18,25 |
Ströer 18 |
13-14 Uhr 25 |
| 18,26 |
Ströer 18 |
14-15 Uhr 26 |
| 18,28 |
Ströer 18 |
15-16 Uhr 28 |
| 18,30 |
Ströer 18 |
16-17 Uhr 30 |
Next page
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)
);