albums_labels

5 rows where label_id = 986

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2399 2399 2087 2087 ADA 986
7815 7815 6802 6802 ADA 986
13568 13568 11948 11948 ADA 986
18457 18457 16357 16357 ADA 986
29537 29537 26629 26629 ADA 986

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