albums_artists

7 rows where artist_id = 2312

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2813 2813 2648 2648 2312 2312
7421 7421 7120 7120 2312 2312
10114 10114 9773 9773 2312 2312
18581 18581 18329 18329 2312 2312
18868 18868 18625 18625 2312 2312
26085 26085 25981 25981 2312 2312
27029 27029 26879 26879 2312 2312

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