albums_artists

5 rows where artist_id = 3182

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4310 4310 4106 4106 3182 3182
7338 7338 7041 7041 3182 3182
10229 10229 9890 9890 3182 3182
12391 12391 12055 12055 3182 3182
13003 13003 12661 12661 3182 3182

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