albums_artists

6 rows where artist_id = 6924

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12814 12814 12472 12472 6924 6924
14385 14385 14027 14027 6924 6924
16463 16463 16150 16150 6924 6924
19614 19614 19408 19408 6924 6924
23157 23157 23056 23056 6924 6924
24461 24461 24349 24349 6924 6924

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