albums_artists

7 rows where artist_id = 4795

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7790 7790 7479 7479 4795 4795
11370 11370 11031 11031 4795 4795
14921 14921 14575 14575 4795 4795
15466 15466 15126 15126 4795 4795
18957 18957 18722 18722 4795 4795
21902 21902 21798 21798 4795 4795
22247 22247 22156 22156 4795 4795

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