albums_artists

7 rows where artist_id = 2544

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3184 3184 3005 3005 2544 2544
5129 5129 4886 4886 2544 2544
6674 6674 6383 6383 2544 2544
8143 8143 7824 7824 2544 2544
9689 9689 9341 9341 2544 2544
12227 12227 11891 11891 2544 2544
27611 27611 27420 27420 2544 2544

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