albums_artists

5 rows where artist_id = 6155

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10946 10946 10605 10605 6155 6155
15568 15568 15226 15226 6155 6155
18163 18163 17879 17879 6155 6155
18681 18681 18433 18433 6155 6155
20151 20151 19974 19974 6155 6155

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