home / pf

albums_artists

6 rows where artist_id = 4258

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6581 6581 6293 6293 4258 4258
16824 16824 16515 16515 4258 4258
20018 20018 19834 19834 4258 4258
25582 25582 25484 25484 4258 4258
26101 26101 25997 25997 4258 4258
27135 27135 26976 26976 4258 4258

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