albums_artists

6 rows where artist_id = 5162

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8681 8681 8347 8347 5162 5162
12543 12543 12203 12203 5162 5162
13799 13799 13444 13444 5162 5162
15004 15004 14656 14656 5162 5162
16182 16182 15860 15860 5162 5162
19172 19172 18950 18950 5162 5162

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