albums_artists

10 rows where artist_id = 1193

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1298 1298 1219 1219 1193 1193
5016 5016 4777 4777 1193 1193
8246 8246 7926 7926 1193 1193
11101 11101 10763 10763 1193 1193
13170 13170 12830 12830 1193 1193
14342 14342 13984 13984 1193 1193
17112 17112 16813 16813 1193 1193
19524 19524 19311 19311 1193 1193
21712 21712 21601 21601 1193 1193
22169 22169 22075 22075 1193 1193

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