albums_artists

6 rows where artist_id = 2201

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2652 2652 2493 2493 2201 2201
3382 3382 3191 3191 2201 2201
9852 9852 9504 9504 2201 2201
12854 12854 12511 12511 2201 2201
17084 17084 16782 16782 2201 2201
19290 19290 19072 19072 2201 2201

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