albums_artists

11 rows where artist_id = 213

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
218 218 210 210 213 213
5795 5795 5528 5528 213 213
7460 7460 7157 7157 213 213
9092 9092 8751 8751 213 213
15259 15259 14914 14914 213 213
17611 17611 17316 17316 213 213
19254 19254 19035 19035 213 213
21171 21171 21044 21044 213 213
21436 21436 21317 21317 213 213
21687 21687 21576 21576 213 213
22489 22489 22393 22393 213 213

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