home / pf

albums_artists

5 rows where artist_id = 3632

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5211 5211 4966 4966 3632 3632
10008 10008 9662 9662 3632 3632
13382 13382 13032 13032 3632 3632
15003 15003 14655 14655 3632 3632
27399 27399 27226 27226 3632 3632

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