albums_artists

6 rows where artist_id = 7939

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15812 15812 15470 15470 7939 7939
16831 16831 16522 16522 7939 7939
19283 19283 19064 19064 7939 7939
22399 22399 22305 22305 7939 7939
23248 23248 23146 23146 7939 7939
26068 26068 25969 25969 7939 7939

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