albums_artists

6 rows where artist_id = 3928

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5806 5806 5539 5539 3928 3928
9295 9295 8949 8949 3928 3928
11456 11456 11119 11119 3928 3928
17902 17902 17607 17607 3928 3928
19968 19968 19780 19780 3928 3928
26920 26920 26776 26776 3928 3928

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