home / pf

albums_artists

5 rows where artist_id = 8841

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18139 18139 17855 17855 8841 8841
18719 18719 18475 18475 8841 8841
18720 18720 18476 18476 8841 8841
18721 18721 18477 18477 8841 8841
23282 23282 23179 23179 8841 8841

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)
);
Powered by Datasette · Queries took 151.431ms