home / pf

albums_artists

6 rows where artist_id = 6721

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12278 12278 11941 11941 6721 6721
12762 12762 12420 12420 6721 6721
13130 13130 12791 12791 6721 6721
13617 13617 13267 13267 6721 6721
14136 14136 13780 13780 6721 6721
15108 15108 14763 14763 6721 6721

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