albums_artists

6 rows where artist_id = 1973

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2306 2306 2163 2163 1973 1973
3600 3600 3405 3405 1973 1973
9732 9732 9386 9386 1973 1973
14467 14467 14110 14110 1973 1973
15998 15998 15661 15661 1973 1973
26644 26644 26526 26526 1973 1973

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