albums_labels

5 rows where label_id = 2120

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7627 7627 6642 6642 American Laundromat 2120
8410 8410 7325 7325 American Laundromat 2120
10862 10862 9508 9508 American Laundromat 2120
18949 18949 16802 16802 American Laundromat 2120
23261 23261 20791 20791 American Laundromat 2120

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