home / pf

albums_artists

5 rows where artist_id = 9317

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
19488 19488 19273 19273 9317 9317
23926 23926 23811 23811 9317 9317
25798 25798 25699 25699 9317 9317
26268 26268 26166 26166 9317 9317
26369 26369 26263 26263 9317 9317

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