albums_labels

10 rows where label_id = 500

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
913 913 779 779 Blacksmith 500
1800 1800 1572 1572 Blacksmith 500
4641 4641 4051 4051 Blacksmith 500
5356 5356 4665 4665 Blacksmith 500
7413 7413 6448 6448 Blacksmith 500
8636 8636 7529 7529 Blacksmith 500
13275 13275 11680 11680 Blacksmith 500
17299 17299 15289 15289 Blacksmith 500
19343 19343 17195 17195 Blacksmith 500
20976 20976 18690 18690 Blacksmith 500

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