albums_artists

10 rows where artist_id = 4444

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6961 6961 6663 6663 4444 4444
11153 11153 10815 10815 4444 4444
16895 16895 16585 16585 4444 4444
19734 19734 19538 19538 4444 4444
22029 22029 21929 21929 4444 4444
22030 22030 21930 21930 4444 4444
24578 24578 24456 24456 4444 4444
24637 24637 24515 24515 4444 4444
25572 25572 25474 25474 4444 4444
26176 26176 26074 26074 4444 4444

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