albums_artists

6 rows where artist_id = 7825

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15428 15428 15086 15086 7825 7825
18953 18953 18718 18718 7825 7825
21642 21642 21529 21529 7825 7825
23149 23149 23048 23048 7825 7825
23150 23150 23049 23049 7825 7825
24531 24531 24412 24412 7825 7825

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