albums_artists

5 rows where artist_id = 10044

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
21740 21740 21632 21632 10044 10044
23517 23517 23412 23412 10044 10044
25818 25818 25719 25719 10044 10044
26196 26196 26094 26094 10044 10044
26392 26392 26286 26286 10044 10044

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