albums_artists

8 rows where artist_id = 5523

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9516 9516 9171 9171 5523 5523
16923 16923 16615 16615 5523 5523
20266 20266 20091 20091 5523 5523
21384 21384 21262 21262 5523 5523
22319 22319 22229 22229 5523 5523
24920 24920 24811 24811 5523 5523
25517 25517 25417 25417 5523 5523
26022 26022 25923 25923 5523 5523

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