albums_artists

8 rows where artist_id = 6987

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13028 13028 12688 12688 6987 6987
16404 16404 16090 16090 6987 6987
18278 18278 17999 17999 6987 6987
18279 18279 18000 18000 6987 6987
18280 18280 18001 18001 6987 6987
20424 20424 20258 20258 6987 6987
22129 22129 22033 22033 6987 6987
22371 22371 22280 22280 6987 6987

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