albums_artists

10 rows where artist_id = 2858

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3730 3730 3531 3531 2858 2858
12905 12905 12563 12563 2858 2858
12906 12906 12564 12564 2858 2858
12907 12907 12565 12565 2858 2858
12908 12908 12566 12566 2858 2858
12909 12909 12567 12567 2858 2858
12910 12910 12568 12568 2858 2858
12911 12911 12569 12569 2858 2858
12912 12912 12570 12570 2858 2858
12913 12913 12571 12571 2858 2858

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