spotset_frequencies
6 rows where frequency_id = 5
This data as json, copyable, CSV (advanced)
| Link | spotset_id | frequency_id |
|---|---|---|
| 10,5 | El Cartel Media 10 | 5 5 |
| 19,5 | Ströer 19 | 5 5 |
| 29,5 | X-City Marketing 29 | 5 5 |
| 42,5 | El Cartel Media (1) 42 | 5 5 |
| 50,5 | Ströer (7) 50 | 5 5 |
| 60,5 | X-City Marketing (1) 60 | 5 5 |
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) );