albums_labels

7 rows where label_id = 1812

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5993 5993 5227 5227 Orindal 1812
7778 7778 6770 6770 Orindal 1812
8087 8087 7042 7042 Orindal 1812
8587 8587 7490 7490 Orindal 1812
10140 10140 8873 8873 Orindal 1812
12306 12306 10785 10785 Orindal 1812
14546 14546 12848 12848 Orindal 1812

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