10 rows
where frequency_id = 10
✎ View and edit SQL
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 |
| 17,10 |
ISM Intelligent Signage for Media GmbH 17 |
10 10 |
| 35,10 |
Brand Community Network (BCN) (5) 35 |
10 10 |
| 44,10 |
Executive Channel Deutschland GmbH (1) 44 |
10 10 |
| 45,10 |
Goldbach Germany (4) 45 |
10 10 |
| 48,10 |
ISM Intelligent Signage for Media GmbH (1) 48 |
10 10 |
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)
);