Index: branches/5.2.x/install/upgrades.sql =================================================================== diff -u -N -r15011 -r15125 --- branches/5.2.x/install/upgrades.sql (.../upgrades.sql) (revision 15011) +++ branches/5.2.x/install/upgrades.sql (.../upgrades.sql) (revision 15125) @@ -124,3 +124,7 @@ # ===== v 5.2.0-B1 ===== DELETE FROM SystemSettings WHERE VariableName IN ('News_Highlight_OpenTag', 'News_Highlight_CloseTag'); + +# ===== v 5.2.0-B2 ===== +UPDATE News main_table +SET main_table.CachedReviewsQty = (SELECT COUNT(*) FROM <%TABLE_PREFIX%>CatalogReviews review_table WHERE review_table.ItemId = main_table.ResourceId);