albums_artists

10 rows where artist_id = 3524

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4970 4970 4735 4735 3524 3524
7309 7309 7013 7013 3524 3524
12864 12864 12521 12521 3524 3524
13668 13668 13317 13317 3524 3524
15351 15351 15009 15009 3524 3524
17436 17436 17142 17142 3524 3524
19212 19212 18991 18991 3524 3524
20497 20497 20333 20333 3524 3524
22671 22671 22578 22578 3524 3524
23454 23454 23349 23349 3524 3524

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