albums_artists

7 rows where artist_id = 3735

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5420 5420 5167 5167 3735 3735
10744 10744 10410 10410 3735 3735
15242 15242 14897 14897 3735 3735
16362 16362 16047 16047 3735 3735
19049 19049 18821 18821 3735 3735
23170 23170 23069 23069 3735 3735
27545 27545 27359 27359 3735 3735

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