albums_labels

5 rows where label_id = 1952

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6676 6676 5811 5811 Showoff 1952
10307 10307 9019 9019 Showoff 1952
15782 15782 13931 13931 Showoff 1952
19262 19262 17114 17114 Showoff 1952
29178 29178 26320 26320 Showoff 1952

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