2024-05-24 01:00:01 -- 將會員中心id寫入data-lake
2024-05-24 01:00:01 -- 
            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-05-23%';
        
2024-05-24 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '391438'
                WHERE ordernumber = 'P630523100646582' 
            
2024-05-24 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '391440'
                WHERE ordernumber = 'P630523100818179' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391442'
                WHERE ordernumber = 'P630523102624710' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388164'
                WHERE ordernumber = 'P200523110503157' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391444'
                WHERE ordernumber = 'P630523110752738' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '191911'
                WHERE ordernumber = 'P420523110802718' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311368'
                WHERE ordernumber = 'P180523110908808' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391447'
                WHERE ordernumber = 'P420523111229758' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391448'
                WHERE ordernumber = 'P180523111339402' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391449'
                WHERE ordernumber = 'P200523111439837' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391448'
                WHERE ordernumber = 'P180523111456764' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261293'
                WHERE ordernumber = 'P200523111823568' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391451'
                WHERE ordernumber = 'P180523112215614' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391452'
                WHERE ordernumber = 'P200523112250796' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391453'
                WHERE ordernumber = 'P630523112729882' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240748'
                WHERE ordernumber = 'P180523112727215' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391454'
                WHERE ordernumber = 'P420523112848487' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391455'
                WHERE ordernumber = 'P420523113208268' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391456'
                WHERE ordernumber = 'P790523113824952' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223787'
                WHERE ordernumber = 'P200523113858496' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391457'
                WHERE ordernumber = 'P180523113956954' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137117'
                WHERE ordernumber = 'P190523114011522' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391460'
                WHERE ordernumber = 'P180523114408690' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200523114446265' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P190523114547693' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386814'
                WHERE ordernumber = 'P630523114625777' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391462'
                WHERE ordernumber = 'P790523115039145' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355315'
                WHERE ordernumber = 'P180523115423473' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391463'
                WHERE ordernumber = 'P710523115558568' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391464'
                WHERE ordernumber = 'P180523120008258' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391467'
                WHERE ordernumber = 'P180523120314409' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391465'
                WHERE ordernumber = 'P710523120347842' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209620'
                WHERE ordernumber = 'P180523121231290' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387596'
                WHERE ordernumber = 'P630523121252299' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391439'
                WHERE ordernumber = 'P200523121722660' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391439'
                WHERE ordernumber = 'P200523121800360' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130976'
                WHERE ordernumber = 'P180523121838484' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391473'
                WHERE ordernumber = 'P180523122040961' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391474'
                WHERE ordernumber = 'P180523122226455' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391476'
                WHERE ordernumber = 'P630523122454430' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391475'
                WHERE ordernumber = 'P790523122545837' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391477'
                WHERE ordernumber = 'P630523123033844' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391478'
                WHERE ordernumber = 'P200523123103294' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391479'
                WHERE ordernumber = 'P180523123143256' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '292648'
                WHERE ordernumber = 'P200523123256431' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391480'
                WHERE ordernumber = 'P180523123343562' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391482'
                WHERE ordernumber = 'P630523124104970' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391483'
                WHERE ordernumber = 'P630523124455603' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391484'
                WHERE ordernumber = 'P200523124520638' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287339'
                WHERE ordernumber = 'P180523124613876' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391485'
                WHERE ordernumber = 'P420523125123534' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319141'
                WHERE ordernumber = 'P200523125233622' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391487'
                WHERE ordernumber = 'P200523125501996' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283374'
                WHERE ordernumber = 'P180523125853264' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391490'
                WHERE ordernumber = 'P180523130225340' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391493'
                WHERE ordernumber = 'P180523130603445' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391491'
                WHERE ordernumber = 'P710523130656371' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391497'
                WHERE ordernumber = 'P180523131342845' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304427'
                WHERE ordernumber = 'P710523131533606' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238805'
                WHERE ordernumber = 'P200523133035192' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391500'
                WHERE ordernumber = 'P630523133331702' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391502'
                WHERE ordernumber = 'P420523133642416' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391501'
                WHERE ordernumber = 'P710523133839728' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '38020'
                WHERE ordernumber = 'P200523133851176' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337001'
                WHERE ordernumber = 'P420523134008463' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391503'
                WHERE ordernumber = 'P710523134106957' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391505'
                WHERE ordernumber = 'P180523134109619' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326900'
                WHERE ordernumber = 'P180523134159458' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391506'
                WHERE ordernumber = 'P200523134259733' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391427'
                WHERE ordernumber = 'P200523134434621' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391508'
                WHERE ordernumber = 'P710523134450364' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391509'
                WHERE ordernumber = 'P180523134549770' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391507'
                WHERE ordernumber = 'P790523134705204' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391511'
                WHERE ordernumber = 'P630523135007547' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391510'
                WHERE ordernumber = 'P710523135018612' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391512'
                WHERE ordernumber = 'P630523135248833' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324240'
                WHERE ordernumber = 'P200523140130599' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391514'
                WHERE ordernumber = 'P200523140459427' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391486'
                WHERE ordernumber = 'P630523140939551' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269827'
                WHERE ordernumber = 'P200523141229994' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120933'
                WHERE ordernumber = 'P200523141312981' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270632'
                WHERE ordernumber = 'P200523141359986' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391516'
                WHERE ordernumber = 'P710523141732208' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391518'
                WHERE ordernumber = 'P790523141840586' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391519'
                WHERE ordernumber = 'P190523142040272' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391515'
                WHERE ordernumber = 'P710523142156771' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '233576'
                WHERE ordernumber = 'P200523142537416' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391521'
                WHERE ordernumber = 'P790523142948969' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391525'
                WHERE ordernumber = 'P420523143438582' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391523'
                WHERE ordernumber = 'P790523143611938' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391524'
                WHERE ordernumber = 'P790523143954481' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391526'
                WHERE ordernumber = 'P200523144233282' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391527'
                WHERE ordernumber = 'P180523144307305' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180523144438926' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391529'
                WHERE ordernumber = 'P180523144651473' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342394'
                WHERE ordernumber = 'P420523145107447' 
            
2024-05-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391531'
                WHERE ordernumber = 'P180523145403659' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391530'
                WHERE ordernumber = 'P790523145419313' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391532'
                WHERE ordernumber = 'P200523145622760' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391534'
                WHERE ordernumber = 'P180523150053301' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391504'
                WHERE ordernumber = 'P630523151506605' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241214'
                WHERE ordernumber = 'P200523151620282' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391536'
                WHERE ordernumber = 'P790523151735837' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267800'
                WHERE ordernumber = 'P180523151836693' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318119'
                WHERE ordernumber = 'P200523151847737' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391520'
                WHERE ordernumber = 'P180523152240204' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97423'
                WHERE ordernumber = 'P180523152414414' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391540'
                WHERE ordernumber = 'P420523152832758' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391544'
                WHERE ordernumber = 'P420523153047348' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388931'
                WHERE ordernumber = 'P420523153203383' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391542'
                WHERE ordernumber = 'P790523153217214' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391546'
                WHERE ordernumber = 'P710523153421451' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353554'
                WHERE ordernumber = 'P190523153527811' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286337'
                WHERE ordernumber = 'P200523153758605' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356576'
                WHERE ordernumber = 'P190523153803628' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289954'
                WHERE ordernumber = 'P190523153958725' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391554'
                WHERE ordernumber = 'P190523154328771' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391555'
                WHERE ordernumber = 'P200523154531957' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391553'
                WHERE ordernumber = 'P710523154605821' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391559'
                WHERE ordernumber = 'P200523155256621' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391560'
                WHERE ordernumber = 'P180523155427188' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391561'
                WHERE ordernumber = 'P180523155617993' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391559'
                WHERE ordernumber = 'P200523160114265' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105394'
                WHERE ordernumber = 'P180523160300563' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374497'
                WHERE ordernumber = 'P710523160723991' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391565'
                WHERE ordernumber = 'P200523160912326' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391562'
                WHERE ordernumber = 'P790523160958672' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391566'
                WHERE ordernumber = 'P180523161004211' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391567'
                WHERE ordernumber = 'P200523161005450' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391569'
                WHERE ordernumber = 'P420523161823168' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391572'
                WHERE ordernumber = 'P200523161928496' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391571'
                WHERE ordernumber = 'P710523161957891' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277660'
                WHERE ordernumber = 'P200523162145945' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391573'
                WHERE ordernumber = 'P790523162349322' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391575'
                WHERE ordernumber = 'P180523162556225' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380535'
                WHERE ordernumber = 'P420523162809508' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391577'
                WHERE ordernumber = 'P630523162827620' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271328'
                WHERE ordernumber = 'P200523163156687' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391579'
                WHERE ordernumber = 'P180523163400400' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391580'
                WHERE ordernumber = 'P790523163739531' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382930'
                WHERE ordernumber = 'P180523163824458' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390187'
                WHERE ordernumber = 'P630523164152615' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '182682'
                WHERE ordernumber = 'P710523164525746' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391582'
                WHERE ordernumber = 'P630523164915216' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391583'
                WHERE ordernumber = 'P180523165043166' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391581'
                WHERE ordernumber = 'P790523165136843' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386982'
                WHERE ordernumber = 'P420523165744309' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391584'
                WHERE ordernumber = 'P180523165954808' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121061'
                WHERE ordernumber = 'P790523170036843' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391585'
                WHERE ordernumber = 'P180523170305882' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381854'
                WHERE ordernumber = 'P200523170314782' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369358'
                WHERE ordernumber = 'P420523170700581' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391586'
                WHERE ordernumber = 'P710523171009404' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391587'
                WHERE ordernumber = 'P790523171340894' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99837'
                WHERE ordernumber = 'P710523171507453' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94980'
                WHERE ordernumber = 'P180523171635168' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391588'
                WHERE ordernumber = 'P630523172008256' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337679'
                WHERE ordernumber = 'P710523172015375' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391590'
                WHERE ordernumber = 'P630523172556161' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155543'
                WHERE ordernumber = 'P200523172610315' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391593'
                WHERE ordernumber = 'P420523172926311' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135593'
                WHERE ordernumber = 'P420523173019360' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391594'
                WHERE ordernumber = 'P200523173057669' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276893'
                WHERE ordernumber = 'P180523173403332' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391595'
                WHERE ordernumber = 'P200523173431655' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379525'
                WHERE ordernumber = 'P190523173535148' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391596'
                WHERE ordernumber = 'P200523173618636' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391597'
                WHERE ordernumber = 'P180523173644352' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258516'
                WHERE ordernumber = 'P200523173702815' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102241'
                WHERE ordernumber = 'P180523174000868' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391598'
                WHERE ordernumber = 'P180523174157812' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211344'
                WHERE ordernumber = 'P180523174529401' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330285'
                WHERE ordernumber = 'P200523174532209' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156524'
                WHERE ordernumber = 'P180523174611332' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388093'
                WHERE ordernumber = 'P200523174721123' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391599'
                WHERE ordernumber = 'P710523174759577' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391602'
                WHERE ordernumber = 'P710523175610146' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391603'
                WHERE ordernumber = 'P420523175637332' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391601'
                WHERE ordernumber = 'P630523175811651' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229979'
                WHERE ordernumber = 'P190523175949663' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391606'
                WHERE ordernumber = 'P710523180458662' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391607'
                WHERE ordernumber = 'P200523180751139' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391608'
                WHERE ordernumber = 'P180523181217235' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133909'
                WHERE ordernumber = 'P180523181504887' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261089'
                WHERE ordernumber = 'P630523181725930' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391609'
                WHERE ordernumber = 'P420523181812982' 
            
2024-05-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257521'
                WHERE ordernumber = 'P180523182040918' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391604'
                WHERE ordernumber = 'P200523182232503' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365876'
                WHERE ordernumber = 'P420523182434420' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391610'
                WHERE ordernumber = 'P790523182638446' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391613'
                WHERE ordernumber = 'P180523182737518' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P180523182917605' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391614'
                WHERE ordernumber = 'P180523183308315' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390531'
                WHERE ordernumber = 'P420523183827583' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391615'
                WHERE ordernumber = 'P790523183917693' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391616'
                WHERE ordernumber = 'P420523184339268' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391617'
                WHERE ordernumber = 'P200523184405671' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391617'
                WHERE ordernumber = 'P200523184514786' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270147'
                WHERE ordernumber = 'P200523185156808' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137495'
                WHERE ordernumber = 'P200523185309705' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162684'
                WHERE ordernumber = 'P420523185512943' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391618'
                WHERE ordernumber = 'P190523185723497' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391620'
                WHERE ordernumber = 'P420523190058875' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391423'
                WHERE ordernumber = 'P190523190130344' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152259'
                WHERE ordernumber = 'P190523190654678' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388897'
                WHERE ordernumber = 'P190523191036553' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391623'
                WHERE ordernumber = 'P710523191049227' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391624'
                WHERE ordernumber = 'P190523191343717' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '1116'
                WHERE ordernumber = 'P190523191757578' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106743'
                WHERE ordernumber = 'P190523191918634' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391626'
                WHERE ordernumber = 'P200523191959638' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391625'
                WHERE ordernumber = 'P790523192018165' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253946'
                WHERE ordernumber = 'P190523192043767' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369014'
                WHERE ordernumber = 'P190523192324186' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249398'
                WHERE ordernumber = 'P190523192443647' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391622'
                WHERE ordernumber = 'P710523192539553' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370695'
                WHERE ordernumber = 'P710523193209537' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241198'
                WHERE ordernumber = 'P200523193243957' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306620'
                WHERE ordernumber = 'P190523193250946' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102296'
                WHERE ordernumber = 'P190523193558400' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95975'
                WHERE ordernumber = 'P200523193955599' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391627'
                WHERE ordernumber = 'P190523194215839' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279068'
                WHERE ordernumber = 'P200523194218977' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391629'
                WHERE ordernumber = 'P710523194418867' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391630'
                WHERE ordernumber = 'P190523194450882' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '184980'
                WHERE ordernumber = 'P190523194722349' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100936'
                WHERE ordernumber = 'P190523194850765' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391628'
                WHERE ordernumber = 'P710523195225431' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276776'
                WHERE ordernumber = 'P190523195423989' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391631'
                WHERE ordernumber = 'P790523200336995' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391634'
                WHERE ordernumber = 'P790523203417734' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391635'
                WHERE ordernumber = 'P790523203858739' 
            
2024-05-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131276'
                WHERE ordernumber = 'P710523213632149'