albums_artists

10 rows where artist_id = 655

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
677 677 649 649 655 655
1538 1538 1452 1452 655 655
2272 2272 2130 2130 655 655
2695 2695 2534 2534 655 655
2756 2756 2593 2593 655 655
3307 3307 3123 3123 655 655
11361 11361 11023 11023 655 655
12209 12209 11873 11873 655 655
13349 13349 12999 12999 655 655
27473 27473 27297 27297 655 655

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