albums_artists

9 rows where artist_id = 1276

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1386 1386 1305 1305 1276 1276
4778 4778 4561 4561 1276 1276
5346 5346 5096 5096 1276 1276
6622 6622 6332 6332 1276 1276
7588 7588 7281 7281 1276 1276
9378 9378 9030 9030 1276 1276
12633 12633 12295 12295 1276 1276
13211 13211 12869 12869 1276 1276
13905 13905 13546 13546 1276 1276

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