albums_labels

12 rows where label_id = 4054

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20902 20902 18623 18623 Recordcollection 4054
22123 22123 19740 19740 Recordcollection 4054
22702 22702 20263 20263 Recordcollection 4054
22954 22954 20496 20496 Recordcollection 4054
24082 24082 21565 21565 Recordcollection 4054
24197 24197 21670 21670 Recordcollection 4054
24306 24306 21775 21775 Recordcollection 4054
24470 24470 21931 21931 Recordcollection 4054
24966 24966 22402 22402 Recordcollection 4054
25064 25064 22500 22500 Recordcollection 4054
25215 25215 22641 22641 Recordcollection 4054
25725 25725 23130 23130 Recordcollection 4054

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