spotset_frequencies
9 rows where frequency_id = 10
This data as json, copyable, CSV (advanced)
| Link | spotset_id | frequency_id |
|---|---|---|
| 1,10 | Brand Community Network (BCN) 1 | 10 10 |
| 11,10 | Executive Channel Deutschland GmbH 11 | 10 10 |
| 12,10 | Goldbach Germany 12 | 10 10 |
| 14,10 | Goldbach Germany (2) 14 | 10 10 |
| 15,10 | Goldbach Germany (3) 15 | 10 10 |
| 34,10 | Brand Community Network (BCN) (5) 34 | 10 10 |
| 43,10 | Executive Channel Deutschland GmbH (1) 43 | 10 10 |
| 44,10 | Goldbach Germany (4) 44 | 10 10 |
| 47,10 | ISM Intelligent Signage for Media GmbH 47 | 10 10 |
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) );