albums_artists

8 rows where artist_id = 3156

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4261 4261 4058 4058 3156 3156
6928 6928 6629 6629 3156 3156
9275 9275 8928 8928 3156 3156
10914 10914 10573 10573 3156 3156
12634 12634 12296 12296 3156 3156
13369 13369 13018 13018 3156 3156
26450 26450 26341 26341 3156 3156
26789 26789 26655 26655 3156 3156

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