albums_artists

5 rows where artist_id = 2042

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2405 2405 2255 2255 2042 2042
6848 6848 6549 6549 2042 2042
10236 10236 9897 9897 2042 2042
11992 11992 11651 11651 2042 2042
15751 15751 15414 15414 2042 2042

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