albums_artists

6 rows where artist_id = 2279

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2766 2766 2601 2601 2279 2279
3202 3202 3021 3021 2279 2279
5460 5460 5203 5203 2279 2279
6367 6367 6078 6078 2279 2279
10050 10050 9704 9704 2279 2279
16572 16572 16262 16262 2279 2279

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