home / pf

albums_artists

7 rows where artist_id = 4762

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7722 7722 7415 7415 4762 4762
7723 7723 7416 7416 4762 4762
9509 9509 9163 9163 4762 4762
17998 17998 17708 17708 4762 4762
19564 19564 19352 19352 4762 4762
20916 20916 20767 20767 4762 4762
22856 22856 22762 22762 4762 4762

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