albums_labels

10 rows where label_id = 536

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1010 1010 862 862 Orindal 536
1545 1545 1339 1339 Orindal 536
1663 1663 1447 1447 Orindal 536
2625 2625 2289 2289 Orindal 536
3091 3091 2703 2703 Orindal 536
3732 3732 3254 3254 Orindal 536
4194 4194 3670 3670 Orindal 536
4478 4478 3909 3909 Orindal 536
5750 5750 5005 5005 Orindal 536
29901 29901 26939 26939 Orindal 536

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