albums_artists

5 rows where artist_id = 8143

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
16301 16301 15986 15986 8143 8143
16302 16302 15987 15987 8143 8143
16303 16303 15988 15988 8143 8143
16304 16304 15989 15989 8143 8143
26171 26171 26069 26069 8143 8143

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