home / pf

albums_artists

5 rows where artist_id = 7832

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15452 15452 15110 15110 7832 7832
18298 18298 18021 18021 7832 7832
20201 20201 20024 20024 7832 7832
21708 21708 21597 21597 7832 7832
27497 27497 27318 27318 7832 7832

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