2024-06-18 01:00:02 -- 將會員中心id寫入data-lake
2024-06-18 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-06-17%';
        
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396400'
                WHERE ordernumber = 'P630617102810266' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300636'
                WHERE ordernumber = 'P420617110138460' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391750'
                WHERE ordernumber = 'P180617110205131' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247665'
                WHERE ordernumber = 'P180617110328333' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100813'
                WHERE ordernumber = 'P200617110438713' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165635'
                WHERE ordernumber = 'P180617110519337' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385932'
                WHERE ordernumber = 'P180617110759128' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394498'
                WHERE ordernumber = 'P190617110824797' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100813'
                WHERE ordernumber = 'P200617110826117' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396405'
                WHERE ordernumber = 'P630617112008937' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396407'
                WHERE ordernumber = 'P200617112746755' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106569'
                WHERE ordernumber = 'P180617113052340' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244303'
                WHERE ordernumber = 'P190617113133552' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382282'
                WHERE ordernumber = 'P420617113249562' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326390'
                WHERE ordernumber = 'P190617113328860' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345881'
                WHERE ordernumber = 'P200617113550271' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396410'
                WHERE ordernumber = 'P180617113630480' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396411'
                WHERE ordernumber = 'P180617113931382' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378439'
                WHERE ordernumber = 'P190617114021220' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240970'
                WHERE ordernumber = 'P190617114320983' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396412'
                WHERE ordernumber = 'P180617114331359' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396413'
                WHERE ordernumber = 'P190617114510996' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340762'
                WHERE ordernumber = 'P180617114550277' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396414'
                WHERE ordernumber = 'P200617115025969' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396415'
                WHERE ordernumber = 'P190617115207674' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396416'
                WHERE ordernumber = 'P180617115336702' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200617115345241' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239181'
                WHERE ordernumber = 'P180617120102174' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162735'
                WHERE ordernumber = 'P180617120609971' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381829'
                WHERE ordernumber = 'P200617120611180' 
            
2024-06-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355408'
                WHERE ordernumber = 'P420617120613695' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277884'
                WHERE ordernumber = 'P630617120943222' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P420617121051775' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268597'
                WHERE ordernumber = 'P200617121408944' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396420'
                WHERE ordernumber = 'P200617122045917' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347910'
                WHERE ordernumber = 'P420617122150660' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396419'
                WHERE ordernumber = 'P420617122219920' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98841'
                WHERE ordernumber = 'P200617122330596' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326963'
                WHERE ordernumber = 'P200617123009290' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297282'
                WHERE ordernumber = 'P200617123334705' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396421'
                WHERE ordernumber = 'P180617123509461' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360121'
                WHERE ordernumber = 'P420617124032865' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389396'
                WHERE ordernumber = 'P200617125036549' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266880'
                WHERE ordernumber = 'P180617125138209' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76684'
                WHERE ordernumber = 'P200617130327431' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180617132001448' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391074'
                WHERE ordernumber = 'P200617132259187' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318933'
                WHERE ordernumber = 'P190617132347296' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260240'
                WHERE ordernumber = 'P190617132454385' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164029'
                WHERE ordernumber = 'P420617132640571' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393615'
                WHERE ordernumber = 'P420617133156912' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396426'
                WHERE ordernumber = 'P420617134220377' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289715'
                WHERE ordernumber = 'P190617134223844' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304578'
                WHERE ordernumber = 'P200617134323120' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396428'
                WHERE ordernumber = 'P180617134443125' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271523'
                WHERE ordernumber = 'P200617134540993' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289404'
                WHERE ordernumber = 'P180617134806687' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112848'
                WHERE ordernumber = 'P590617135334270' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240781'
                WHERE ordernumber = 'P200617135436831' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221947'
                WHERE ordernumber = 'P190617140058168' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293690'
                WHERE ordernumber = 'P190617140304419' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283871'
                WHERE ordernumber = 'P190617140642665' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384776'
                WHERE ordernumber = 'P420617140733347' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396431'
                WHERE ordernumber = 'P420617140818708' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P190617141018454' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396432'
                WHERE ordernumber = 'P630617141121979' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208327'
                WHERE ordernumber = 'P190617141157562' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273217'
                WHERE ordernumber = 'P180617141313735' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117510'
                WHERE ordernumber = 'P200617141435463' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396433'
                WHERE ordernumber = 'P180617141623570' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396434'
                WHERE ordernumber = 'P190617141718346' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307848'
                WHERE ordernumber = 'P180617141734925' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396435'
                WHERE ordernumber = 'P420617141832976' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396435'
                WHERE ordernumber = 'P420617142238350' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119181'
                WHERE ordernumber = 'P190617142514842' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377510'
                WHERE ordernumber = 'P630617143059924' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396439'
                WHERE ordernumber = 'P190617144016950' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307716'
                WHERE ordernumber = 'P200617144420292' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396441'
                WHERE ordernumber = 'P200617144753713' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180617145029850' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394547'
                WHERE ordernumber = 'P180617145355216' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396442'
                WHERE ordernumber = 'P200617145623902' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396443'
                WHERE ordernumber = 'P200617145912651' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97529'
                WHERE ordernumber = 'P200617150105884' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396445'
                WHERE ordernumber = 'P420617150552783' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396446'
                WHERE ordernumber = 'P420617150737471' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396448'
                WHERE ordernumber = 'P200617151509778' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389581'
                WHERE ordernumber = 'P420617151604386' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396449'
                WHERE ordernumber = 'P180617151845156' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396450'
                WHERE ordernumber = 'P200617152329877' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396452'
                WHERE ordernumber = 'P180617152840676' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396451'
                WHERE ordernumber = 'P420617153029765' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158535'
                WHERE ordernumber = 'P200617153649981' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290185'
                WHERE ordernumber = 'P420617153832248' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112568'
                WHERE ordernumber = 'P180617153910973' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '71036'
                WHERE ordernumber = 'P420617153957229' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396456'
                WHERE ordernumber = 'P420617154120183' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384264'
                WHERE ordernumber = 'P420617154258133' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377666'
                WHERE ordernumber = 'P590617154624212' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354027'
                WHERE ordernumber = 'P420617154856464' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314916'
                WHERE ordernumber = 'P200617155351694' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240594'
                WHERE ordernumber = 'P180617155543558' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359921'
                WHERE ordernumber = 'P420617155954322' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396458'
                WHERE ordernumber = 'P420617160225736' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387808'
                WHERE ordernumber = 'P420617160459378' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396459'
                WHERE ordernumber = 'P200617160700143' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258081'
                WHERE ordernumber = 'P200617160901417' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396460'
                WHERE ordernumber = 'P420617161256614' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396461'
                WHERE ordernumber = 'P200617161538871' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396463'
                WHERE ordernumber = 'P190617161628260' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396390'
                WHERE ordernumber = 'P420617161640166' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396462'
                WHERE ordernumber = 'P180617161650856' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390993'
                WHERE ordernumber = 'P200617161823571' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395936'
                WHERE ordernumber = 'P190617161911423' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396464'
                WHERE ordernumber = 'P180617162402738' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396466'
                WHERE ordernumber = 'P200617162642171' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358895'
                WHERE ordernumber = 'P200617162755472' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326472'
                WHERE ordernumber = 'P180617162756690' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382192'
                WHERE ordernumber = 'P200617162953113' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390975'
                WHERE ordernumber = 'P200617163049839' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386984'
                WHERE ordernumber = 'P180617163534978' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334390'
                WHERE ordernumber = 'P200617163555526' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396467'
                WHERE ordernumber = 'P420617164435413' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396468'
                WHERE ordernumber = 'P180617164513426' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396470'
                WHERE ordernumber = 'P200617164518204' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396471'
                WHERE ordernumber = 'P180617164901763' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396472'
                WHERE ordernumber = 'P200617165036351' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241772'
                WHERE ordernumber = 'P180617165811880' 
            
2024-06-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241772'
                WHERE ordernumber = 'P180617165915192' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396476'
                WHERE ordernumber = 'P200617170302340' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P420617170728299' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92196'
                WHERE ordernumber = 'P180617171049219' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396475'
                WHERE ordernumber = 'P180617171329592' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396478'
                WHERE ordernumber = 'P780617172013364' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396479'
                WHERE ordernumber = 'P630617172036211' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396480'
                WHERE ordernumber = 'P180617172723662' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396481'
                WHERE ordernumber = 'P200617172841293' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P180617172931855' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365131'
                WHERE ordernumber = 'P630617173204575' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396482'
                WHERE ordernumber = 'P200617173431341' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180617173840130' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396483'
                WHERE ordernumber = 'P180617174537758' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396484'
                WHERE ordernumber = 'P630617174658964' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358676'
                WHERE ordernumber = 'P200617174959936' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396483'
                WHERE ordernumber = 'P180617175125717' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396485'
                WHERE ordernumber = 'P200617175224806' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396486'
                WHERE ordernumber = 'P180617175539905' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360180'
                WHERE ordernumber = 'P200617180024248' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396489'
                WHERE ordernumber = 'P180617180310278' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387871'
                WHERE ordernumber = 'P780617180841356' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233074'
                WHERE ordernumber = 'P200617181000433' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277458'
                WHERE ordernumber = 'P180617181022952' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301501'
                WHERE ordernumber = 'P200617181239997' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305389'
                WHERE ordernumber = 'P420617181447790' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396492'
                WHERE ordernumber = 'P420617181735396' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P180617182438477' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87579'
                WHERE ordernumber = 'P180617182535524' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276379'
                WHERE ordernumber = 'P180617183254602' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283062'
                WHERE ordernumber = 'P200617183334896' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P200617183501878' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369507'
                WHERE ordernumber = 'P420617183728629' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302731'
                WHERE ordernumber = 'P180617183830120' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96157'
                WHERE ordernumber = 'P180617183912598' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396494'
                WHERE ordernumber = 'P190617184040725' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396495'
                WHERE ordernumber = 'P200617184435372' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396496'
                WHERE ordernumber = 'P420617184459472' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396497'
                WHERE ordernumber = 'P420617184638437' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396498'
                WHERE ordernumber = 'P180617184713290' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396499'
                WHERE ordernumber = 'P420617184740249' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P190617184810194' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298476'
                WHERE ordernumber = 'P420617185141851' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396500'
                WHERE ordernumber = 'P590617185301807' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396501'
                WHERE ordernumber = 'P190617185419873' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396502'
                WHERE ordernumber = 'P190617185957252' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '45541'
                WHERE ordernumber = 'P200617190659992' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396503'
                WHERE ordernumber = 'P190617190754985' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217153'
                WHERE ordernumber = 'P190617191923366' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382504'
                WHERE ordernumber = 'P190617192316873' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294123'
                WHERE ordernumber = 'P200617192442546' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379186'
                WHERE ordernumber = 'P200617192603914' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379186'
                WHERE ordernumber = 'P200617192803167' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110974'
                WHERE ordernumber = 'P200617193454419' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249881'
                WHERE ordernumber = 'P200617193809788' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277934'
                WHERE ordernumber = 'P190617194124578' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277934'
                WHERE ordernumber = 'P190617194231485' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312521'
                WHERE ordernumber = 'P200617194809917' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396505'
                WHERE ordernumber = 'P780617195335510' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396506'
                WHERE ordernumber = 'P200617195409188' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396508'
                WHERE ordernumber = 'P190617195736127' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396507'
                WHERE ordernumber = 'P780617195831551' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396510'
                WHERE ordernumber = 'P590617211940157' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159033'
                WHERE ordernumber = 'P780617212127816' 
            
2024-06-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396513'
                WHERE ordernumber = 'P780617215114613'