albums_artists

8 rows where artist_id = 1387

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1518 1518 1432 1432 1387 1387
6402 6402 6110 6110 1387 1387
10546 10546 10207 10207 1387 1387
14025 14025 13671 13671 1387 1387
16836 16836 16527 16527 1387 1387
16837 16837 16528 16528 1387 1387
18563 18563 18306 18306 1387 1387
20387 20387 20220 20220 1387 1387

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