home / pf

albums_artists

6 rows where artist_id = 6258

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11154 11154 10816 10816 6258 6258
14570 14570 14216 14216 6258 6258
15629 15629 15291 15291 6258 6258
17059 17059 16756 16756 6258 6258
17980 17980 17689 17689 6258 6258
17981 17981 17690 17690 6258 6258

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