albums_artists

5 rows where artist_id = 4831

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7887 7887 7570 7570 4831 4831
13648 13648 13297 13297 4831 4831
13839 13839 13481 13481 4831 4831
15166 15166 14820 14820 4831 4831
15929 15929 15590 15590 4831 4831

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