albums_artists

6 rows where artist_id = 1377

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1508 1508 1423 1423 1377 1377
6907 6907 6608 6608 1377 1377
8139 8139 7820 7820 1377 1377
13502 13502 13151 13151 1377 1377
15345 15345 15003 15003 1377 1377
16982 16982 16674 16674 1377 1377

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