albums_artists

8 rows where artist_id = 1712

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1945 1945 1833 1833 1712 1712
4483 4483 4267 4267 1712 1712
8485 8485 8156 8156 1712 1712
15188 15188 14844 14844 1712 1712
18035 18035 17745 17745 1712 1712
23098 23098 22998 22998 1712 1712
26646 26646 26527 26527 1712 1712
27494 27494 27317 27317 1712 1712

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