albums_artists

7 rows where artist_id = 1985

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2326 2326 2182 2182 1985 1985
6170 6170 5891 5891 1985 1985
7871 7871 7556 7556 1985 1985
11196 11196 10858 10858 1985 1985
15818 15818 15476 15476 1985 1985
18701 18701 18456 18456 1985 1985
22107 22107 22010 22010 1985 1985

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