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 |
| 20,5 | Ströer 20 | 5 5 |
| 30,5 | X-City Marketing 30 | 5 5 |
| 43,5 | El Cartel Media (1) 43 | 5 5 |
| 51,5 | Ströer (7) 51 | 5 5 |
| 61,5 | X-City Marketing (1) 61 | 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) );