albums_labels

10 rows where label_id = 671

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1391 1391 1201 1201 Cinematic 671
3723 3723 3245 3245 Cinematic 671
4919 4919 4299 4299 Cinematic 671
5374 5374 4679 4679 Cinematic 671
7722 7722 6719 6719 Cinematic 671
9867 9867 8631 8631 Cinematic 671
10939 10939 9575 9575 Cinematic 671
13017 13017 11437 11437 Cinematic 671
13322 13322 11722 11722 Cinematic 671
13735 13735 12099 12099 Cinematic 671

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