albums_artists

5 rows where artist_id = 2221

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2689 2689 2528 2528 2221 2221
13673 13673 13322 13322 2221 2221
18214 18214 17934 17934 2221 2221
21935 21935 21834 21834 2221 2221
23979 23979 23866 23866 2221 2221

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