home / pf

reviews_albums

4 rows where review_id = 19910

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
20789 20789 The Slider / Zinc Alloy and the Hidden Riders of Tomorrow / Dandy in the Underworld / The T. Rex Wax Co. Singles: A's and B's 1972-77 19910 20786 20786
20790 20790 The Slider / Zinc Alloy and the Hidden Riders of Tomorrow / Dandy in the Underworld / The T. Rex Wax Co. Singles: A's and B's 1972-77 19910 20787 20787
20791 20791 The Slider / Zinc Alloy and the Hidden Riders of Tomorrow / Dandy in the Underworld / The T. Rex Wax Co. Singles: A's and B's 1972-77 19910 20788 20788
20792 20792 The Slider / Zinc Alloy and the Hidden Riders of Tomorrow / Dandy in the Underworld / The T. Rex Wax Co. Singles: A's and B's 1972-77 19910 20789 20789

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