albums_artists

15 rows where artist_id = 114

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
119 119 116 116 114 114
584 584 560 560 114 114
1479 1479 1395 1395 114 114
3049 3049 2874 2874 114 114
3970 3970 3765 3765 114 114
5369 5369 5117 5117 114 114
7096 7096 6797 6797 114 114
8328 8328 8009 8009 114 114
9088 9088 8748 8748 114 114
9872 9872 9526 9526 114 114
11518 11518 11181 11181 114 114
13845 13845 13488 13488 114 114
15558 15558 15216 15216 114 114
16704 16704 16394 16394 114 114
27209 27209 27047 27047 114 114

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