albums_artists

7 rows where artist_id = 325

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
332 332 317 317 325 325
2090 2090 1961 1961 325 325
3341 3341 3155 3155 325 325
3551 3551 3353 3353 325 325
4284 4284 4079 4079 325 325
4590 4590 4373 4373 325 325
4824 4824 4604 4604 325 325

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