spotset_frequencies
6 rows where frequency_id = 3
This data as json, copyable, CSV (advanced)
| Link | spotset_id | frequency_id |
|---|---|---|
| 20,3 | Ströer (1) 20 | 3 3 |
| 21,3 | Ströer (2) 21 | 3 3 |
| 26,3 | TV-Wartezimmer 26 | 3 3 |
| 51,3 | Ströer (8) 51 | 3 3 |
| 52,3 | Ströer (9) 52 | 3 3 |
| 57,3 | TV-Wartezimmer (1) 57 | 3 3 |
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) );