albums_labels

25 rows where label_id = 116

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
132 132 114 114 Topshelf 116
133 133 115 115 Topshelf 116
1675 1675 1458 1458 Topshelf 116
2150 2150 1869 1869 Topshelf 116
2233 2233 1944 1944 Topshelf 116
2669 2669 2328 2328 Topshelf 116
2954 2954 2580 2580 Topshelf 116
3547 3547 3095 3095 Topshelf 116
5754 5754 5009 5009 Topshelf 116
6331 6331 5515 5515 Topshelf 116
6628 6628 5769 5769 Topshelf 116
7245 7245 6304 6304 Topshelf 116
7291 7291 6343 6343 Topshelf 116
8767 8767 7650 7650 Topshelf 116
9055 9055 7911 7911 Topshelf 116
9196 9196 8041 8041 Topshelf 116
10300 10300 9013 9013 Topshelf 116
10358 10358 9063 9063 Topshelf 116
10563 10563 9246 9246 Topshelf 116
11672 11672 10217 10217 Topshelf 116
12379 12379 10852 10852 Topshelf 116
29244 29244 26374 26374 Topshelf 116
29490 29490 26588 26588 Topshelf 116
29906 29906 26944 26944 Topshelf 116
29954 29954 26988 26988 Topshelf 116

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