home / pf

reviews_albums

9 rows where review_id = 1657

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
1683 1683 Get on Board the Soul Train: The Sound of Philadelphia International Records Vol. 1 1657 1683 1683
1684 1684 Get on Board the Soul Train: The Sound of Philadelphia International Records Vol. 1 1657 1684 1684
1685 1685 Get on Board the Soul Train: The Sound of Philadelphia International Records Vol. 1 1657 1685 1685
1686 1686 Get on Board the Soul Train: The Sound of Philadelphia International Records Vol. 1 1657 1686 1686
1687 1687 Get on Board the Soul Train: The Sound of Philadelphia International Records Vol. 1 1657 1687 1687
1688 1688 Get on Board the Soul Train: The Sound of Philadelphia International Records Vol. 1 1657 1688 1688
1689 1689 Get on Board the Soul Train: The Sound of Philadelphia International Records Vol. 1 1657 1689 1689
1690 1690 Get on Board the Soul Train: The Sound of Philadelphia International Records Vol. 1 1657 1690 1690
1691 1691 Get on Board the Soul Train: The Sound of Philadelphia International Records Vol. 1 1657 1691 1691

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE reviews_albums (
	review_id integer NOT NULL,
	album_id integer NOT NULL,
	FOREIGN KEY(review_id) REFERENCES reviews(id),
	FOREIGN KEY(album_id) REFERENCES albums(id),
	UNIQUE(review_id, album_id)
);
Powered by Datasette · Queries took 8.664ms