home / pf

albums_artists

11 rows where artist_id = 430

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
441 441 421 421 430 430
3409 3409 3217 3217 430 430
5132 5132 4889 4889 430 430
5676 5676 5412 5412 430 430
6072 6072 5797 5797 430 430
11365 11365 11026 11026 430 430
15542 15542 15201 15201 430 430
16851 16851 16542 16542 430 430
21000 21000 20855 20855 430 430
22282 22282 22191 22191 430 430
24948 24948 24839 24839 430 430

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