albums_artists

9 rows where artist_id = 1375

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1506 1506 1421 1421 1375 1375
2323 2323 2179 2179 1375 1375
3228 3228 3045 3045 1375 1375
4645 4645 4427 4427 1375 1375
8197 8197 7877 7877 1375 1375
10789 10789 10452 10452 1375 1375
12171 12171 11833 11833 1375 1375
14881 14881 14534 14534 1375 1375
26742 26742 26612 26612 1375 1375

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