albums_artists

7 rows where artist_id = 2055

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2422 2422 2271 2271 2055 2055
6645 6645 6354 6354 2055 2055
13657 13657 13306 13306 2055 2055
16345 16345 16030 16030 2055 2055
19173 19173 18951 18951 2055 2055
22526 22526 22432 22432 2055 2055
23862 23862 23750 23750 2055 2055

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