albums_artists

9 rows where artist_id = 162

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
167 167 161 161 162 162
10356 10356 10015 10015 162 162
14456 14456 14099 14099 162 162
17989 17989 17698 17698 162 162
19675 19675 19475 19475 162 162
21650 21650 21537 21537 162 162
23253 23253 23151 23151 162 162
25421 25421 25323 25323 162 162
26256 26256 26154 26154 162 162

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