albums_artists

9 rows where artist_id = 480

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
492 492 470 470 480 480
2369 2369 2221 2221 480 480
4221 4221 4019 4019 480 480
5386 5386 5134 5134 480 480
7916 7916 7600 7600 480 480
10595 10595 10257 10257 480 480
11606 11606 11269 11269 480 480
12429 12429 12090 12090 480 480
13342 13342 12992 12992 480 480

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