albums_artists

5 rows where artist_id = 475

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
487 487 465 465 475 475
3456 3456 3261 3261 475 475
4689 4689 4472 4472 475 475
7878 7878 7562 7562 475 475
13679 13679 13327 13327 475 475

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