albums_artists

5 rows where artist_id = 3940

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5842 5842 5575 5575 3940 3940
15641 15641 15303 15303 3940 3940
17310 17310 17008 17008 3940 3940
18554 18554 18296 18296 3940 3940
24546 24546 24426 24426 3940 3940

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