albums_artists

13 rows where artist_id = 3218

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4372 4372 4163 4163 3218 3218
9345 9345 8996 8996 3218 3218
13422 13422 13072 13072 3218 3218
14596 14596 14242 14242 3218 3218
15547 15547 15206 15206 3218 3218
17700 17700 17405 17405 3218 3218
19119 19119 18895 18895 3218 3218
22069 22069 21972 21972 3218 3218
23589 23589 23486 23486 3218 3218
25278 25278 25175 25175 3218 3218
25853 25853 25755 25755 3218 3218
26301 26301 26199 26199 3218 3218
26325 26325 26220 26220 3218 3218

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