albums_artists

11 rows where artist_id = 2253

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2730 2730 2568 2568 2253 2253
4917 4917 4687 4687 2253 2253
6018 6018 5747 5747 2253 2253
6397 6397 6107 6107 2253 2253
6398 6398 6108 6108 2253 2253
8135 8135 7817 7817 2253 2253
9256 9256 8910 8910 2253 2253
9257 9257 8911 8911 2253 2253
9258 9258 8912 8912 2253 2253
13807 13807 13451 13451 2253 2253
26509 26509 26398 26398 2253 2253

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