home / pf

albums_artists

6 rows where artist_id = 6370

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11435 11435 11096 11096 6370 6370
14911 14911 14565 14565 6370 6370
23556 23556 23452 23452 6370 6370
25514 25514 25414 25414 6370 6370
25757 25757 25658 25658 6370 6370
26231 26231 26129 26129 6370 6370

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