home / pf

albums_artists

5 rows where artist_id = 8350

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
16881 16881 16571 16571 8350 8350
17066 17066 16763 16763 8350 8350
20691 20691 20530 20530 8350 8350
23591 23591 23488 23488 8350 8350
24822 24822 24705 24705 8350 8350

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