home / pf

albums_artists

6 rows where artist_id = 5276

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8961 8961 8621 8621 5276 5276
21435 21435 21316 21316 5276 5276
23413 23413 23309 23309 5276 5276
24609 24609 24487 24487 5276 5276
25189 25189 25084 25084 5276 5276
26170 26170 26068 26068 5276 5276

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.486ms