albums_artists

10 rows where artist_id = 231

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
237 237 227 227 231 231
2293 2293 2150 2150 231 231
5450 5450 5193 5193 231 231
7404 7404 7104 7104 231 231
8778 8778 8447 8447 231 231
10964 10964 10623 10623 231 231
12002 12002 11661 11661 231 231
15024 15024 14677 14677 231 231
16393 16393 16080 16080 231 231
27458 27458 27283 27283 231 231

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