home / pf

albums_artists

5 rows where artist_id = 5260

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8920 8920 8584 8584 5260 5260
12484 12484 12146 12146 5260 5260
13738 13738 13383 13383 5260 5260
18658 18658 18409 18409 5260 5260
19453 19453 19236 19236 5260 5260

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