home / pf

albums_artists

7 rows where artist_id = 2860

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3732 3732 3533 3533 2860 2860
9762 9762 9416 9416 2860 2860
12763 12763 12421 12421 2860 2860
16340 16340 16025 16025 2860 2860
21149 21149 21021 21021 2860 2860
24261 24261 24152 24152 2860 2860
25793 25793 25694 25694 2860 2860

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