MENU Count Child sql: SELECT p.`PlacementMemberNo`,COUNT(p.`MemberNo`) AS NUM,p1.`MemberNo`,p1.`ChildNum` FROM `tbl_placement_info` as p INNER JOIN `tbl_placement_info` AS p1 ON p.`PlacementMemberNo`=p1.`MemberNo` GROUP BY p.`PlacementMemberNo`,p1.`MemberNo`,p1.`ChildNum` HAVING ( COUNT(p.`MemberNo`) <> p1.`ChildNum` )
*** update StatusPlanSubcription in tbl_member_info ( Entitle Reward Status : YES ) ***
Update tbl_member_info Set StatusPlanSubcription='1' Where PlanSubcriptionExpire >= '2025-03-14' And StatusPlanSubcription < '1'

*** update NumOfSponsoring in tbl_member_info ***


check sql: SELECT MemberNo,NumOfSponsoring,Num FROM onecent.view_num_sponsoring where NumOfSponsoring < Num LIMIT 300