albums_artists

7 rows where artist_id = 1549

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1731 1731 1632 1632 1549 1549
10428 10428 10086 10086 1549 1549
13518 13518 13167 13167 1549 1549
16940 16940 16632 16632 1549 1549
21030 21030 20888 20888 1549 1549
24412 24412 24300 24300 1549 1549
25968 25968 25870 25870 1549 1549

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE albums_artists (
	album_id integer NOT NULL,
	artist_id integer NOT NULL,
	FOREIGN KEY(artist_id) REFERENCES artists(id),
	FOREIGN KEY(album_id) REFERENCES albums(id),
	UNIQUE(album_id, artist_id)
);