albums_artists

11 rows where artist_id = 3344

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4584 4584 4368 4368 3344 3344
14058 14058 13704 13704 3344 3344
14517 14517 14161 14161 3344 3344
18030 18030 17740 17740 3344 3344
20455 20455 20290 20290 3344 3344
21200 21200 21074 21074 3344 3344
23447 23447 23342 23342 3344 3344
24624 24624 24502 24502 3344 3344
25754 25754 25655 25655 3344 3344
25943 25943 25844 25844 3344 3344
26456 26456 26347 26347 3344 3344

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