home / pf

albums_artists

8 rows where artist_id = 4736

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7657 7657 7351 7351 4736 4736
10329 10329 9986 9986 4736 4736
10845 10845 10508 10508 4736 4736
10846 10846 10509 10509 4736 4736
12184 12184 11847 11847 4736 4736
14113 14113 13758 13758 4736 4736
14963 14963 14613 14613 4736 4736
26656 26656 26536 26536 4736 4736

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