albums_labels

6 rows where label_id = 619

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1222 1222 1054 1054 Tan Cressida 619
3950 3950 3452 3452 Tan Cressida 619
5238 5238 4571 4571 Tan Cressida 619
10737 10737 9396 9396 Tan Cressida 619
12874 12874 11307 11307 Tan Cressida 619
29893 29893 26935 26935 Tan Cressida 619

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