albums_labels

17 rows where label_id = 478

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
858 858 730 730 Rock Action 478
2241 2241 1951 1951 Rock Action 478
4555 4555 3978 3978 Rock Action 478
5621 5621 4891 4891 Rock Action 478
7771 7771 6765 6765 Rock Action 478
9253 9253 8093 8093 Rock Action 478
9924 9924 8679 8679 Rock Action 478
11099 11099 9714 9714 Rock Action 478
13532 13532 11916 11916 Rock Action 478
13814 13814 12170 12170 Rock Action 478
15519 15519 13710 13710 Rock Action 478
15801 15801 13950 13950 Rock Action 478
16344 16344 14433 14433 Rock Action 478
16957 16957 14978 14978 Rock Action 478
18015 18015 15940 15940 Rock Action 478
23758 23758 21255 21255 Rock Action 478
29556 29556 26646 26646 Rock Action 478

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