albums_labels

5 rows where label_id = 3475

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17070 17070 15086 15086 Deltasonic 3475
21004 21004 18718 18718 Deltasonic 3475
24650 24650 22096 22096 Deltasonic 3475
25641 25641 23048 23048 Deltasonic 3475
27078 27078 24412 24412 Deltasonic 3475

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE albums_labels (
	album_id integer NOT NULL,
	label_id integer NOT NULL,
	FOREIGN KEY(album_id) REFERENCES albums(id),
	FOREIGN KEY(label_id) REFERENCES labels(id),
	UNIQUE(album_id,label_id)
);