albums_artists

7 rows where artist_id = 1691

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1917 1917 1806 1806 1691 1691
4092 4092 3893 3893 1691 1691
8491 8491 8160 8160 1691 1691
8821 8821 8490 8490 1691 1691
9673 9673 9326 9326 1691 1691
10377 10377 10036 10036 1691 1691
27158 27158 26998 26998 1691 1691

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