home / pf

albums_artists

9 rows where artist_id = 5995

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10606 10606 10269 10269 5995 5995
12118 12118 11779 11779 5995 5995
14939 14939 14590 14590 5995 5995
15944 15944 15607 15607 5995 5995
19063 19063 18837 18837 5995 5995
19797 19797 19602 19602 5995 5995
19798 19798 19603 19603 5995 5995
20797 20797 20640 20640 5995 5995
22168 22168 22074 22074 5995 5995

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 67.117ms