home / pf

albums_artists

13 rows where artist_id = 235

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
241 241 231 231 235 235
742 742 707 707 235 235
4060 4060 3861 3861 235 235
4758 4758 4543 4543 235 235
7549 7549 7243 7243 235 235
9797 9797 9450 9450 235 235
10694 10694 10360 10360 235 235
12647 12647 12308 12308 235 235
12850 12850 12507 12507 235 235
13532 13532 13180 13180 235 235
22681 22681 22588 22588 235 235
23907 23907 23793 23793 235 235
23952 23952 23838 23838 235 235

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