albums_artists

7 rows where artist_id = 374

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
382 382 363 363 374 374
7984 7984 7670 7670 374 374
11306 11306 10969 10969 374 374
13847 13847 13490 13490 374 374
16319 16319 16005 16005 374 374
18146 18146 17862 17862 374 374
20385 20385 20218 20218 374 374

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