albums_artists

6 rows where artist_id = 1355

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1482 1482 1398 1398 1355 1355
4772 4772 4555 4555 1355 1355
4773 4773 4556 4556 1355 1355
4774 4774 4557 4557 1355 1355
4775 4775 4558 4558 1355 1355
21343 21343 21220 21220 1355 1355

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