albums_artists

6 rows where artist_id = 5015

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8356 8356 8032 8032 5015 5015
8357 8357 8033 8033 5015 5015
8358 8358 8034 8034 5015 5015
8682 8682 8348 8348 5015 5015
11110 11110 10771 10771 5015 5015
25294 25294 25192 25192 5015 5015

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