albums_artists

5 rows where artist_id = 1013

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1071 1071 1015 1015 1013 1013
3885 3885 3680 3680 1013 1013
15759 15759 15422 15422 1013 1013
18632 18632 18382 18382 1013 1013
21275 21275 21151 21151 1013 1013

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