home / pf

albums_artists

5 rows where artist_id = 8084

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
16164 16164 15841 15841 8084 8084
16165 16165 15842 15842 8084 8084
16166 16166 15843 15843 8084 8084
16167 16167 15844 15844 8084 8084
16168 16168 15845 15845 8084 8084

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