albums_artists

12 rows where artist_id = 379

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
387 387 368 368 379 379
4607 4607 4389 4389 379 379
7850 7850 7535 7535 379 379
8817 8817 8486 8486 379 379
11424 11424 11085 11085 379 379
13859 13859 13502 13502 379 379
14544 14544 14188 14188 379 379
16664 16664 16354 16354 379 379
18783 18783 18541 18541 379 379
22080 22080 21984 21984 379 379
23872 23872 23760 23760 379 379
27060 27060 26906 26906 379 379

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