albums_artists

8 rows where artist_id = 4544

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7199 7199 6901 6901 4544 4544
12829 12829 12486 12486 4544 4544
14030 14030 13676 13676 4544 4544
18912 18912 18671 18671 4544 4544
21028 21028 20886 20886 4544 4544
22474 22474 22378 22378 4544 4544
22759 22759 22669 22669 4544 4544
22760 22760 22670 22670 4544 4544

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