albums_artists

10 rows where artist_id = 1608

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1808 1808 1708 1708 1608 1608
7174 7174 6875 6875 1608 1608
10030 10030 9686 9686 1608 1608
11389 11389 11050 11050 1608 1608
13835 13835 13477 13477 1608 1608
15346 15346 15004 15004 1608 1608
16041 16041 15708 15708 1608 1608
17426 17426 17132 17132 1608 1608
18383 18383 18111 18111 1608 1608
19060 19060 18833 18833 1608 1608

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