albums_artists

6 rows where artist_id = 3501

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4910 4910 4680 4680 3501 3501
5697 5697 5434 5434 3501 3501
9514 9514 9169 9169 3501 3501
12341 12341 12005 12005 3501 3501
14325 14325 13968 13968 3501 3501
26613 26613 26498 26498 3501 3501

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