albums_artists

9 rows where artist_id = 8892

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18301 18301 18024 18024 8892 8892
19628 19628 19423 19423 8892 8892
21859 21859 21755 21755 8892 8892
23260 23260 23158 23158 8892 8892
26365 26365 26259 26259 8892 8892
26367 26367 26261 26261 8892 8892
27553 27553 27367 27367 8892 8892
27554 27554 27368 27368 8892 8892
27555 27555 27369 27369 8892 8892

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