albums_artists

8 rows where artist_id = 1675

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1896 1896 1789 1789 1675 1675
4825 4825 4605 4605 1675 1675
10232 10232 9893 9893 1675 1675
12361 12361 12025 12025 1675 1675
17333 17333 17031 17031 1675 1675
22115 22115 22018 22018 1675 1675
25080 25080 24975 24975 1675 1675
26093 26093 25989 25989 1675 1675

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