The missing sub-categories and the duplicate records are directly connected.
I will have the Kindle database rebuilt by morning, and the print book database rebuilt by tomorrow night.
A simple mistake in the coding caused this issue — a mistake equal to that of being “one decimal point off”.
Bill Platt