albums_artists

6 rows where artist_id = 7918

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15747 15747 15410 15410 7918 7918
15748 15748 15411 15411 7918 7918
15749 15749 15412 15412 7918 7918
15750 15750 15413 15413 7918 7918
24252 24252 24143 24143 7918 7918
24253 24253 24144 24144 7918 7918

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