albums_labels

7 rows where label_id = 963

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2352 2352 2046 2046 Dull Tools 963
6887 6887 6002 6002 Dull Tools 963
10758 10758 9413 9413 Dull Tools 963
11339 11339 9918 9918 Dull Tools 963
12130 12130 10621 10621 Dull Tools 963
12669 12669 11122 11122 Dull Tools 963
13720 13720 12085 12085 Dull Tools 963

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