albums_artists

8 rows where artist_id = 5006

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8319 8319 7998 7998 5006 5006
8320 8320 7999 7999 5006 5006
8321 8321 8000 8000 5006 5006
8322 8322 8001 8001 5006 5006
8323 8323 8002 8002 5006 5006
8378 8378 8054 8054 5006 5006
25643 25643 25545 25545 5006 5006
26939 26939 26794 26794 5006 5006

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