albums_labels

4 rows where label_id = 1500

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4504 4504 3930 3930 Sour Mash 1500
6755 6755 5884 5884 Sour Mash 1500
10827 10827 9476 9476 Sour Mash 1500
15374 15374 13583 13583 Sour Mash 1500

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