albums_artists

6 rows where artist_id = 8868

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18240 18240 17962 17962 8868 8868
18300 18300 18023 18023 8868 8868
20507 20507 20343 20343 8868 8868
20927 20927 20778 20778 8868 8868
22144 22144 22048 22048 8868 8868
22145 22145 22049 22049 8868 8868

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