home / pf

albums_artists

10 rows where artist_id = 1658

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1876 1876 1770 1770 1658 1658
2943 2943 2773 2773 1658 1658
4211 4211 4009 4009 1658 1658
10254 10254 9915 9915 1658 1658
12745 12745 12406 12406 1658 1658
15252 15252 14907 14907 1658 1658
15692 15692 15355 15355 1658 1658
16609 16609 16298 16298 1658 1658
17717 17717 17421 17421 1658 1658
19713 19713 19516 19516 1658 1658

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