albums_artists

5 rows where artist_id = 1005

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1061 1061 1004 1004 1005 1005
5198 5198 4954 4954 1005 1005
8114 8114 7797 7797 1005 1005
10104 10104 9761 9761 1005 1005
27139 27139 26980 26980 1005 1005

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