albums_artists

8 rows where artist_id = 2441

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3043 3043 2868 2868 2441 2441
3632 3632 3436 3436 2441 2441
6701 6701 6410 6410 2441 2441
8017 8017 7704 7704 2441 2441
11222 11222 10883 10883 2441 2441
13118 13118 12780 12780 2441 2441
14481 14481 14125 14125 2441 2441
14591 14591 14237 14237 2441 2441

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