albums_artists

5 rows where artist_id = 1751

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2002 2002 1885 1885 1751 1751
2919 2919 2750 2750 1751 1751
5137 5137 4894 4894 1751 1751
6205 6205 5925 5925 1751 1751
27192 27192 27030 27030 1751 1751

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