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