albums_artists

8 rows where artist_id = 3289

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4497 4497 4280 4280 3289 3289
12072 12072 11731 11731 3289 3289
14566 14566 14212 14212 3289 3289
16853 16853 16544 16544 3289 3289
19068 19068 18843 18843 3289 3289
25055 25055 24950 24950 3289 3289
25915 25915 25817 25817 3289 3289
27615 27615 27424 27424 3289 3289

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