albums_artists

5 rows where artist_id = 5735

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9967 9967 9622 9622 5735 5735
20182 20182 20005 20005 5735 5735
23583 23583 23480 23480 5735 5735
23873 23873 23761 23761 5735 5735
25573 25573 25475 25475 5735 5735

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