albums_artists

14 rows where artist_id = 238

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
244 244 234 234 238 238
3825 3825 3624 3624 238 238
7693 7693 7387 7387 238 238
10813 10813 10475 10475 238 238
10814 10814 10476 10476 238 238
10815 10815 10477 10477 238 238
10816 10816 10478 10478 238 238
10817 10817 10479 10479 238 238
10818 10818 10480 10480 238 238
11211 11211 10873 10873 238 238
11574 11574 11236 11236 238 238
20925 20925 20776 20776 238 238
24740 24740 24621 24621 238 238
25791 25791 25692 25692 238 238

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