albums_artists

13 rows where artist_id = 3295

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4509 4509 4292 4292 3295 3295
4846 4846 4624 4624 3295 3295
7179 7179 6880 6880 3295 3295
8607 8607 8273 8273 3295 3295
9461 9461 9114 9114 3295 3295
11123 11123 10784 10784 3295 3295
12037 12037 11696 11696 3295 3295
13164 13164 12825 12825 3295 3295
15459 15459 15120 15120 3295 3295
18207 18207 17925 17925 3295 3295
19520 19520 19307 19307 3295 3295
21050 21050 20909 20909 3295 3295
23394 23394 23291 23291 3295 3295

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