albums_artists

7 rows where artist_id = 228

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
234 234 224 224 228 228
1812 1812 1712 1712 228 228
4210 4210 4008 4008 228 228
5245 5245 5000 5000 228 228
7468 7468 7164 7164 228 228
8119 8119 7801 7801 228 228
10934 10934 10593 10593 228 228

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