albums_artists

5 rows where artist_id = 4949

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8186 8186 7866 7866 4949 4949
11762 11762 11421 11421 4949 4949
15411 15411 15068 15068 4949 4949
22682 22682 22589 22589 4949 4949
24652 24652 24529 24529 4949 4949

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