albums_artists

8 rows where artist_id = 1213

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1319 1319 1240 1240 1213 1213
3775 3775 3575 3575 1213 1213
5371 5371 5119 5119 1213 1213
5749 5749 5484 5484 1213 1213
8850 8850 8518 8518 1213 1213
10165 10165 9825 9825 1213 1213
25539 25539 25440 25440 1213 1213
27016 27016 26866 26866 1213 1213

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