albums_artists

5 rows where artist_id = 982

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1036 1036 979 979 982 982
3734 3734 3535 3535 982 982
4278 4278 4074 4074 982 982
6794 6794 6496 6496 982 982
8185 8185 7865 7865 982 982

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