home / pf

albums_artists

5 rows where artist_id = 5834

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10238 10238 9899 9899 5834 5834
12403 12403 12066 12066 5834 5834
14271 14271 13915 13915 5834 5834
14819 14819 14466 14466 5834 5834
26781 26781 26648 26648 5834 5834

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