albums_artists

12 rows where artist_id = 2207

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2661 2661 2501 2501 2207 2207
11855 11855 11514 11514 2207 2207
11856 11856 11515 11515 2207 2207
14847 14847 14498 14498 2207 2207
16850 16850 16541 16541 2207 2207
19050 19050 18822 18822 2207 2207
21342 21342 21219 21219 2207 2207
22634 22634 22543 22543 2207 2207
23293 23293 23189 23189 2207 2207
25024 25024 24917 24917 2207 2207
25687 25687 25587 25587 2207 2207
25986 25986 25887 25887 2207 2207

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