albums_artists

5 rows where artist_id = 1687

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1911 1911 1803 1803 1687 1687
4361 4361 4153 4153 1687 1687
7034 7034 6734 6734 1687 1687
9196 9196 8853 8853 1687 1687
26730 26730 26601 26601 1687 1687

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