albums_artists

9 rows where artist_id = 3028

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4036 4036 3835 3835 3028 3028
4526 4526 4309 4309 3028 3028
13035 13035 12695 12695 3028 3028
13036 13036 12696 12696 3028 3028
13037 13037 12697 12697 3028 3028
13038 13038 12698 12698 3028 3028
25842 25842 25743 25743 3028 3028
26237 26237 26135 26135 3028 3028
26726 26726 26597 26597 3028 3028

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