2024-09-29 01:00:02 -- 將會員中心id寫入data-lake
2024-09-29 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-09-28%';
        
2024-09-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356437'
                WHERE ordernumber = 'P630928110303136' 
            
2024-09-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423337'
                WHERE ordernumber = 'P420928110452482' 
            
2024-09-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396134'
                WHERE ordernumber = 'P200928110554247' 
            
2024-09-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423338'
                WHERE ordernumber = 'P180928110756864' 
            
2024-09-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238448'
                WHERE ordernumber = 'P200928110913871' 
            
2024-09-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423339'
                WHERE ordernumber = 'P180928110924332' 
            
2024-09-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423340'
                WHERE ordernumber = 'P180928111047557' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423341'
                WHERE ordernumber = 'P180928111417548' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284931'
                WHERE ordernumber = 'P200928111703436' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386074'
                WHERE ordernumber = 'P180928111810221' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407060'
                WHERE ordernumber = 'P180928111900264' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308743'
                WHERE ordernumber = 'P180928111946206' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423343'
                WHERE ordernumber = 'P180928112246340' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276804'
                WHERE ordernumber = 'P180928112442337' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235053'
                WHERE ordernumber = 'P180928112525467' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423345'
                WHERE ordernumber = 'P200928112735720' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300665'
                WHERE ordernumber = 'P420928112824568' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423346'
                WHERE ordernumber = 'P180928113120669' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423347'
                WHERE ordernumber = 'P180928113316441' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423348'
                WHERE ordernumber = 'P180928113724262' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423349'
                WHERE ordernumber = 'P200928113817399' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370352'
                WHERE ordernumber = 'P200928114034124' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '14007'
                WHERE ordernumber = 'P200928114159338' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116319'
                WHERE ordernumber = 'P180928114534800' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423350'
                WHERE ordernumber = 'P200928114556942' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412225'
                WHERE ordernumber = 'P180928114613939' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85910'
                WHERE ordernumber = 'P180928114827549' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341080'
                WHERE ordernumber = 'P420928115144388' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131171'
                WHERE ordernumber = 'P180928115714232' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370352'
                WHERE ordernumber = 'P200928120852852' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423354'
                WHERE ordernumber = 'P420928121142920' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423355'
                WHERE ordernumber = 'P200928121229203' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421036'
                WHERE ordernumber = 'P180928121308323' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423357'
                WHERE ordernumber = 'P180928121519918' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423356'
                WHERE ordernumber = 'P420928121534942' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394705'
                WHERE ordernumber = 'P190928121538893' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '200190'
                WHERE ordernumber = 'P180928121855348' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423355'
                WHERE ordernumber = 'P200928122010591' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420002'
                WHERE ordernumber = 'P420928122157739' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106167'
                WHERE ordernumber = 'P180928122203228' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420002'
                WHERE ordernumber = 'P420928122535906' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423358'
                WHERE ordernumber = 'P420928122903937' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423359'
                WHERE ordernumber = 'P420928123007191' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220080'
                WHERE ordernumber = 'P180928123106573' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289932'
                WHERE ordernumber = 'P420928123119994' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401158'
                WHERE ordernumber = 'P200928123351923' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239691'
                WHERE ordernumber = 'P420928123451202' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354380'
                WHERE ordernumber = 'P180928123846170' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423361'
                WHERE ordernumber = 'P420928124004388' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335401'
                WHERE ordernumber = 'P190928124212693' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423362'
                WHERE ordernumber = 'P420928124344433' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110061'
                WHERE ordernumber = 'P200928124344919' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217800'
                WHERE ordernumber = 'P180928124718529' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423364'
                WHERE ordernumber = 'P420928125256904' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338106'
                WHERE ordernumber = 'P180928125403575' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365528'
                WHERE ordernumber = 'P730928125517905' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278305'
                WHERE ordernumber = 'P180928125613830' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270378'
                WHERE ordernumber = 'P200928125714284' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240785'
                WHERE ordernumber = 'P200928130259208' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423366'
                WHERE ordernumber = 'P730928130324775' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161658'
                WHERE ordernumber = 'P190928130343804' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423368'
                WHERE ordernumber = 'P180928130722204' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423369'
                WHERE ordernumber = 'P180928130926146' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217542'
                WHERE ordernumber = 'P420928131156600' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392888'
                WHERE ordernumber = 'P180928131905399' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302567'
                WHERE ordernumber = 'P180928132119438' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421153'
                WHERE ordernumber = 'P200928132316949' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423370'
                WHERE ordernumber = 'P180928132348899' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417187'
                WHERE ordernumber = 'P420928132413769' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423373'
                WHERE ordernumber = 'P200928132553689' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106604'
                WHERE ordernumber = 'P180928132646162' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209851'
                WHERE ordernumber = 'P420928132835133' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306128'
                WHERE ordernumber = 'P710928132926343' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423374'
                WHERE ordernumber = 'P180928133045662' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423375'
                WHERE ordernumber = 'P710928133926389' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220161'
                WHERE ordernumber = 'P200928134048287' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257551'
                WHERE ordernumber = 'P180928134209941' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347872'
                WHERE ordernumber = 'P180928134401410' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423377'
                WHERE ordernumber = 'P420928134519523' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423376'
                WHERE ordernumber = 'P730928134544792' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423378'
                WHERE ordernumber = 'P200928134729802' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380417'
                WHERE ordernumber = 'P420928134734184' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423379'
                WHERE ordernumber = 'P730928134816393' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423380'
                WHERE ordernumber = 'P710928134952513' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361923'
                WHERE ordernumber = 'P420928135044196' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423381'
                WHERE ordernumber = 'P710928135309880' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423382'
                WHERE ordernumber = 'P200928135330177' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423383'
                WHERE ordernumber = 'P420928135551478' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423384'
                WHERE ordernumber = 'P180928135923957' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362397'
                WHERE ordernumber = 'P420928140449457' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423385'
                WHERE ordernumber = 'P200928140531659' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149064'
                WHERE ordernumber = 'P180928140648897' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318476'
                WHERE ordernumber = 'P420928140700717' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328335'
                WHERE ordernumber = 'P200928140749344' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423387'
                WHERE ordernumber = 'P180928140755868' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423388'
                WHERE ordernumber = 'P180928140906480' 
            
2024-09-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382720'
                WHERE ordernumber = 'P180928141003765' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236193'
                WHERE ordernumber = 'P180928141703408' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423389'
                WHERE ordernumber = 'P200928141741469' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327912'
                WHERE ordernumber = 'P420928142120415' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423390'
                WHERE ordernumber = 'P420928142232850' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423391'
                WHERE ordernumber = 'P180928142310535' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421284'
                WHERE ordernumber = 'P200928142334820' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423392'
                WHERE ordernumber = 'P420928142338571' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423393'
                WHERE ordernumber = 'P200928142559577' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423394'
                WHERE ordernumber = 'P420928142647258' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423140'
                WHERE ordernumber = 'P180928143233589' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313180'
                WHERE ordernumber = 'P420928143434326' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415664'
                WHERE ordernumber = 'P730928143912948' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423396'
                WHERE ordernumber = 'P420928144116447' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423397'
                WHERE ordernumber = 'P200928144435869' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256117'
                WHERE ordernumber = 'P200928144826813' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423399'
                WHERE ordernumber = 'P710928145249485' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81864'
                WHERE ordernumber = 'P180928145410474' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423400'
                WHERE ordernumber = 'P730928145909817' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423401'
                WHERE ordernumber = 'P180928145916537' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423402'
                WHERE ordernumber = 'P420928150043405' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343000'
                WHERE ordernumber = 'P420928150148478' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128489'
                WHERE ordernumber = 'P190928150205640' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420570'
                WHERE ordernumber = 'P420928150249130' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248386'
                WHERE ordernumber = 'P200928150315604' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232505'
                WHERE ordernumber = 'P710928150656813' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268115'
                WHERE ordernumber = 'P180928150714648' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357667'
                WHERE ordernumber = 'P420928150950750' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423404'
                WHERE ordernumber = 'P420928151101244' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423403'
                WHERE ordernumber = 'P730928151158344' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423405'
                WHERE ordernumber = 'P420928151215825' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423406'
                WHERE ordernumber = 'P420928151320198' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423407'
                WHERE ordernumber = 'P710928151919236' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423408'
                WHERE ordernumber = 'P730928151949897' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321442'
                WHERE ordernumber = 'P200928152053336' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423410'
                WHERE ordernumber = 'P200928152317315' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387409'
                WHERE ordernumber = 'P200928152817188' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423411'
                WHERE ordernumber = 'P200928153101828' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423412'
                WHERE ordernumber = 'P200928153306795' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341683'
                WHERE ordernumber = 'P420928153335137' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423413'
                WHERE ordernumber = 'P180928153952988' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132781'
                WHERE ordernumber = 'P180928154112742' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423414'
                WHERE ordernumber = 'P710928154206657' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P180928154221787' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66674'
                WHERE ordernumber = 'P200928154334739' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361358'
                WHERE ordernumber = 'P180928154407724' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78163'
                WHERE ordernumber = 'P710928154454302' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422950'
                WHERE ordernumber = 'P180928154546153' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210058'
                WHERE ordernumber = 'P710928154600984' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422950'
                WHERE ordernumber = 'P180928154624805' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420889'
                WHERE ordernumber = 'P420928154638784' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420889'
                WHERE ordernumber = 'P420928154719244' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423415'
                WHERE ordernumber = 'P710928154930834' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286984'
                WHERE ordernumber = 'P180928154955730' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423416'
                WHERE ordernumber = 'P420928155001235' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420889'
                WHERE ordernumber = 'P420928155032136' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423417'
                WHERE ordernumber = 'P180928155130753' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423409'
                WHERE ordernumber = 'P180928155506373' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422126'
                WHERE ordernumber = 'P710928155525477' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358345'
                WHERE ordernumber = 'P420928155549893' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373174'
                WHERE ordernumber = 'P180928155730935' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423418'
                WHERE ordernumber = 'P730928160115142' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423419'
                WHERE ordernumber = 'P180928160149900' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423420'
                WHERE ordernumber = 'P180928160300718' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423421'
                WHERE ordernumber = 'P200928160641949' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284294'
                WHERE ordernumber = 'P710928160734977' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423421'
                WHERE ordernumber = 'P200928160743836' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422704'
                WHERE ordernumber = 'P200928160831581' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423422'
                WHERE ordernumber = 'P420928160947741' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135941'
                WHERE ordernumber = 'P710928161042705' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423423'
                WHERE ordernumber = 'P420928161121610' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180928161352742' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423424'
                WHERE ordernumber = 'P710928161354196' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423425'
                WHERE ordernumber = 'P180928161550638' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423419'
                WHERE ordernumber = 'P180928161643834' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423426'
                WHERE ordernumber = 'P710928161820924' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388574'
                WHERE ordernumber = 'P710928162627452' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144322'
                WHERE ordernumber = 'P420928162712741' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115088'
                WHERE ordernumber = 'P710928163043599' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419976'
                WHERE ordernumber = 'P420928163043518' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333092'
                WHERE ordernumber = 'P420928163228492' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275911'
                WHERE ordernumber = 'P420928163419279' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423428'
                WHERE ordernumber = 'P420928164039656' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423429'
                WHERE ordernumber = 'P420928164237782' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423430'
                WHERE ordernumber = 'P200928164905430' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259325'
                WHERE ordernumber = 'P200928165004328' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266404'
                WHERE ordernumber = 'P180928165037363' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423431'
                WHERE ordernumber = 'P200928165205994' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422840'
                WHERE ordernumber = 'P730928165208517' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P420928165515322' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346832'
                WHERE ordernumber = 'P200928165629809' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298249'
                WHERE ordernumber = 'P420928165818293' 
            
2024-09-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423432'
                WHERE ordernumber = 'P200928170024256' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '274869'
                WHERE ordernumber = 'P630928170109606' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423433'
                WHERE ordernumber = 'P420928170153971' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314109'
                WHERE ordernumber = 'P420928170314956' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423434'
                WHERE ordernumber = 'P180928170351321' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423437'
                WHERE ordernumber = 'P420928170559705' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423438'
                WHERE ordernumber = 'P420928170755297' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423436'
                WHERE ordernumber = 'P710928170914238' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '332458'
                WHERE ordernumber = 'P420928171035197' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341175'
                WHERE ordernumber = 'P180928171115404' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318562'
                WHERE ordernumber = 'P420928171124122' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399767'
                WHERE ordernumber = 'P200928171722391' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365876'
                WHERE ordernumber = 'P710928172010683' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334906'
                WHERE ordernumber = 'P730928172256797' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423441'
                WHERE ordernumber = 'P420928172541694' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423442'
                WHERE ordernumber = 'P420928172719766' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423440'
                WHERE ordernumber = 'P710928172751114' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '274772'
                WHERE ordernumber = 'P420928173038913' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '132559'
                WHERE ordernumber = 'P180928173318134' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423445'
                WHERE ordernumber = 'P180928173525659' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272181'
                WHERE ordernumber = 'P420928174149582' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420928174341472' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423446'
                WHERE ordernumber = 'P200928174615290' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423447'
                WHERE ordernumber = 'P730928175046831' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423448'
                WHERE ordernumber = 'P180928175144991' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423449'
                WHERE ordernumber = 'P180928175318834' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423450'
                WHERE ordernumber = 'P180928175426497' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390391'
                WHERE ordernumber = 'P630928175709671' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340336'
                WHERE ordernumber = 'P180928175920233' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423452'
                WHERE ordernumber = 'P710928180040621' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423453'
                WHERE ordernumber = 'P420928180043687' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423454'
                WHERE ordernumber = 'P200928180046417' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303390'
                WHERE ordernumber = 'P420928180148929' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423455'
                WHERE ordernumber = 'P420928180252656' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326143'
                WHERE ordernumber = 'P200928180258334' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421596'
                WHERE ordernumber = 'P730928180402168' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338512'
                WHERE ordernumber = 'P200928180714796' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423456'
                WHERE ordernumber = 'P200928181004948' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423458'
                WHERE ordernumber = 'P200928181211548' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383100'
                WHERE ordernumber = 'P180928181822417' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423459'
                WHERE ordernumber = 'P200928181956634' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423460'
                WHERE ordernumber = 'P420928182129300' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '124061'
                WHERE ordernumber = 'P180928182336180' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242724'
                WHERE ordernumber = 'P710928182438428' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423461'
                WHERE ordernumber = 'P420928182630586' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423462'
                WHERE ordernumber = 'P180928182725555' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423463'
                WHERE ordernumber = 'P200928183352632' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329369'
                WHERE ordernumber = 'P200928183751722' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284252'
                WHERE ordernumber = 'P180928185034277' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423467'
                WHERE ordernumber = 'P710928185227658' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423468'
                WHERE ordernumber = 'P710928185424278' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423466'
                WHERE ordernumber = 'P730928185451255' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402035'
                WHERE ordernumber = 'P200928185538675' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423471'
                WHERE ordernumber = 'P420928185610966' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423472'
                WHERE ordernumber = 'P710928185834510' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403170'
                WHERE ordernumber = 'P200928190130738' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '373653'
                WHERE ordernumber = 'P190928191017550' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423476'
                WHERE ordernumber = 'P730928191447639' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350514'
                WHERE ordernumber = 'P630928191824385' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214649'
                WHERE ordernumber = 'P200928192109204' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423475'
                WHERE ordernumber = 'P190928192304739' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383006'
                WHERE ordernumber = 'P190928192914777' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423479'
                WHERE ordernumber = 'P200928193509693' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423479'
                WHERE ordernumber = 'P200928193603806' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240044'
                WHERE ordernumber = 'P190928193742702' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248195'
                WHERE ordernumber = 'P200928195711687' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423483'
                WHERE ordernumber = 'P710928202438215' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371688'
                WHERE ordernumber = 'P710928202827120' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423486'
                WHERE ordernumber = 'P710928203552779' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423487'
                WHERE ordernumber = 'P710928205444832' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423488'
                WHERE ordernumber = 'P710928210515609' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328505'
                WHERE ordernumber = 'P710928211050408' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423489'
                WHERE ordernumber = 'P710928211712638' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423491'
                WHERE ordernumber = 'P710928215814239' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423492'
                WHERE ordernumber = 'P710928220342770' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423494'
                WHERE ordernumber = 'P710928221505414' 
            
2024-09-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239434'
                WHERE ordernumber = 'P710928222836737'