albums_artists

8 rows where artist_id = 3357

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4610 4610 4392 4392 3357 3357
9046 9046 8706 8706 3357 3357
14348 14348 13989 13989 3357 3357
17607 17607 17312 17312 3357 3357
20015 20015 19830 19830 3357 3357
22160 22160 22066 22066 3357 3357
25625 25625 25527 25527 3357 3357
27513 27513 27331 27331 3357 3357

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