albums_artists

7 rows where artist_id = 3681

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5310 5310 5061 5061 3681 3681
13730 13730 13376 13376 3681 3681
17932 17932 17640 17640 3681 3681
20920 20920 20771 20771 3681 3681
23657 23657 23550 23550 3681 3681
23658 23658 23551 23551 3681 3681
23659 23659 23552 23552 3681 3681

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