albums_artists

12 rows where artist_id = 1031

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1090 1090 1033 1033 1031 1031
1714 1714 1616 1616 1031 1031
5005 5005 4767 4767 1031 1031
7085 7085 6786 6786 1031 1031
9432 9432 9085 9085 1031 1031
10678 10678 10343 10343 1031 1031
13584 13584 13233 13233 1031 1031
14378 14378 14020 14020 1031 1031
16036 16036 15703 15703 1031 1031
17545 17545 17251 17251 1031 1031
19508 19508 19295 19295 1031 1031
26474 26474 26364 26364 1031 1031

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