albums_artists

8 rows where artist_id = 4507

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7101 7101 6802 6802 4507 4507
17602 17602 17307 17307 4507 4507
20177 20177 20000 20000 4507 4507
20178 20178 20001 20001 4507 4507
20179 20179 20002 20002 4507 4507
20180 20180 20003 20003 4507 4507
20181 20181 20004 20004 4507 4507
27612 27612 27421 27421 4507 4507

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