home / pf

albums_artists

5 rows where artist_id = 5615

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9731 9731 9385 9385 5615 5615
12135 12135 11796 11796 5615 5615
13507 13507 13156 13156 5615 5615
13915 13915 13557 13557 5615 5615
15822 15822 15480 15480 5615 5615

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