albums_artists

4 rows where artist_id = 6265

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11174 11174 10835 10835 6265 6265
13568 13568 13216 13216 6265 6265
14434 14434 14078 14078 6265 6265
15716 15716 15379 15379 6265 6265

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