albums_labels

6 rows where label_id = 3477

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17086 17086 15101 15101 St. Ives 3477
17406 17406 15378 15378 St. Ives 3477
20330 20330 18105 18105 St. Ives 3477
21092 21092 18799 18799 St. Ives 3477
22102 22102 19720 19720 St. Ives 3477
28103 28103 25362 25362 St. Ives 3477

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