albums_artists

8 rows where artist_id = 2479

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3090 3090 2912 2912 2479 2479
3091 3091 2913 2913 2479 2479
3092 3092 2914 2914 2479 2479
3093 3093 2915 2915 2479 2479
3094 3094 2916 2916 2479 2479
4943 4943 4710 4710 2479 2479
21160 21160 21033 21033 2479 2479
22571 22571 22477 22477 2479 2479

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