albums_artists

10 rows where artist_id = 2598

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3276 3276 3093 3093 2598 2598
10249 10249 9910 9910 2598 2598
15067 15067 14722 14722 2598 2598
15192 15192 14847 14847 2598 2598
15756 15756 15419 15419 2598 2598
18948 18948 18712 18712 2598 2598
20258 20258 20083 20083 2598 2598
20259 20259 20084 20084 2598 2598
21685 21685 21574 21574 2598 2598
21786 21786 21680 21680 2598 2598

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