albums_artists

8 rows where artist_id = 2764

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3566 3566 3370 3370 2764 2764
4893 4893 4666 4666 2764 2764
5828 5828 5562 5562 2764 2764
7346 7346 7049 7049 2764 2764
7347 7347 7050 7050 2764 2764
7866 7866 7551 7551 2764 2764
8716 8716 8383 8383 2764 2764
8717 8717 8384 8384 2764 2764

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