34 rows
where timerange_id = 8
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
spotset_id
|
timerange_id
|
| 18,8 |
Ströer 18 |
05-06 Uhr 8 |
| 19,8 |
Ströer (1) 19 |
05-06 Uhr 8 |
| 30,8 |
X-City Marketing (1) 30 |
05-06 Uhr 8 |
| 36,8 |
Brand Community Network (BCN) (4) 36 |
05-06 Uhr 8 |
| 37,8 |
Brand Community Network (BCN) (5) 37 |
05-06 Uhr 8 |
| 38,8 |
Brand Community Network (BCN) (6) 38 |
05-06 Uhr 8 |
| 39,8 |
Brand Community Network (BCN) (7) 39 |
05-06 Uhr 8 |
| 40,8 |
Brandstifter AG (1) 40 |
05-06 Uhr 8 |
| 41,8 |
DUS Airport Media 41 |
05-06 Uhr 8 |
| 43,8 |
Diverse (2) 43 |
05-06 Uhr 8 |
| 44,8 |
Diverse (3) 44 |
05-06 Uhr 8 |
| 45,8 |
Edgar Ambient Media Group GmbH (2) 45 |
05-06 Uhr 8 |
| 46,8 |
Edgar Ambient Media Group GmbH (3) 46 |
05-06 Uhr 8 |
| 47,8 |
Edgar Ambient Media Group GmbH (4) 47 |
05-06 Uhr 8 |
| 48,8 |
El Cartel Media (1) 48 |
05-06 Uhr 8 |
| 49,8 |
Executive Channel Deutschland GmbH (1) 49 |
05-06 Uhr 8 |
| 50,8 |
Flughafen Hamburg GmbH 50 |
05-06 Uhr 8 |
| 51,8 |
Goldbach Germany (5) 51 |
05-06 Uhr 8 |
| 52,8 |
Goldbach Germany (6) 52 |
05-06 Uhr 8 |
| 53,8 |
Goldbach Germany (7) 53 |
05-06 Uhr 8 |
| 54,8 |
Goldbach Germany (8) 54 |
05-06 Uhr 8 |
| 55,8 |
Hygh Mobile Media GmbH (1) 55 |
05-06 Uhr 8 |
| 56,8 |
Hygh Mobile Media GmbH (2) 56 |
05-06 Uhr 8 |
| 57,8 |
SK2 Solutions GmbH (1) 57 |
05-06 Uhr 8 |
| 58,8 |
Ströer (8) 58 |
05-06 Uhr 8 |
| 65,8 |
TV Wartezimmer (1) 65 |
05-06 Uhr 8 |
| 66,8 |
VIEWENTO GmbH (1) 66 |
05-06 Uhr 8 |
| 67,8 |
WallDecaux (1) 67 |
05-06 Uhr 8 |
| 68,8 |
X-City Marketing (2) 68 |
05-06 Uhr 8 |
| 69,8 |
airtango media GmbH (1) 69 |
05-06 Uhr 8 |
| 70,8 |
echion Corporate Communication AG (1) 70 |
05-06 Uhr 8 |
| 71,8 |
inovisco Mobile Media GmbH (1) 71 |
05-06 Uhr 8 |
| 72,8 |
mcR&D (2) 72 |
05-06 Uhr 8 |
| 73,8 |
mcR&D (3) 73 |
05-06 Uhr 8 |
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)
);