albums_artists

11 rows where artist_id = 4129

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6252 6252 5967 5967 4129 4129
7148 7148 6848 6848 4129 4129
14106 14106 13751 13751 4129 4129
20471 20471 20306 20306 4129 4129
21236 21236 21111 21111 4129 4129
22321 22321 22231 22231 4129 4129
23955 23955 23841 23841 4129 4129
26019 26019 25920 25920 4129 4129
26236 26236 26134 26134 4129 4129
27104 27104 26947 26947 4129 4129
27542 27542 27356 27356 4129 4129

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