albums_artists

12 rows where artist_id = 8447

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
17145 17145 16849 16849 8447 8447
19407 19407 19191 19191 8447 8447
19576 19576 19364 19364 8447 8447
19639 19639 19435 19435 8447 8447
19640 19640 19436 19436 8447 8447
19641 19641 19437 19437 8447 8447
22351 22351 22261 22261 8447 8447
22840 22840 22745 22745 8447 8447
22841 22841 22746 22746 8447 8447
22842 22842 22747 22747 8447 8447
25564 25564 25465 25465 8447 8447
26146 26146 26043 26043 8447 8447

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