albums_artists

11 rows where artist_id = 1629

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1839 1839 1737 1737 1629 1629
3392 3392 3201 3201 1629 1629
7287 7287 6992 6992 1629 1629
8439 8439 8112 8112 1629 1629
11743 11743 11401 11401 1629 1629
12767 12767 12425 12425 1629 1629
16945 16945 16637 16637 1629 1629
19985 19985 19799 19799 1629 1629
20402 20402 20236 20236 1629 1629
26203 26203 26101 26101 1629 1629
26900 26900 26757 26757 1629 1629

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