home / pf

albums_artists

5 rows where artist_id = 4915

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8093 8093 7777 7777 4915 4915
8094 8094 7778 7778 4915 4915
17782 17782 17490 17490 4915 4915
22097 22097 22000 22000 4915 4915
24369 24369 24256 24256 4915 4915

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