albums_artists

13 rows where artist_id = 1407

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1547 1547 1459 1459 1407 1407
3819 3819 3617 3617 1407 1407
7736 7736 7429 7429 1407 1407
12211 12211 11875 11875 1407 1407
16287 16287 15971 15971 1407 1407
18853 18853 18610 18610 1407 1407
21286 21286 21161 21161 1407 1407
21302 21302 21178 21178 1407 1407
22477 22477 22381 22381 1407 1407
23093 23093 22993 22993 1407 1407
23951 23951 23837 23837 1407 1407
24552 24552 24432 24432 1407 1407
27171 27171 27011 27011 1407 1407

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