albums_artists

9 rows where artist_id = 1414

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1556 1556 1467 1467 1414 1414
1899 1899 1791 1791 1414 1414
4212 4212 4010 4010 1414 1414
8191 8191 7871 7871 1414 1414
9193 9193 8851 8851 1414 1414
11673 11673 11336 11336 1414 1414
15075 15075 14730 14730 1414 1414
15299 15299 14955 14955 1414 1414
16181 16181 15859 15859 1414 1414

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