6 rows where frequency_id = 11

View and edit SQL

Link spotset_id frequency_id
Brand Community Network (BCN) (2) 3 11 11
Goldbach Germany 11 11 11
Goldbach Germany (3) 14 11 11
Goldbach Germany (4) 15 11 11
Brand Community Network (BCN) (6) 38 11 11
Goldbach Germany (6) 52 11 11

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);