27 rows
where timerange_id = 9
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
|
Link
|
spotset_id
|
timerange_id
|
| 20,9 |
Ströer 20 |
06-07 Uhr 9 |
| 30,9 |
X-City Marketing 30 |
06-07 Uhr 9 |
| 35,9 |
Brand Community Network (BCN) (5) 35 |
06-07 Uhr 9 |
| 36,9 |
Brand Community Network (BCN) (6) 36 |
06-07 Uhr 9 |
| 37,9 |
Brand Community Network (BCN) (7) 37 |
06-07 Uhr 9 |
| 38,9 |
Brand Community Network (BCN) (8) 38 |
06-07 Uhr 9 |
| 39,9 |
Brandstifter AG (1) 39 |
06-07 Uhr 9 |
| 40,9 |
Diverse (1) 40 |
06-07 Uhr 9 |
| 41,9 |
Edgar Ambient Media Group GmbH (2) 41 |
06-07 Uhr 9 |
| 42,9 |
Edgar Ambient Media Group GmbH (3) 42 |
06-07 Uhr 9 |
| 43,9 |
El Cartel Media (1) 43 |
06-07 Uhr 9 |
| 44,9 |
Executive Channel Deutschland GmbH (1) 44 |
06-07 Uhr 9 |
| 45,9 |
Goldbach Germany (4) 45 |
06-07 Uhr 9 |
| 46,9 |
Goldbach Germany (5) 46 |
06-07 Uhr 9 |
| 47,9 |
HYGH AG (1) 47 |
06-07 Uhr 9 |
| 48,9 |
ISM Intelligent Signage for Media GmbH (1) 48 |
06-07 Uhr 9 |
| 49,9 |
Piranha Media GmbH (1) 49 |
06-07 Uhr 9 |
| 50,9 |
SK2 Solutions GmbH (1) 50 |
06-07 Uhr 9 |
| 51,9 |
Ströer (7) 51 |
06-07 Uhr 9 |
| 58,9 |
TV-Wartezimmer (1) 58 |
06-07 Uhr 9 |
| 59,9 |
VIEWENTO GmbH (1) 59 |
06-07 Uhr 9 |
| 60,9 |
WallDecaux (1) 60 |
06-07 Uhr 9 |
| 61,9 |
X-City Marketing (1) 61 |
06-07 Uhr 9 |
| 62,9 |
airtango media GmbH (1) 62 |
06-07 Uhr 9 |
| 63,9 |
echion Corporate Communication AG (1) 63 |
06-07 Uhr 9 |
| 64,9 |
inovisco Mobile Media GmbH (1) 64 |
06-07 Uhr 9 |
| 65,9 |
mcR&D (1) 65 |
06-07 Uhr 9 |
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)
);