MENU

Count Child

sql: q
*** update StatusPlanSubcription in tbl_member_info ( Entitle Reward Status : YES ) ***
Update tbl_member_info Set StatusPlanSubcription='1' Where PlanSubcriptionExpire >= '2022-07-03' 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