albums_artists

5 rows where artist_id = 6746

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12324 12324 11987 11987 6746 6746
18388 18388 18117 18117 6746 6746
22802 22802 22712 22712 6746 6746
24389 24389 24276 24276 6746 6746
25306 25306 25207 25207 6746 6746

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