albums_artists

5 rows where artist_id = 543

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
558 558 535 535 543 543
3873 3873 3668 3668 543 543
6917 6917 6618 6618 543 543
9122 9122 8779 8779 543 543
10293 10293 9952 9952 543 543

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