albums_artists

8 rows where artist_id = 2200

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2650 2650 2491 2491 2200 2200
5728 5728 5465 5465 2200 2200
7965 7965 7650 7650 2200 2200
9436 9436 9089 9089 2200 2200
11339 11339 11003 11003 2200 2200
12058 12058 11717 11717 2200 2200
13117 13117 12779 12779 2200 2200
14891 14891 14543 14543 2200 2200

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