albums_artists

8 rows where artist_id = 2154

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2582 2582 2430 2430 2154 2154
3563 3563 3366 3366 2154 2154
6411 6411 6119 6119 2154 2154
7440 7440 7141 7141 2154 2154
9424 9424 9076 9076 2154 2154
15648 15648 15310 15310 2154 2154
16237 16237 15916 15916 2154 2154
27244 27244 27083 27083 2154 2154

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