2024-05-18 01:00:01 -- 將會員中心id寫入data-lake
2024-05-18 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-17%';
        
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112335'
                WHERE ordernumber = 'P190517110158571' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390356'
                WHERE ordernumber = 'P200517110642848' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87078'
                WHERE ordernumber = 'P180517110815560' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293946'
                WHERE ordernumber = 'P190517110910153' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389761'
                WHERE ordernumber = 'P180517111136160' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390357'
                WHERE ordernumber = 'P190517111233468' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390358'
                WHERE ordernumber = 'P200517111243679' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311788'
                WHERE ordernumber = 'P190517111626301' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390203'
                WHERE ordernumber = 'P180517111651178' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94231'
                WHERE ordernumber = 'P200517111730583' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345881'
                WHERE ordernumber = 'P200517111839538' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345881'
                WHERE ordernumber = 'P200517111925513' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390359'
                WHERE ordernumber = 'P180517111946707' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390360'
                WHERE ordernumber = 'P420517112229331' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378054'
                WHERE ordernumber = 'P200517112232761' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209575'
                WHERE ordernumber = 'P180517112242452' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386971'
                WHERE ordernumber = 'P420517112441969' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389122'
                WHERE ordernumber = 'P180517112615581' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385942'
                WHERE ordernumber = 'P200517112854790' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390361'
                WHERE ordernumber = 'P190517112953488' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390362'
                WHERE ordernumber = 'P190517113229503' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389257'
                WHERE ordernumber = 'P190517113542180' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390364'
                WHERE ordernumber = 'P180517113811494' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390364'
                WHERE ordernumber = 'P180517113934427' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390365'
                WHERE ordernumber = 'P200517113947973' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266373'
                WHERE ordernumber = 'P200517114042926' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390366'
                WHERE ordernumber = 'P190517114110139' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390368'
                WHERE ordernumber = 'P180517114328403' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286124'
                WHERE ordernumber = 'P180517114451473' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231065'
                WHERE ordernumber = 'P200517114905689' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216595'
                WHERE ordernumber = 'P200517115028954' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390373'
                WHERE ordernumber = 'P180517115851501' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390374'
                WHERE ordernumber = 'P420517115907848' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200517120530245' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390376'
                WHERE ordernumber = 'P180517120555503' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390377'
                WHERE ordernumber = 'P200517120659167' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390380'
                WHERE ordernumber = 'P200517121016757' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390352'
                WHERE ordernumber = 'P420517121122183' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342844'
                WHERE ordernumber = 'P420517121514959' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390381'
                WHERE ordernumber = 'P420517121637311' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94072'
                WHERE ordernumber = 'P200517121829603' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283778'
                WHERE ordernumber = 'P180517122323676' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390384'
                WHERE ordernumber = 'P200517122348266' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390382'
                WHERE ordernumber = 'P180517122514382' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390383'
                WHERE ordernumber = 'P180517122631306' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390382'
                WHERE ordernumber = 'P180517122907420' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390379'
                WHERE ordernumber = 'P180517123108118' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373036'
                WHERE ordernumber = 'P180517123254279' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340077'
                WHERE ordernumber = 'P180517123425985' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322183'
                WHERE ordernumber = 'P180517123557473' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279538'
                WHERE ordernumber = 'P200517123935299' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380483'
                WHERE ordernumber = 'P420517124113444' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390387'
                WHERE ordernumber = 'P420517124536911' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343378'
                WHERE ordernumber = 'P180517124643177' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168328'
                WHERE ordernumber = 'P630517124701540' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373133'
                WHERE ordernumber = 'P420517124717513' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341818'
                WHERE ordernumber = 'P180517124839703' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '41125'
                WHERE ordernumber = 'P180517124956627' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '68736'
                WHERE ordernumber = 'P630517125056614' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390389'
                WHERE ordernumber = 'P200517125205390' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390390'
                WHERE ordernumber = 'P180517125653765' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390388'
                WHERE ordernumber = 'P180517130032595' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99720'
                WHERE ordernumber = 'P190517130403160' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385074'
                WHERE ordernumber = 'P180517130418806' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259089'
                WHERE ordernumber = 'P180517130525685' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390391'
                WHERE ordernumber = 'P420517130630992' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133744'
                WHERE ordernumber = 'P200517131431221' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100060'
                WHERE ordernumber = 'P190517131630891' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94460'
                WHERE ordernumber = 'P200517131840688' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390395'
                WHERE ordernumber = 'P630517132058129' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390396'
                WHERE ordernumber = 'P180517132147797' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135102'
                WHERE ordernumber = 'P200517132225999' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390397'
                WHERE ordernumber = 'P200517132444890' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390398'
                WHERE ordernumber = 'P790517132941974' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390399'
                WHERE ordernumber = 'P180517133046160' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390392'
                WHERE ordernumber = 'P630517133153764' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390400'
                WHERE ordernumber = 'P630517133313684' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390401'
                WHERE ordernumber = 'P200517133420388' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390402'
                WHERE ordernumber = 'P420517133647450' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '176811'
                WHERE ordernumber = 'P790517133842672' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390404'
                WHERE ordernumber = 'P180517134019167' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235164'
                WHERE ordernumber = 'P200517134031818' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390405'
                WHERE ordernumber = 'P190517134032619' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390403'
                WHERE ordernumber = 'P790517134357217' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390407'
                WHERE ordernumber = 'P630517134522168' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390408'
                WHERE ordernumber = 'P180517135131181' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390409'
                WHERE ordernumber = 'P180517135244514' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378465'
                WHERE ordernumber = 'P200517135722250' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390370'
                WHERE ordernumber = 'P180517135837836' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390370'
                WHERE ordernumber = 'P180517135901686' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390411'
                WHERE ordernumber = 'P420517135955278' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390409'
                WHERE ordernumber = 'P180517140031595' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279567'
                WHERE ordernumber = 'P190517140048314' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390410'
                WHERE ordernumber = 'P180517140145574' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390412'
                WHERE ordernumber = 'P190517140219835' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390413'
                WHERE ordernumber = 'P180517140637989' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390415'
                WHERE ordernumber = 'P200517140837289' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390416'
                WHERE ordernumber = 'P180517140947385' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390417'
                WHERE ordernumber = 'P200517141120709' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312498'
                WHERE ordernumber = 'P180517141244377' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '171838'
                WHERE ordernumber = 'P790517141440689' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390418'
                WHERE ordernumber = 'P180517141530160' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94004'
                WHERE ordernumber = 'P200517141949697' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390336'
                WHERE ordernumber = 'P180517142051559' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350182'
                WHERE ordernumber = 'P790517142057287' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224348'
                WHERE ordernumber = 'P190517142109504' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '177053'
                WHERE ordernumber = 'P420517142154792' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220938'
                WHERE ordernumber = 'P200517142234462' 
            
2024-05-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390420'
                WHERE ordernumber = 'P200517142516591' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310904'
                WHERE ordernumber = 'P420517142632807' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390421'
                WHERE ordernumber = 'P180517142854705' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390422'
                WHERE ordernumber = 'P790517142903774' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '151148'
                WHERE ordernumber = 'P200517143247894' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390423'
                WHERE ordernumber = 'P180517143332665' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147379'
                WHERE ordernumber = 'P200517143338893' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390424'
                WHERE ordernumber = 'P200517143407648' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253739'
                WHERE ordernumber = 'P180517143510913' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253739'
                WHERE ordernumber = 'P180517143547637' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390425'
                WHERE ordernumber = 'P790517143926743' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P710517144125522' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390429'
                WHERE ordernumber = 'P180517144402929' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P180517144508466' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P180517144551340' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390427'
                WHERE ordernumber = 'P790517144614134' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389513'
                WHERE ordernumber = 'P420517144805850' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390431'
                WHERE ordernumber = 'P200517144913682' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390430'
                WHERE ordernumber = 'P790517144944979' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236193'
                WHERE ordernumber = 'P180517145137450' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342005'
                WHERE ordernumber = 'P420517145347369' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390432'
                WHERE ordernumber = 'P190517145522419' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390433'
                WHERE ordernumber = 'P180517145551539' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367207'
                WHERE ordernumber = 'P190517145622555' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390434'
                WHERE ordernumber = 'P180517145844615' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389935'
                WHERE ordernumber = 'P200517150225245' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390435'
                WHERE ordernumber = 'P180517150247314' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379520'
                WHERE ordernumber = 'P180517150738748' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390436'
                WHERE ordernumber = 'P420517151051274' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390437'
                WHERE ordernumber = 'P180517151109195' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280910'
                WHERE ordernumber = 'P200517151146584' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95826'
                WHERE ordernumber = 'P180517151222361' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390439'
                WHERE ordernumber = 'P420517151600302' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279885'
                WHERE ordernumber = 'P200517151741174' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279885'
                WHERE ordernumber = 'P200517152112176' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390441'
                WHERE ordernumber = 'P180517152322681' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390442'
                WHERE ordernumber = 'P180517152626776' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390443'
                WHERE ordernumber = 'P180517152907973' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '189938'
                WHERE ordernumber = 'P200517153132771' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390445'
                WHERE ordernumber = 'P630517153948297' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390446'
                WHERE ordernumber = 'P200517154104253' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308951'
                WHERE ordernumber = 'P200517154208277' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357970'
                WHERE ordernumber = 'P200517154453806' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377501'
                WHERE ordernumber = 'P200517154612545' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390444'
                WHERE ordernumber = 'P790517154741157' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389189'
                WHERE ordernumber = 'P180517155035782' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319431'
                WHERE ordernumber = 'P180517155224641' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390449'
                WHERE ordernumber = 'P190517155349192' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253183'
                WHERE ordernumber = 'P630517155756859' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376402'
                WHERE ordernumber = 'P180517160125201' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390450'
                WHERE ordernumber = 'P200517160335529' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390451'
                WHERE ordernumber = 'P180517161154794' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390453'
                WHERE ordernumber = 'P630517161620934' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387118'
                WHERE ordernumber = 'P420517161649981' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390454'
                WHERE ordernumber = 'P180517162014756' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390457'
                WHERE ordernumber = 'P180517162213553' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390455'
                WHERE ordernumber = 'P190517162351114' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377429'
                WHERE ordernumber = 'P200517162507178' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390460'
                WHERE ordernumber = 'P200517162627914' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390461'
                WHERE ordernumber = 'P180517162647782' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390459'
                WHERE ordernumber = 'P790517162831917' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390462'
                WHERE ordernumber = 'P180517162844868' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390464'
                WHERE ordernumber = 'P190517163020965' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289358'
                WHERE ordernumber = 'P200517163400172' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390465'
                WHERE ordernumber = 'P180517163444940' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390467'
                WHERE ordernumber = 'P200517163518380' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275674'
                WHERE ordernumber = 'P190517163553267' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101144'
                WHERE ordernumber = 'P200517163651690' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390468'
                WHERE ordernumber = 'P180517163653893' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390469'
                WHERE ordernumber = 'P190517163753676' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388794'
                WHERE ordernumber = 'P180517163936494' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388794'
                WHERE ordernumber = 'P180517163952260' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390470'
                WHERE ordernumber = 'P180517164259808' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P710517165152814' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315758'
                WHERE ordernumber = 'P420517165237146' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111738'
                WHERE ordernumber = 'P180517165503379' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390471'
                WHERE ordernumber = 'P190517165528244' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P710517165533234' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390472'
                WHERE ordernumber = 'P200517165722688' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390473'
                WHERE ordernumber = 'P180517165909838' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288448'
                WHERE ordernumber = 'P180517170040567' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301963'
                WHERE ordernumber = 'P180517170338883' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273823'
                WHERE ordernumber = 'P420517170354814' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390474'
                WHERE ordernumber = 'P180517170742330' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314886'
                WHERE ordernumber = 'P190517170814598' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225010'
                WHERE ordernumber = 'P200517171221702' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390475'
                WHERE ordernumber = 'P180517171255315' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390476'
                WHERE ordernumber = 'P190517171347340' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118999'
                WHERE ordernumber = 'P200517171541779' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112676'
                WHERE ordernumber = 'P180517171702920' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390477'
                WHERE ordernumber = 'P420517171827483' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268773'
                WHERE ordernumber = 'P420517172056724' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140855'
                WHERE ordernumber = 'P180517172359823' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313813'
                WHERE ordernumber = 'P200517172430669' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244758'
                WHERE ordernumber = 'P180517172708565' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390478'
                WHERE ordernumber = 'P790517172741832' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289833'
                WHERE ordernumber = 'P200517172819919' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390479'
                WHERE ordernumber = 'P180517173013159' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319132'
                WHERE ordernumber = 'P180517173622940' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390481'
                WHERE ordernumber = 'P180517173851910' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158748'
                WHERE ordernumber = 'P200517174026217' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245369'
                WHERE ordernumber = 'P200517174135360' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390483'
                WHERE ordernumber = 'P180517174519507' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390482'
                WHERE ordernumber = 'P790517174809437' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226172'
                WHERE ordernumber = 'P200517174851609' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212523'
                WHERE ordernumber = 'P180517174917819' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390484'
                WHERE ordernumber = 'P180517175035606' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244744'
                WHERE ordernumber = 'P180517175150545' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390485'
                WHERE ordernumber = 'P180517175248680' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240225'
                WHERE ordernumber = 'P190517175602295' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256530'
                WHERE ordernumber = 'P180517175636864' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390486'
                WHERE ordernumber = 'P200517180220891' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318238'
                WHERE ordernumber = 'P180517180322150' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390489'
                WHERE ordernumber = 'P420517180741954' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390490'
                WHERE ordernumber = 'P420517180849970' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351276'
                WHERE ordernumber = 'P630517181408428' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249752'
                WHERE ordernumber = 'P180517182037654' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274721'
                WHERE ordernumber = 'P180517182209735' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390491'
                WHERE ordernumber = 'P200517182328363' 
            
2024-05-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384371'
                WHERE ordernumber = 'P180517183205866' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390492'
                WHERE ordernumber = 'P420517183552379' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379036'
                WHERE ordernumber = 'P420517183634282' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390493'
                WHERE ordernumber = 'P190517184548550' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344253'
                WHERE ordernumber = 'P190517184711204' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343874'
                WHERE ordernumber = 'P190517184846545' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390494'
                WHERE ordernumber = 'P190517185009466' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382708'
                WHERE ordernumber = 'P190517185132357' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281366'
                WHERE ordernumber = 'P190517185640426' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156328'
                WHERE ordernumber = 'P190517185801815' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238186'
                WHERE ordernumber = 'P200517185857385' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249555'
                WHERE ordernumber = 'P190517190217451' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388685'
                WHERE ordernumber = 'P790517190418117' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390495'
                WHERE ordernumber = 'P190517191005566' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224422'
                WHERE ordernumber = 'P200517191042302' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390496'
                WHERE ordernumber = 'P200517191527843' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390497'
                WHERE ordernumber = 'P630517191625994' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390498'
                WHERE ordernumber = 'P200517191906494' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390500'
                WHERE ordernumber = 'P630517192021791' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291916'
                WHERE ordernumber = 'P200517192030857' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390499'
                WHERE ordernumber = 'P200517192252321' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345795'
                WHERE ordernumber = 'P190517192353361' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284931'
                WHERE ordernumber = 'P200517192412233' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345795'
                WHERE ordernumber = 'P190517192502883' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390503'
                WHERE ordernumber = 'P790517192637915' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125233'
                WHERE ordernumber = 'P190517192644245' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93266'
                WHERE ordernumber = 'P190517192740514' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390504'
                WHERE ordernumber = 'P200517192947728' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357562'
                WHERE ordernumber = 'P190517193054204' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390505'
                WHERE ordernumber = 'P420517193149624' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388183'
                WHERE ordernumber = 'P790517193243438' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108369'
                WHERE ordernumber = 'P200517193335146' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385099'
                WHERE ordernumber = 'P200517193453265' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108272'
                WHERE ordernumber = 'P190517195039835' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390506'
                WHERE ordernumber = 'P630517195239674' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390507'
                WHERE ordernumber = 'P190517195340460' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390509'
                WHERE ordernumber = 'P200517195659159' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390510'
                WHERE ordernumber = 'P790517200250456' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390508'
                WHERE ordernumber = 'P630517201430981' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390511'
                WHERE ordernumber = 'P630517202738240' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385328'
                WHERE ordernumber = 'P630517203711114' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390513'
                WHERE ordernumber = 'P790517204234936' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390517'
                WHERE ordernumber = 'P790517212053135' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '58075'
                WHERE ordernumber = 'P630517212426125' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346893'
                WHERE ordernumber = 'P630517212753655' 
            
2024-05-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390519'
                WHERE ordernumber = 'P790517213108296'