25 rows
where timerange_id = 29
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
spotset_id
|
timerange_id
|
| 1,29 |
Brandstifter AG 1 |
15-18 Uhr 29 |
| 2,29 |
CITTADINO GmbH 2 |
15-18 Uhr 29 |
| 3,29 |
CITTADINO GmbH (1) 3 |
15-18 Uhr 29 |
| 4,29 |
CITTADINO GmbH (2) 4 |
15-18 Uhr 29 |
| 5,29 |
CITTADINO GmbH (3) 5 |
15-18 Uhr 29 |
| 6,29 |
CITTADINO GmbH (4) 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 |
| 17,29 |
Piranha Media GmbH 17 |
15-18 Uhr 29 |
| 20,29 |
Ströer (1) 20 |
15-18 Uhr 29 |
| 22,29 |
Ströer (3) 22 |
15-18 Uhr 29 |
| 24,29 |
Ströer (5) 24 |
15-18 Uhr 29 |
| 34,29 |
Brandstifter AG (1) 34 |
15-18 Uhr 29 |
| 35,29 |
CITTADINO GmbH (5) 35 |
15-18 Uhr 29 |
| 36,29 |
CITTADINO GmbH (6) 36 |
15-18 Uhr 29 |
| 37,29 |
CITTADINO GmbH (7) 37 |
15-18 Uhr 29 |
| 38,29 |
CITTADINO GmbH (8) 38 |
15-18 Uhr 29 |
| 44,29 |
Goldbach Germany (4) 44 |
15-18 Uhr 29 |
| 45,29 |
Goldbach Germany (5) 45 |
15-18 Uhr 29 |
| 48,29 |
Piranha Media GmbH (1) 48 |
15-18 Uhr 29 |
| 51,29 |
Ströer (8) 51 |
15-18 Uhr 29 |
| 53,29 |
Ströer (10) 53 |
15-18 Uhr 29 |
| 55,29 |
Ströer (12) 55 |
15-18 Uhr 29 |
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)
);