albums_artists

8 rows where artist_id = 2990

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3964 3964 3760 3760 2990 2990
6384 6384 6094 6094 2990 2990
8177 8177 7859 7859 2990 2990
9383 9383 9035 9035 2990 2990
10611 10611 10274 10274 2990 2990
13254 13254 12910 12910 2990 2990
14401 14401 14044 14044 2990 2990
14887 14887 14539 14539 2990 2990

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