albums_artists

9 rows where artist_id = 5713

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9925 9925 9579 9579 5713 5713
10507 10507 10168 10168 5713 5713
13323 13323 12976 12976 5713 5713
15350 15350 15008 15008 5713 5713
16813 16813 16505 16505 5713 5713
17970 17970 17678 17678 5713 5713
19118 19118 18894 18894 5713 5713
19919 19919 19732 19732 5713 5713
20714 20714 20554 20554 5713 5713

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