albums_artists

5 rows where artist_id = 9047

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18747 18747 18504 18504 9047 9047
20801 20801 20644 20644 9047 9047
23928 23928 23815 23815 9047 9047
24265 24265 24156 24156 9047 9047
25830 25830 25731 25731 9047 9047

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