(Communities) All Existing comments count not reflected
The contents comment count derives from the (comment_count) field on the (sn_communities_content) table.
The general flow is whenever a comment is added, the (comment_count) field will increase.
Due to customization, at times the (comment_count) may be incorrect.
The content table has a field "Root ID" that can be leveraged to correct the "comment_count" data. The "Root ID" field in the content table stores the immediate parent of the content.