albums_artists

10 rows where artist_id = 1728

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1966 1966 1850 1850 1728 1728
1967 1967 1851 1851 1728 1728
1968 1968 1852 1852 1728 1728
1969 1969 1853 1853 1728 1728
5026 5026 4788 4788 1728 1728
5027 5027 4789 4789 1728 1728
5028 5028 4790 4790 1728 1728
5029 5029 4791 4791 1728 1728
5030 5030 4792 4792 1728 1728
27567 27567 27378 27378 1728 1728

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