My review counts don't agree either. After doing this query it fixed the Average Rating & Average Price at least, but the review counts are still screwed up.
I have correct review count at showproduct.php
I have NO REVIEWS at showcat.php for all products (incorrect)
I have correct review count at index.php