albums_artists

6 rows where artist_id = 2715

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3479 3479 3283 3283 2715 2715
5242 5242 4996 4996 2715 2715
6058 6058 5785 5785 2715 2715
7811 7811 7499 7499 2715 2715
9116 9116 8773 8773 2715 2715
27011 27011 26861 26861 2715 2715

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