albums_artists

6 rows where artist_id = 1766

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2022 2022 1901 1901 1766 1766
3127 3127 2949 2949 1766 1766
6216 6216 5936 5936 1766 1766
6217 6217 5937 5937 1766 1766
6218 6218 5938 5938 1766 1766
27142 27142 26983 26983 1766 1766

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