albums_artists

4 rows where artist_id = 5022

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8368 8368 8043 8043 5022 5022
15571 15571 15230 15230 5022 5022
18443 18443 18174 18174 5022 5022
21917 21917 21815 21815 5022 5022

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