albums_artists

10 rows where artist_id = 147

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
152 152 147 147 147 147
7829 7829 7517 7517 147 147
8663 8663 8328 8328 147 147
14364 14364 14005 14005 147 147
17008 17008 16701 16701 147 147
18256 18256 17978 17978 147 147
19403 19403 19187 19187 147 147
20158 20158 19981 19981 147 147
22794 22794 22704 22704 147 147
23466 23466 23360 23360 147 147

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