albums_artists

12 rows where artist_id = 3543

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5008 5008 4770 4770 3543 3543
6983 6983 6684 6684 3543 3543
8375 8375 8050 8050 3543 3543
8951 8951 8614 8614 3543 3543
12413 12413 12076 12076 3543 3543
16344 16344 16029 16029 3543 3543
16695 16695 16385 16385 3543 3543
16696 16696 16386 16386 3543 3543
16804 16804 16495 16495 3543 3543
19459 19459 19242 19242 3543 3543
20137 20137 19960 19960 3543 3543
20809 20809 20652 20652 3543 3543

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