home / pf

albums_artists

11 rows where artist_id = 722

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
751 751 713 713 722 722
4669 4669 4452 4452 722 722
6679 6679 6388 6388 722 722
7908 7908 7592 7592 722 722
9080 9080 8740 8740 722 722
9694 9694 9346 9346 722 722
12396 12396 12060 12060 722 722
13315 13315 12968 12968 722 722
14069 14069 13715 13715 722 722
14752 14752 14397 14397 722 722
15986 15986 15647 15647 722 722

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