25 rows
where timerange_id = 24
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
spotset_id
|
timerange_id
|
| 1,24 |
Brand Community Network (BCN) 1 |
12-15 Uhr 24 |
| 2,24 |
Brand Community Network (BCN) (1) 2 |
12-15 Uhr 24 |
| 3,24 |
Brand Community Network (BCN) (2) 3 |
12-15 Uhr 24 |
| 4,24 |
Brand Community Network (BCN) (3) 4 |
12-15 Uhr 24 |
| 5,24 |
Brand Community Network (BCN) (4) 5 |
12-15 Uhr 24 |
| 6,24 |
Brandstifter AG 6 |
12-15 Uhr 24 |
| 12,24 |
Goldbach Germany 12 |
12-15 Uhr 24 |
| 13,24 |
Goldbach Germany (1) 13 |
12-15 Uhr 24 |
| 14,24 |
Goldbach Germany (2) 14 |
12-15 Uhr 24 |
| 15,24 |
Goldbach Germany (3) 15 |
12-15 Uhr 24 |
| 18,24 |
Piranha Media GmbH 18 |
12-15 Uhr 24 |
| 21,24 |
Ströer (1) 21 |
12-15 Uhr 24 |
| 23,24 |
Ströer (3) 23 |
12-15 Uhr 24 |
| 25,24 |
Ströer (5) 25 |
12-15 Uhr 24 |
| 35,24 |
Brand Community Network (BCN) (5) 35 |
12-15 Uhr 24 |
| 36,24 |
Brand Community Network (BCN) (6) 36 |
12-15 Uhr 24 |
| 37,24 |
Brand Community Network (BCN) (7) 37 |
12-15 Uhr 24 |
| 38,24 |
Brand Community Network (BCN) (8) 38 |
12-15 Uhr 24 |
| 39,24 |
Brandstifter AG (1) 39 |
12-15 Uhr 24 |
| 45,24 |
Goldbach Germany (4) 45 |
12-15 Uhr 24 |
| 46,24 |
Goldbach Germany (5) 46 |
12-15 Uhr 24 |
| 49,24 |
Piranha Media GmbH (1) 49 |
12-15 Uhr 24 |
| 52,24 |
Ströer (8) 52 |
12-15 Uhr 24 |
| 54,24 |
Ströer (10) 54 |
12-15 Uhr 24 |
| 56,24 |
Ströer (12) 56 |
12-15 Uhr 24 |
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)
);