home / pf

albums_artists

5 rows where artist_id = 2063

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2432 2432 2281 2281 2063 2063
7088 7088 6789 6789 2063 2063
7760 7760 7452 7452 2063 2063
10438 10438 10096 10096 2063 2063
13513 13513 13162 13162 2063 2063

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