Index: branches/5.2.x/install/upgrades.sql =================================================================== diff -u -N -r15044 -r15123 --- branches/5.2.x/install/upgrades.sql (.../upgrades.sql) (revision 15044) +++ branches/5.2.x/install/upgrades.sql (.../upgrades.sql) (revision 15123) @@ -259,3 +259,7 @@ ); INSERT INTO SystemSettings VALUES(DEFAULT, 'MaxCompareProducts', '3', 'In-Commerce', 'in-commerce:output', 'la_Text_Products', 'la_config_MaxCompareProducts', 'text', NULL, NULL, 10.12, 0, 1, NULL); + +# ===== v 5.2.0-B2 ===== +UPDATE Products main_table +SET main_table.CachedReviewsQty = (SELECT COUNT(*) FROM <%TABLE_PREFIX%>CatalogReviews review_table WHERE review_table.ItemId = main_table.ResourceId);