albums_artists

5 rows where artist_id = 498

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
511 511 490 490 498 498
3332 3332 3147 3147 498 498
4880 4880 4654 4654 498 498
6270 6270 5984 5984 498 498
27287 27287 27121 27121 498 498

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