albums_artists

12 rows where artist_id = 6533

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11824 11824 11483 11483 6533 6533
12458 12458 12120 12120 6533 6533
13950 13950 13593 13593 6533 6533
15251 15251 14906 14906 6533 6533
15790 15790 15451 15451 6533 6533
19428 19428 19212 19212 6533 6533
19712 19712 19515 19515 6533 6533
20389 20389 20222 20222 6533 6533
21421 21421 21299 21299 6533 6533
24961 24961 24852 24852 6533 6533
25166 25166 25060 25060 6533 6533
25689 25689 25589 25589 6533 6533

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