home / pf

albums_artists

5 rows where artist_id = 5451

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9368 9368 9020 9020 5451 5451
16135 16135 15808 15808 5451 5451
17655 17655 17360 17360 5451 5451
18750 18750 18508 18508 5451 5451
19071 19071 18846 18846 5451 5451

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