albums_artists

6 rows where artist_id = 4970

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8233 8233 7913 7913 4970 4970
11872 11872 11530 11530 4970 4970
12241 12241 11905 11905 4970 4970
13889 13889 13532 13532 4970 4970
15167 15167 14821 14821 4970 4970
26431 26431 26323 26323 4970 4970

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