home / pf

albums_artists

5 rows where artist_id = 8367

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
16931 16931 16623 16623 8367 8367
20284 20284 20110 20110 8367 8367
23427 23427 23323 23323 8367 8367
24593 24593 24471 24471 8367 8367
25403 25403 25307 25307 8367 8367

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