albums_artists

7 rows where artist_id = 1265

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1374 1374 1293 1293 1265 1265
14899 14899 14551 14551 1265 1265
16913 16913 16603 16603 1265 1265
20335 20335 20165 20165 1265 1265
22133 22133 22037 22037 1265 1265
23751 23751 23641 23641 1265 1265
25738 25738 25638 25638 1265 1265

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