spotset_timeranges
23 rows where timerange_id = 11
This data as json, copyable, CSV (advanced)
| Link | spotset_id | timerange_id |
|---|---|---|
| 1,11 | Brandstifter AG 1 | 06-09 Uhr 11 |
| 2,11 | CITTADINO GmbH 2 | 06-09 Uhr 11 |
| 3,11 | CITTADINO GmbH (1) 3 | 06-09 Uhr 11 |
| 4,11 | CITTADINO GmbH (2) 4 | 06-09 Uhr 11 |
| 5,11 | CITTADINO GmbH (3) 5 | 06-09 Uhr 11 |
| 6,11 | CITTADINO GmbH (4) 6 | 06-09 Uhr 11 |
| 12,11 | Goldbach Germany 12 | 06-09 Uhr 11 |
| 13,11 | Goldbach Germany (1) 13 | 06-09 Uhr 11 |
| 14,11 | Goldbach Germany (2) 14 | 06-09 Uhr 11 |
| 15,11 | Goldbach Germany (3) 15 | 06-09 Uhr 11 |
| 17,11 | Piranha Media GmbH 17 | 06-09 Uhr 11 |
| 20,11 | Ströer (1) 20 | 06-09 Uhr 11 |
| 24,11 | Ströer (5) 24 | 06-09 Uhr 11 |
| 34,11 | Brandstifter AG (1) 34 | 06-09 Uhr 11 |
| 35,11 | CITTADINO GmbH (5) 35 | 06-09 Uhr 11 |
| 36,11 | CITTADINO GmbH (6) 36 | 06-09 Uhr 11 |
| 37,11 | CITTADINO GmbH (7) 37 | 06-09 Uhr 11 |
| 38,11 | CITTADINO GmbH (8) 38 | 06-09 Uhr 11 |
| 44,11 | Goldbach Germany (4) 44 | 06-09 Uhr 11 |
| 45,11 | Goldbach Germany (5) 45 | 06-09 Uhr 11 |
| 48,11 | Piranha Media GmbH (1) 48 | 06-09 Uhr 11 |
| 51,11 | Ströer (8) 51 | 06-09 Uhr 11 |
| 55,11 | Ströer (12) 55 | 06-09 Uhr 11 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );