albums_artists

5 rows where artist_id = 3852

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5649 5649 5386 5386 3852 3852
14793 14793 14439 14439 3852 3852
17852 17852 17560 17560 3852 3852
22252 22252 22161 22161 3852 3852
25312 25312 25212 25212 3852 3852

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