albums_artists

5 rows where artist_id = 2727

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3495 3495 3299 3299 2727 2727
3966 3966 3762 3762 2727 2727
6263 6263 5977 5977 2727 2727
17075 17075 16772 16772 2727 2727
26592 26592 26478 26478 2727 2727

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