albums_artists

5 rows where artist_id = 1986

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2328 2328 2184 2184 1986 1986
5156 5156 4913 4913 1986 1986
8254 8254 7935 7935 1986 1986
11007 11007 10665 10665 1986 1986
27393 27393 27219 27219 1986 1986

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