home / pf

albums_artists

11 rows where artist_id = 2261

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2740 2740 2577 2577 2261 2261
20347 20347 20179 20179 2261 2261
21533 21533 21413 21413 2261 2261
21617 21617 21503 21503 2261 2261
24186 24186 24076 24076 2261 2261
24414 24414 24302 24302 2261 2261
25600 25600 25502 25502 2261 2261
25765 25765 25666 25666 2261 2261
25833 25833 25734 25734 2261 2261
25975 25975 25876 25876 2261 2261
26102 26102 25998 25998 2261 2261

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