albums_labels

21 rows where label_id = 73

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
84 84 75 75 Mass Appeal 73
1229 1229 1059 1059 Mass Appeal 73
1691 1691 1472 1472 Mass Appeal 73
2856 2856 2492 2492 Mass Appeal 73
3872 3872 3383 3383 Mass Appeal 73
4364 4364 3810 3810 Mass Appeal 73
5916 5916 5159 5159 Mass Appeal 73
6431 6431 5597 5597 Mass Appeal 73
7340 7340 6382 6382 Mass Appeal 73
8716 8716 7601 7601 Mass Appeal 73
8913 8913 7783 7783 Mass Appeal 73
9205 9205 8050 8050 Mass Appeal 73
9625 9625 8419 8419 Mass Appeal 73
9684 9684 8469 8469 Mass Appeal 73
9956 9956 8705 8705 Mass Appeal 73
10169 10169 8898 8898 Mass Appeal 73
10628 10628 9302 9302 Mass Appeal 73
11226 11226 9821 9821 Mass Appeal 73
29780 29780 26837 26837 Mass Appeal 73
29800 29800 26856 26856 Mass Appeal 73
30093 30093 27115 27115 Mass Appeal 73

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