albums_artists

7 rows where artist_id = 413

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
422 422 403 403 413 413
4472 4472 4256 4256 413 413
14463 14463 14106 14106 413 413
16823 16823 16515 16515 413 413
22890 22890 22796 22796 413 413
23193 23193 23090 23090 413 413
23622 23622 23519 23519 413 413

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