albums_artists

5 rows where artist_id = 1648

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1866 1866 1761 1761 1648 1648
3197 3197 3017 3017 1648 1648
6477 6477 6185 6185 1648 1648
10063 10063 9717 9717 1648 1648
15736 15736 15399 15399 1648 1648

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