892 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,11 |
Brand Community Network (BCN) (4) 5 |
06-09 Uhr 11 |
| 5,17 |
Brand Community Network (BCN) (4) 5 |
09-12 Uhr 17 |
| 5,24 |
Brand Community Network (BCN) (4) 5 |
12-15 Uhr 24 |
| 5,29 |
Brand Community Network (BCN) (4) 5 |
15-18 Uhr 29 |
| 5,35 |
Brand Community Network (BCN) (4) 5 |
18-21 Uhr 35 |
| 5,44 |
Brand Community Network (BCN) (4) 5 |
ganztägig 44 |
| 6,2 |
Brandstifter AG 6 |
00-06 Uhr 2 |
| 6,11 |
Brandstifter AG 6 |
06-09 Uhr 11 |
| 6,17 |
Brandstifter AG 6 |
09-12 Uhr 17 |
| 6,24 |
Brandstifter AG 6 |
12-15 Uhr 24 |
| 6,29 |
Brandstifter AG 6 |
15-18 Uhr 29 |
| 6,35 |
Brandstifter AG 6 |
18-21 Uhr 35 |
| 6,40 |
Brandstifter AG 6 |
21-24 Uhr 40 |
| 6,44 |
Brandstifter AG 6 |
ganztägig 44 |
| 7,44 |
Diverse 7 |
ganztägig 44 |
| 8,44 |
Edgar Ambient Media Group GmbH 8 |
ganztägig 44 |
| 9,44 |
Edgar Ambient Media Group GmbH (1) 9 |
ganztägig 44 |
| 10,44 |
El Cartel Media 10 |
ganztägig 44 |
| 11,44 |
Executive Channel Deutschland GmbH 11 |
ganztägig 44 |
| 12,2 |
Goldbach Germany 12 |
00-06 Uhr 2 |
| 12,11 |
Goldbach Germany 12 |
06-09 Uhr 11 |
| 12,17 |
Goldbach Germany 12 |
09-12 Uhr 17 |
| 12,24 |
Goldbach Germany 12 |
12-15 Uhr 24 |
| 12,29 |
Goldbach Germany 12 |
15-18 Uhr 29 |
| 12,35 |
Goldbach Germany 12 |
18-21 Uhr 35 |
| 12,40 |
Goldbach Germany 12 |
21-24 Uhr 40 |
| 12,44 |
Goldbach Germany 12 |
ganztägig 44 |
| 13,11 |
Goldbach Germany (1) 13 |
06-09 Uhr 11 |
| 13,17 |
Goldbach Germany (1) 13 |
09-12 Uhr 17 |
| 13,24 |
Goldbach Germany (1) 13 |
12-15 Uhr 24 |
| 13,29 |
Goldbach Germany (1) 13 |
15-18 Uhr 29 |
| 13,35 |
Goldbach Germany (1) 13 |
18-21 Uhr 35 |
| 13,40 |
Goldbach Germany (1) 13 |
21-24 Uhr 40 |
| 13,44 |
Goldbach Germany (1) 13 |
ganztägig 44 |
| 14,11 |
Goldbach Germany (2) 14 |
06-09 Uhr 11 |
| 14,17 |
Goldbach Germany (2) 14 |
09-12 Uhr 17 |
| 14,24 |
Goldbach Germany (2) 14 |
12-15 Uhr 24 |
| 14,29 |
Goldbach Germany (2) 14 |
15-18 Uhr 29 |
| 14,35 |
Goldbach Germany (2) 14 |
18-21 Uhr 35 |
| 14,44 |
Goldbach Germany (2) 14 |
ganztägig 44 |
| 15,11 |
Goldbach Germany (3) 15 |
06-09 Uhr 11 |
| 15,17 |
Goldbach Germany (3) 15 |
09-12 Uhr 17 |
| 15,24 |
Goldbach Germany (3) 15 |
12-15 Uhr 24 |
| 15,29 |
Goldbach Germany (3) 15 |
15-18 Uhr 29 |
| 15,35 |
Goldbach Germany (3) 15 |
18-21 Uhr 35 |
| 15,40 |
Goldbach Germany (3) 15 |
21-24 Uhr 40 |
| 15,44 |
Goldbach Germany (3) 15 |
ganztägig 44 |
| 16,44 |
HYGH AG 16 |
ganztägig 44 |
| 17,44 |
ISM Intelligent Signage for Media GmbH 17 |
ganztägig 44 |
| 18,2 |
Piranha Media GmbH 18 |
00-06 Uhr 2 |
| 18,11 |
Piranha Media GmbH 18 |
06-09 Uhr 11 |
| 18,17 |
Piranha Media GmbH 18 |
09-12 Uhr 17 |
| 18,24 |
Piranha Media GmbH 18 |
12-15 Uhr 24 |
| 18,29 |
Piranha Media GmbH 18 |
15-18 Uhr 29 |
| 18,35 |
Piranha Media GmbH 18 |
18-21 Uhr 35 |
| 18,40 |
Piranha Media GmbH 18 |
21-24 Uhr 40 |
| 18,44 |
Piranha Media GmbH 18 |
ganztägig 44 |
| 19,44 |
SK2 Solutions GmbH 19 |
ganztägig 44 |
| 20,1 |
Ströer 20 |
00-01 Uhr 1 |
| 20,3 |
Ströer 20 |
01-02 Uhr 3 |
| 20,4 |
Ströer 20 |
02-03 Uhr 4 |
| 20,5 |
Ströer 20 |
03-04 Uhr 5 |
| 20,6 |
Ströer 20 |
04-05 Uhr 6 |
| 20,8 |
Ströer 20 |
05-06 Uhr 8 |
| 20,9 |
Ströer 20 |
06-07 Uhr 9 |
| 20,13 |
Ströer 20 |
07-08 Uhr 13 |
| 20,14 |
Ströer 20 |
08-09 Uhr 14 |
| 20,16 |
Ströer 20 |
09-10 Uhr 16 |
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)
);