albums_artists

9 rows where artist_id = 4677

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7510 7510 7205 7205 4677 4677
23148 23148 23047 23047 4677 4677
23256 23256 23154 23154 4677 4677
23257 23257 23155 23155 4677 4677
24016 24016 23905 23905 4677 4677
24017 24017 23906 23906 4677 4677
24678 24678 24555 24555 4677 4677
25035 25035 24928 24928 4677 4677
25419 25419 25321 25321 4677 4677

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