2024-12-11 01:00:02 -- 將會員中心id寫入data-lake
2024-12-11 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-12-10%';
        
2024-12-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271511'
                WHERE ordernumber = 'P2412100000234' 
            
2024-12-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419945'
                WHERE ordernumber = 'P2412100000330' 
            
2024-12-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424900'
                WHERE ordernumber = 'P2412100000464' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434503'
                WHERE ordernumber = 'P2412100000544' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432971'
                WHERE ordernumber = 'P2412100000675' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426906'
                WHERE ordernumber = 'P2412100000944' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218542'
                WHERE ordernumber = 'P2412100001039' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434506'
                WHERE ordernumber = 'P2412100001125' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318845'
                WHERE ordernumber = 'P2412100001240' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434509'
                WHERE ordernumber = 'P2412100001599' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434511'
                WHERE ordernumber = 'P2412100001747' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434489'
                WHERE ordernumber = 'P2412100001919' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388239'
                WHERE ordernumber = 'P2412100002028' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392638'
                WHERE ordernumber = 'P2412100002228' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434514'
                WHERE ordernumber = 'P2412100002328' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434513'
                WHERE ordernumber = 'P2412100002439' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434512'
                WHERE ordernumber = 'P2412100002550' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101057'
                WHERE ordernumber = 'P2412100002691' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101057'
                WHERE ordernumber = 'P2412100002714' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433281'
                WHERE ordernumber = 'P2412100002970' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434516'
                WHERE ordernumber = 'P2412100003017' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434518'
                WHERE ordernumber = 'P2412100003193' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434515'
                WHERE ordernumber = 'P2412100003268' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P2412100003418' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212791'
                WHERE ordernumber = 'P2412100003518' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421792'
                WHERE ordernumber = 'P2412100003732' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434201'
                WHERE ordernumber = 'P2412100003842' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P2412100003940' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434201'
                WHERE ordernumber = 'P2412100004035' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434521'
                WHERE ordernumber = 'P2412100004169' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240110'
                WHERE ordernumber = 'P2412100004427' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419560'
                WHERE ordernumber = 'P2412100004691' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434526'
                WHERE ordernumber = 'P2412100004727' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355315'
                WHERE ordernumber = 'P2412100004889' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398470'
                WHERE ordernumber = 'P2412100005114' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390739'
                WHERE ordernumber = 'P2412100005264' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431045'
                WHERE ordernumber = 'P2412100005497' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426082'
                WHERE ordernumber = 'P2412100005641' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430872'
                WHERE ordernumber = 'P2412100005720' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434532'
                WHERE ordernumber = 'P2412100006064' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64255'
                WHERE ordernumber = 'P2412100006170' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285742'
                WHERE ordernumber = 'P2412100006458' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148740'
                WHERE ordernumber = 'P2412100006599' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315722'
                WHERE ordernumber = 'P2412100006788' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352681'
                WHERE ordernumber = 'P2412100006830' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345610'
                WHERE ordernumber = 'P2412100007015' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432301'
                WHERE ordernumber = 'P2412100007162' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434355'
                WHERE ordernumber = 'P2412100007289' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99632'
                WHERE ordernumber = 'P2412100007576' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434477'
                WHERE ordernumber = 'P2412100007625' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125147'
                WHERE ordernumber = 'P2412100007870' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394705'
                WHERE ordernumber = 'P2412100008265' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434540'
                WHERE ordernumber = 'P2412100008448' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P2412100008690' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232624'
                WHERE ordernumber = 'P2412100008819' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '4'
                WHERE ordernumber = 'P2412100009088' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102656'
                WHERE ordernumber = 'P2412100009148' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434543'
                WHERE ordernumber = 'P2412100009235' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232624'
                WHERE ordernumber = 'P2412100009315' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162314'
                WHERE ordernumber = 'P2412100009765' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431156'
                WHERE ordernumber = 'P2412100010097' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432060'
                WHERE ordernumber = 'P2412100010130' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431156'
                WHERE ordernumber = 'P2412100010255' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P2412100010389' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386641'
                WHERE ordernumber = 'P2412100010538' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258277'
                WHERE ordernumber = 'P2412100010714' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434557'
                WHERE ordernumber = 'P2412100010877' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137433'
                WHERE ordernumber = 'P2412100011048' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434558'
                WHERE ordernumber = 'P2412100011332' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434562'
                WHERE ordernumber = 'P2412100011441' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421433'
                WHERE ordernumber = 'P2412100011611' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432460'
                WHERE ordernumber = 'P2412100011770' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434563'
                WHERE ordernumber = 'P2412100011862' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207724'
                WHERE ordernumber = 'P2412100012018' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327316'
                WHERE ordernumber = 'P2412100012263' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98337'
                WHERE ordernumber = 'P2412100012366' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250167'
                WHERE ordernumber = 'P2412100012472' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434566'
                WHERE ordernumber = 'P2412100012679' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434570'
                WHERE ordernumber = 'P2412100012721' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434569'
                WHERE ordernumber = 'P2412100012840' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116605'
                WHERE ordernumber = 'P2412100013084' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133492'
                WHERE ordernumber = 'P2412100013114' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P2412100013537' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434574'
                WHERE ordernumber = 'P2412100013840' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376600'
                WHERE ordernumber = 'P2412100014043' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434576'
                WHERE ordernumber = 'P2412100014184' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434575'
                WHERE ordernumber = 'P2412100014389' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434577'
                WHERE ordernumber = 'P2412100014459' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356733'
                WHERE ordernumber = 'P2412100014547' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434579'
                WHERE ordernumber = 'P2412100014693' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421405'
                WHERE ordernumber = 'P2412100014713' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434580'
                WHERE ordernumber = 'P2412100014883' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434582'
                WHERE ordernumber = 'P2412100014980' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320225'
                WHERE ordernumber = 'P2412100015086' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434587'
                WHERE ordernumber = 'P2412100015429' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434559'
                WHERE ordernumber = 'P2412100015682' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434590'
                WHERE ordernumber = 'P2412100015864' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434591'
                WHERE ordernumber = 'P2412100015986' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434592'
                WHERE ordernumber = 'P2412100016162' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434537'
                WHERE ordernumber = 'P2412100016256' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P2412100016326' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434325'
                WHERE ordernumber = 'P2412100016543' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115527'
                WHERE ordernumber = 'P2412100016670' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434596'
                WHERE ordernumber = 'P2412100016774' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434597'
                WHERE ordernumber = 'P2412100016824' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434599'
                WHERE ordernumber = 'P2412100017149' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434601'
                WHERE ordernumber = 'P2412100017235' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434600'
                WHERE ordernumber = 'P2412100017367' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434602'
                WHERE ordernumber = 'P2412100017688' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401147'
                WHERE ordernumber = 'P2412100017712' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434606'
                WHERE ordernumber = 'P2412100018022' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434606'
                WHERE ordernumber = 'P2412100018180' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427016'
                WHERE ordernumber = 'P2412100018289' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108588'
                WHERE ordernumber = 'P2412100018375' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363108'
                WHERE ordernumber = 'P2412100018461' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363108'
                WHERE ordernumber = 'P2412100018748' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326179'
                WHERE ordernumber = 'P2412100018884' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P2412100018939' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363108'
                WHERE ordernumber = 'P2412100019068' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434611'
                WHERE ordernumber = 'P2412100019268' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434610'
                WHERE ordernumber = 'P2412100019344' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388694'
                WHERE ordernumber = 'P2412100019491' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434613'
                WHERE ordernumber = 'P2412100019831' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84477'
                WHERE ordernumber = 'P2412100019955' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354188'
                WHERE ordernumber = 'P2412100020031' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P2412100020281' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398151'
                WHERE ordernumber = 'P2412100020371' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434615'
                WHERE ordernumber = 'P2412100020536' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130454'
                WHERE ordernumber = 'P2412100020658' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231945'
                WHERE ordernumber = 'P2412100020749' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434617'
                WHERE ordernumber = 'P2412100021087' 
            
2024-12-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288625'
                WHERE ordernumber = 'P2412100021172' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385733'
                WHERE ordernumber = 'P2412100021952' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '49446'
                WHERE ordernumber = 'P2412100022137' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434115'
                WHERE ordernumber = 'P2412100022581' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311532'
                WHERE ordernumber = 'P2412100022665' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434623'
                WHERE ordernumber = 'P2412100022846' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303631'
                WHERE ordernumber = 'P2412100023078' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369507'
                WHERE ordernumber = 'P2412100023136' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434622'
                WHERE ordernumber = 'P2412100023233' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284422'
                WHERE ordernumber = 'P2412100023422' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '28865'
                WHERE ordernumber = 'P2412100023797' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328235'
                WHERE ordernumber = 'P2412100023991' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127964'
                WHERE ordernumber = 'P2412100024067' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428128'
                WHERE ordernumber = 'P2412100024151' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434624'
                WHERE ordernumber = 'P2412100024243' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113566'
                WHERE ordernumber = 'P2412100024316' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434625'
                WHERE ordernumber = 'P2412100024482' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434626'
                WHERE ordernumber = 'P2412100024644' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100521'
                WHERE ordernumber = 'P2412100025022' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434629'
                WHERE ordernumber = 'P2412100025114' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342831'
                WHERE ordernumber = 'P2412100025335' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434635'
                WHERE ordernumber = 'P2412100025784' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301608'
                WHERE ordernumber = 'P2412100025858' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434641'
                WHERE ordernumber = 'P2412100026539' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434363'
                WHERE ordernumber = 'P2412100026980' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434643'
                WHERE ordernumber = 'P2412100027214' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434644'
                WHERE ordernumber = 'P2412100027386' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434645'
                WHERE ordernumber = 'P2412100027413' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434646'
                WHERE ordernumber = 'P2412100027520' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433063'
                WHERE ordernumber = 'P2412100027874' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359921'
                WHERE ordernumber = 'P2412100027972' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298399'
                WHERE ordernumber = 'P2412100028013' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82529'
                WHERE ordernumber = 'P2412100028178' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434648'
                WHERE ordernumber = 'P2412100028252' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434649'
                WHERE ordernumber = 'P2412100028364' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288868'
                WHERE ordernumber = 'P2412100028433' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111864'
                WHERE ordernumber = 'P2412100028635' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434651'
                WHERE ordernumber = 'P2412100028872' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434653'
                WHERE ordernumber = 'P2412100028986' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98135'
                WHERE ordernumber = 'P2412100029179' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434655'
                WHERE ordernumber = 'P2412100029242' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434656'
                WHERE ordernumber = 'P2412100029316' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434657'
                WHERE ordernumber = 'P2412100029610' 
            
2024-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276745'
                WHERE ordernumber = 'P2412100029743'