albums_labels

9 rows where label_id = 673

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1398 1398 1207 1207 Chrysalis 673
1864 1864 1632 1632 Chrysalis 673
1915 1915 1672 1672 Chrysalis 673
3379 3379 2953 2953 Chrysalis 673
4394 4394 3835 3835 Chrysalis 673
18752 18752 16632 16632 Chrysalis 673
29023 29023 26194 26194 Chrysalis 673
30172 30172 27191 27191 Chrysalis 673
30268 30268 27275 27275 Chrysalis 673

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