home / pf

albums_artists

19 rows where artist_id = 857

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
896 896 848 848 857 857
3390 3390 3199 3199 857 857
6306 6306 6020 6020 857 857
9184 9184 8841 8841 857 857
11296 11296 10960 10960 857 857
14415 14415 14057 14057 857 857
14867 14867 14519 14519 857 857
15102 15102 14758 14758 857 857
15761 15761 15424 15424 857 857
15762 15762 15425 15425 857 857
15763 15763 15426 15426 857 857
16560 16560 16248 16248 857 857
18273 18273 17994 17994 857 857
19875 19875 19685 19685 857 857
20772 20772 20614 20614 857 857
22092 22092 21995 21995 857 857
23105 23105 23004 23004 857 857
24566 24566 24446 24446 857 857
25976 25976 25877 25877 857 857

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