albums_labels

7 rows where label_id = 3501

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17222 17222 15219 15219 Ashmont 3501
18360 18360 16266 16266 Ashmont 3501
22007 22007 19631 19631 Ashmont 3501
24003 24003 21490 21490 Ashmont 3501
24509 24509 21966 21966 Ashmont 3501
26378 26378 23754 23754 Ashmont 3501
28344 28344 25582 25582 Ashmont 3501

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