2023-12-11 01:00:03 -- 將會員中心id寫入data-lake
2023-12-11 01:00:03 -- 
            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 '2023-12-10%';
        
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341965'
                WHERE ordernumber = 'P181210110659774' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209310'
                WHERE ordernumber = 'P181210110855640' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263922'
                WHERE ordernumber = 'P201210110914281' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351628'
                WHERE ordernumber = 'P201210111037596' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351629'
                WHERE ordernumber = 'P181210111136708' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246436'
                WHERE ordernumber = 'P191210111423896' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351631'
                WHERE ordernumber = 'P181210111447519' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351630'
                WHERE ordernumber = 'P181210111654503' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96007'
                WHERE ordernumber = 'P191210111931524' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351632'
                WHERE ordernumber = 'P181210111952869' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351633'
                WHERE ordernumber = 'P191210112132577' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351634'
                WHERE ordernumber = 'P201210112424756' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118846'
                WHERE ordernumber = 'P201210112635609' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351635'
                WHERE ordernumber = 'P181210112835830' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351636'
                WHERE ordernumber = 'P201210113715911' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350524'
                WHERE ordernumber = 'P181210114349733' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289379'
                WHERE ordernumber = 'P181210114543641' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351637'
                WHERE ordernumber = 'P181210114717336' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351638'
                WHERE ordernumber = 'P181210114842194' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351639'
                WHERE ordernumber = 'P181210114951284' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299626'
                WHERE ordernumber = 'P201210115344157' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223216'
                WHERE ordernumber = 'P181210115407252' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124369'
                WHERE ordernumber = 'P181210115803796' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351641'
                WHERE ordernumber = 'P181210120556535' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133976'
                WHERE ordernumber = 'P181210120654725' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128214'
                WHERE ordernumber = 'P181210120739766' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321917'
                WHERE ordernumber = 'P181210120926568' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291019'
                WHERE ordernumber = 'P421210121112550' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93670'
                WHERE ordernumber = 'P201210121202704' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229251'
                WHERE ordernumber = 'P181210121312952' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312893'
                WHERE ordernumber = 'P181210121449168' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340061'
                WHERE ordernumber = 'P421210123018664' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351644'
                WHERE ordernumber = 'P421210123128823' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351645'
                WHERE ordernumber = 'P181210123221778' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349380'
                WHERE ordernumber = 'P181210123351314' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131913'
                WHERE ordernumber = 'P181210123659556' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107559'
                WHERE ordernumber = 'P181210124012640' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287971'
                WHERE ordernumber = 'P181210124105739' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351649'
                WHERE ordernumber = 'P181210125101625' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163259'
                WHERE ordernumber = 'P201210130634555' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351651'
                WHERE ordernumber = 'P201210130925759' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '77805'
                WHERE ordernumber = 'P181210130959460' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351650'
                WHERE ordernumber = 'P181210131352162' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102881'
                WHERE ordernumber = 'P201210131810206' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351650'
                WHERE ordernumber = 'P181210131820720' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342885'
                WHERE ordernumber = 'P421210132309950' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351653'
                WHERE ordernumber = 'P421210132401461' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351654'
                WHERE ordernumber = 'P181210132423814' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351655'
                WHERE ordernumber = 'P181210132745546' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346606'
                WHERE ordernumber = 'P181210133157398' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351658'
                WHERE ordernumber = 'P421210133317349' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97170'
                WHERE ordernumber = 'P181210133320186' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351661'
                WHERE ordernumber = 'P181210133901875' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351661'
                WHERE ordernumber = 'P181210133932249' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351662'
                WHERE ordernumber = 'P201210133945691' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114142'
                WHERE ordernumber = 'P181210134050135' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114142'
                WHERE ordernumber = 'P181210134138355' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343594'
                WHERE ordernumber = 'P421210134227192' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351663'
                WHERE ordernumber = 'P421210134753478' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351664'
                WHERE ordernumber = 'P201210134808432' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348535'
                WHERE ordernumber = 'P181210134832186' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351665'
                WHERE ordernumber = 'P201210135319730' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133035'
                WHERE ordernumber = 'P181210135556113' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336069'
                WHERE ordernumber = 'P181210135710508' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P201210140315786' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346440'
                WHERE ordernumber = 'P201210141004242' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275056'
                WHERE ordernumber = 'P181210141142569' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351668'
                WHERE ordernumber = 'P201210141214446' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351669'
                WHERE ordernumber = 'P201210142243718' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351669'
                WHERE ordernumber = 'P201210142303204' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351670'
                WHERE ordernumber = 'P181210142328434' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214958'
                WHERE ordernumber = 'P201210142438921' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351671'
                WHERE ordernumber = 'P201210142542422' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343787'
                WHERE ordernumber = 'P181210142546502' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222289'
                WHERE ordernumber = 'P201210142657566' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351673'
                WHERE ordernumber = 'P181210142715406' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351674'
                WHERE ordernumber = 'P201210142753278' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245538'
                WHERE ordernumber = 'P181210142821710' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351675'
                WHERE ordernumber = 'P181210142918967' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239082'
                WHERE ordernumber = 'P421210143215203' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351676'
                WHERE ordernumber = 'P181210143243527' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277808'
                WHERE ordernumber = 'P201210143518390' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351677'
                WHERE ordernumber = 'P181210143641704' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351678'
                WHERE ordernumber = 'P201210143812489' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351680'
                WHERE ordernumber = 'P201210143848719' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351679'
                WHERE ordernumber = 'P181210144019970' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351681'
                WHERE ordernumber = 'P181210144115702' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209952'
                WHERE ordernumber = 'P181210144245125' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334823'
                WHERE ordernumber = 'P181210144330953' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250050'
                WHERE ordernumber = 'P201210144353493' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351682'
                WHERE ordernumber = 'P181210145048245' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351683'
                WHERE ordernumber = 'P201210145659790' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351684'
                WHERE ordernumber = 'P181210145734698' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351685'
                WHERE ordernumber = 'P201210145750279' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351686'
                WHERE ordernumber = 'P181210145854456' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100687'
                WHERE ordernumber = 'P181210145932234' 
            
2023-12-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97255'
                WHERE ordernumber = 'P201210150022696' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351687'
                WHERE ordernumber = 'P181210150108899' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214200'
                WHERE ordernumber = 'P201210150145285' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '80194'
                WHERE ordernumber = 'P201210150406851' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342482'
                WHERE ordernumber = 'P201210150558553' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351690'
                WHERE ordernumber = 'P421210150622775' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351693'
                WHERE ordernumber = 'P191210151010986' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351692'
                WHERE ordernumber = 'P181210151014886' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343742'
                WHERE ordernumber = 'P201210151119840' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351694'
                WHERE ordernumber = 'P181210151647134' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '224338'
                WHERE ordernumber = 'P191210151912526' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220017'
                WHERE ordernumber = 'P191210151959469' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351688'
                WHERE ordernumber = 'P181210152013175' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351688'
                WHERE ordernumber = 'P181210152051497' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351696'
                WHERE ordernumber = 'P421210152237270' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351697'
                WHERE ordernumber = 'P421210152339747' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351698'
                WHERE ordernumber = 'P421210152551784' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226393'
                WHERE ordernumber = 'P181210152711558' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299702'
                WHERE ordernumber = 'P421210152733162' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306269'
                WHERE ordernumber = 'P201210152836458' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229212'
                WHERE ordernumber = 'P181210152854119' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351699'
                WHERE ordernumber = 'P181210153152597' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267697'
                WHERE ordernumber = 'P201210153321853' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241752'
                WHERE ordernumber = 'P201210153449517' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266791'
                WHERE ordernumber = 'P421210153652517' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351700'
                WHERE ordernumber = 'P421210153718759' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351701'
                WHERE ordernumber = 'P201210153954727' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173552'
                WHERE ordernumber = 'P181210154253584' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '40782'
                WHERE ordernumber = 'P181210154824314' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351705'
                WHERE ordernumber = 'P191210154849199' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '107469'
                WHERE ordernumber = 'P181210154916609' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242666'
                WHERE ordernumber = 'P191210155442907' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P191210155633975' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173552'
                WHERE ordernumber = 'P181210155848300' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351709'
                WHERE ordernumber = 'P201210160343366' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128993'
                WHERE ordernumber = 'P181210160427831' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P181210160514754' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351647'
                WHERE ordernumber = 'P181210160629675' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351647'
                WHERE ordernumber = 'P181210160709278' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351711'
                WHERE ordernumber = 'P181210160830863' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351712'
                WHERE ordernumber = 'P181210161225223' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351710'
                WHERE ordernumber = 'P201210161347302' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351713'
                WHERE ordernumber = 'P181210161349557' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351714'
                WHERE ordernumber = 'P181210161713856' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273330'
                WHERE ordernumber = 'P201210161812113' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239591'
                WHERE ordernumber = 'P181210161830444' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351716'
                WHERE ordernumber = 'P201210161931181' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340315'
                WHERE ordernumber = 'P201210162438916' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101828'
                WHERE ordernumber = 'P201210162853126' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343418'
                WHERE ordernumber = 'P421210163133743' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351718'
                WHERE ordernumber = 'P201210163331466' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351720'
                WHERE ordernumber = 'P201210163557713' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281863'
                WHERE ordernumber = 'P181210163818121' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281084'
                WHERE ordernumber = 'P201210163820380' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340529'
                WHERE ordernumber = 'P201210164242415' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351724'
                WHERE ordernumber = 'P201210164414605' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347516'
                WHERE ordernumber = 'P181210164448287' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292172'
                WHERE ordernumber = 'P201210165011836' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351725'
                WHERE ordernumber = 'P181210165206121' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351726'
                WHERE ordernumber = 'P201210165420668' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270762'
                WHERE ordernumber = 'P181210165526219' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212950'
                WHERE ordernumber = 'P201210165631642' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295092'
                WHERE ordernumber = 'P181210165726720' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212950'
                WHERE ordernumber = 'P201210165809431' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339912'
                WHERE ordernumber = 'P421210165929576' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351729'
                WHERE ordernumber = 'P181210170239387' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351727'
                WHERE ordernumber = 'P181210170420673' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343936'
                WHERE ordernumber = 'P201210170421829' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '144128'
                WHERE ordernumber = 'P181210170517195' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351731'
                WHERE ordernumber = 'P201210170724518' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351732'
                WHERE ordernumber = 'P181210170741975' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103196'
                WHERE ordernumber = 'P181210171352823' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '112329'
                WHERE ordernumber = 'P181210171536593' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127611'
                WHERE ordernumber = 'P181210172024341' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350648'
                WHERE ordernumber = 'P201210172616139' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312190'
                WHERE ordernumber = 'P181210173027199' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351736'
                WHERE ordernumber = 'P181210173218430' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351737'
                WHERE ordernumber = 'P181210173409709' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351738'
                WHERE ordernumber = 'P201210173445475' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351739'
                WHERE ordernumber = 'P181210173526364' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283600'
                WHERE ordernumber = 'P181210174302842' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341905'
                WHERE ordernumber = 'P181210174407182' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351741'
                WHERE ordernumber = 'P181210174656678' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351743'
                WHERE ordernumber = 'P181210175043973' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339940'
                WHERE ordernumber = 'P201210175217408' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102428'
                WHERE ordernumber = 'P181210175332892' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351744'
                WHERE ordernumber = 'P181210175728640' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351746'
                WHERE ordernumber = 'P201210175946374' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351745'
                WHERE ordernumber = 'P181210175954329' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347644'
                WHERE ordernumber = 'P201210180111606' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '181707'
                WHERE ordernumber = 'P201210180246954' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '261980'
                WHERE ordernumber = 'P201210180602500' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351747'
                WHERE ordernumber = 'P181210180750171' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351749'
                WHERE ordernumber = 'P181210180939781' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253722'
                WHERE ordernumber = 'P201210181028794' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351750'
                WHERE ordernumber = 'P181210181111986' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351752'
                WHERE ordernumber = 'P181210181757684' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62662'
                WHERE ordernumber = 'P201210181842661' 
            
2023-12-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351753'
                WHERE ordernumber = 'P201210182014831' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '323173'
                WHERE ordernumber = 'P201210182106952' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '139260'
                WHERE ordernumber = 'P201210182158915' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351754'
                WHERE ordernumber = 'P421210182412529' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351755'
                WHERE ordernumber = 'P201210182539623' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '344160'
                WHERE ordernumber = 'P421210182554211' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '134258'
                WHERE ordernumber = 'P181210182554465' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351757'
                WHERE ordernumber = 'P181210183314598' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351759'
                WHERE ordernumber = 'P181210183423975' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351760'
                WHERE ordernumber = 'P181210183524735' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351761'
                WHERE ordernumber = 'P181210184458254' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351762'
                WHERE ordernumber = 'P181210184614410' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351763'
                WHERE ordernumber = 'P201210184839257' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '320707'
                WHERE ordernumber = 'P201210185130439' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '62662'
                WHERE ordernumber = 'P201210185652421' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '288768'
                WHERE ordernumber = 'P421210185725526' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351764'
                WHERE ordernumber = 'P201210185941330' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '283717'
                WHERE ordernumber = 'P191210190017140' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '337894'
                WHERE ordernumber = 'P201210190355703' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '269670'
                WHERE ordernumber = 'P201210190623406' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351765'
                WHERE ordernumber = 'P201210190828254' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351766'
                WHERE ordernumber = 'P191210190839114' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '284931'
                WHERE ordernumber = 'P201210191139498' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351768'
                WHERE ordernumber = 'P421210191304990' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351769'
                WHERE ordernumber = 'P421210191410147' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351770'
                WHERE ordernumber = 'P421210191458809' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '109877'
                WHERE ordernumber = 'P201210192823145' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351772'
                WHERE ordernumber = 'P191210193531393' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351613'
                WHERE ordernumber = 'P421210193952915' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351773'
                WHERE ordernumber = 'P201210194015473' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '213453'
                WHERE ordernumber = 'P191210194105146' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351774'
                WHERE ordernumber = 'P201210194125706' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '303042'
                WHERE ordernumber = 'P191210195019539' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '303042'
                WHERE ordernumber = 'P191210195150626' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '213581'
                WHERE ordernumber = 'P191210195242880' 
            
2023-12-11 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351776'
                WHERE ordernumber = 'P201210195715246'