spotset_frequencies
9 rows where frequency_id = 17
This data as json, copyable, CSV (advanced)
| Link | spotset_id | frequency_id |
|---|---|---|
| 2,17 | Brand Community Network (BCN) (1) 2 | 17 17 |
| 37,17 | Brand Community Network (BCN) (5) 37 | 17 17 |
| 41,17 | DUS Airport Media 41 | 17 17 |
| 42,17 | Diverse (1) 42 | 17 17 |
| 44,17 | Diverse (3) 44 | 17 17 |
| 47,17 | Edgar Ambient Media Group GmbH (4) 47 | 17 17 |
| 50,17 | Flughafen Hamburg GmbH 50 | 17 17 |
| 51,17 | Goldbach Germany (5) 51 | 17 17 |
| 55,17 | Hygh Mobile Media GmbH (1) 55 | 17 17 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE spotset_frequencies ( spotset_id INTEGER NOT NULL, frequency_id INTEGER NOT NULL, PRIMARY KEY (spotset_id, frequency_id), FOREIGN KEY(spotset_id) REFERENCES spotset (id), FOREIGN KEY(frequency_id) REFERENCES frequency (id) );