albums_artists

12 rows where artist_id = 3215

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4369 4369 4161 4161 3215 3215
6238 6238 5956 5956 3215 3215
7817 7817 7505 7505 3215 3215
8457 8457 8129 8129 3215 3215
11136 11136 10798 10798 3215 3215
11983 11983 11641 11641 3215 3215
14618 14618 14263 14263 3215 3215
16221 16221 15900 15900 3215 3215
16712 16712 16403 16403 3215 3215
17039 17039 16737 16737 3215 3215
20623 20623 20459 20459 3215 3215
22269 22269 22178 22178 3215 3215

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