albums_artists

12 rows where artist_id = 2898

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3801 3801 3599 3599 2898 2898
5086 5086 4843 4843 2898 2898
7794 7794 7482 7482 2898 2898
12939 12939 12595 12595 2898 2898
14301 14301 13943 13943 2898 2898
15844 15844 15501 15501 2898 2898
17441 17441 17147 17147 2898 2898
18528 18528 18267 18267 2898 2898
19870 19870 19678 19678 2898 2898
21245 21245 21120 21120 2898 2898
22236 22236 22146 22146 2898 2898
24245 24245 24136 24136 2898 2898

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