albums_artists

10 rows where artist_id = 3162

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4281 4281 4077 4077 3162 3162
5090 5090 4847 4847 3162 3162
8055 8055 7742 7742 3162 3162
9230 9230 8886 8886 3162 3162
9949 9949 9604 9604 3162 3162
10319 10319 9976 9976 3162 3162
24126 24126 24016 24016 3162 3162
25231 25231 25126 25126 3162 3162
25508 25508 25407 25407 3162 3162
27015 27015 26865 26865 3162 3162

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