albums_artists

4 rows where artist_id = 7714

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15105 15105 14761 14761 7714 7714
20568 20568 20407 20407 7714 7714
21670 21670 21559 21559 7714 7714
22396 22396 22303 22303 7714 7714

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