Neil Tompkins schrieb:
> Hi
>
> I want to order by the totalled fields varProductCount and Products.ProductReviewDESC

just put them together, separated with comma, like it is written in the manual

ORDER BY varProductCount + Products.ProductReviewDESC,
COUNT(ProductsPurchases.ProductID)