albums_artists

6 rows where artist_id = 1619

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1826 1826 1725 1725 1619 1619
6330 6330 6043 6043 1619 1619
8534 8534 8202 8202 1619 1619
10769 10769 10434 10434 1619 1619
12603 12603 12265 12265 1619 1619
13856 13856 13499 13499 1619 1619

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