albums_artists

6 rows where artist_id = 767

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
797 797 757 757 767 767
2989 2989 2817 2817 767 767
4858 4858 4632 4632 767 767
6211 6211 5931 5931 767 767
10307 10307 9964 9964 767 767
27635 27635 27443 27443 767 767

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