albums_artists

6 rows where artist_id = 4295

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6659 6659 6368 6368 4295 4295
9276 9276 8929 8929 4295 4295
10537 10537 10198 10198 4295 4295
10578 10578 10240 10240 4295 4295
10579 10579 10241 10241 4295 4295
10580 10580 10242 10242 4295 4295

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