2024-10-19 01:00:02 -- 將會員中心id寫入data-lake
2024-10-19 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-10-18%';
        
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113474'
                WHERE ordernumber = 'P631018104745313' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113474'
                WHERE ordernumber = 'P631018105037445' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426004'
                WHERE ordernumber = 'P631018105957976' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94231'
                WHERE ordernumber = 'P201018110032900' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P421018110140358' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201018110142719' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426426'
                WHERE ordernumber = 'P201018110300545' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247930'
                WHERE ordernumber = 'P181018110413249' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426427'
                WHERE ordernumber = 'P201018110520499' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119225'
                WHERE ordernumber = 'P181018110603276' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P181018110730832' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241865'
                WHERE ordernumber = 'P201018111018391' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426429'
                WHERE ordernumber = 'P181018111356445' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339857'
                WHERE ordernumber = 'P421018111420980' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171583'
                WHERE ordernumber = 'P181018111632924' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P201018111835883' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359042'
                WHERE ordernumber = 'P181018112022366' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324801'
                WHERE ordernumber = 'P181018112318301' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324801'
                WHERE ordernumber = 'P181018112736244' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418269'
                WHERE ordernumber = 'P421018112818406' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324801'
                WHERE ordernumber = 'P181018113010624' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426430'
                WHERE ordernumber = 'P421018113141897' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282036'
                WHERE ordernumber = 'P201018113156865' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376684'
                WHERE ordernumber = 'P181018113332431' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426432'
                WHERE ordernumber = 'P201018113910632' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426433'
                WHERE ordernumber = 'P181018114348790' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241434'
                WHERE ordernumber = 'P181018114451978' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382280'
                WHERE ordernumber = 'P421018114653973' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426434'
                WHERE ordernumber = 'P421018114822597' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425918'
                WHERE ordernumber = 'P181018115047700' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426435'
                WHERE ordernumber = 'P421018115219906' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426436'
                WHERE ordernumber = 'P421018115422823' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206407'
                WHERE ordernumber = 'P181018115718866' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288440'
                WHERE ordernumber = 'P201018120024654' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426437'
                WHERE ordernumber = 'P421018120041963' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399807'
                WHERE ordernumber = 'P631018120818620' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279802'
                WHERE ordernumber = 'P201018120922302' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217198'
                WHERE ordernumber = 'P181018121222320' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426438'
                WHERE ordernumber = 'P771018121437757' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246112'
                WHERE ordernumber = 'P181018121829179' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253683'
                WHERE ordernumber = 'P201018122348693' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426439'
                WHERE ordernumber = 'P181018122424412' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281659'
                WHERE ordernumber = 'P181018122609810' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426440'
                WHERE ordernumber = 'P771018123602283' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401165'
                WHERE ordernumber = 'P631018123742131' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426441'
                WHERE ordernumber = 'P201018123819741' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80053'
                WHERE ordernumber = 'P771018124410470' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426442'
                WHERE ordernumber = 'P181018124709958' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426443'
                WHERE ordernumber = 'P421018124917137' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224172'
                WHERE ordernumber = 'P201018124945429' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '201702'
                WHERE ordernumber = 'P421018125249918' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224172'
                WHERE ordernumber = 'P201018125303603' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '196247'
                WHERE ordernumber = 'P181018125335195' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97225'
                WHERE ordernumber = 'P421018125517540' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345735'
                WHERE ordernumber = 'P421018130003952' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145774'
                WHERE ordernumber = 'P771018130116600' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423802'
                WHERE ordernumber = 'P201018130658268' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342789'
                WHERE ordernumber = 'P421018131144965' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313744'
                WHERE ordernumber = 'P421018131723905' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426445'
                WHERE ordernumber = 'P421018131952386' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426446'
                WHERE ordernumber = 'P181018132035160' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426448'
                WHERE ordernumber = 'P181018133105624' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293690'
                WHERE ordernumber = 'P181018133439591' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423811'
                WHERE ordernumber = 'P421018133611555' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98228'
                WHERE ordernumber = 'P201018133712819' 
            
2024-10-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426450'
                WHERE ordernumber = 'P201018133948445' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426451'
                WHERE ordernumber = 'P181018134512726' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310246'
                WHERE ordernumber = 'P201018134933790' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P201018135052511' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426452'
                WHERE ordernumber = 'P201018135222192' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144448'
                WHERE ordernumber = 'P181018135630534' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426453'
                WHERE ordernumber = 'P201018135854208' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426454'
                WHERE ordernumber = 'P201018140210393' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426455'
                WHERE ordernumber = 'P201018140411766' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397556'
                WHERE ordernumber = 'P181018140540552' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386597'
                WHERE ordernumber = 'P201018140625199' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426457'
                WHERE ordernumber = 'P201018140809380' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415243'
                WHERE ordernumber = 'P201018141055679' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426458'
                WHERE ordernumber = 'P421018141118673' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426461'
                WHERE ordernumber = 'P181018141153765' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426461'
                WHERE ordernumber = 'P181018141243290' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344728'
                WHERE ordernumber = 'P181018141325387' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426463'
                WHERE ordernumber = 'P181018141448806' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426459'
                WHERE ordernumber = 'P771018141449734' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426462'
                WHERE ordernumber = 'P191018141508815' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274886'
                WHERE ordernumber = 'P181018141624950' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426460'
                WHERE ordernumber = 'P771018141701706' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426464'
                WHERE ordernumber = 'P711018141846158' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426465'
                WHERE ordernumber = 'P711018142221762' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426466'
                WHERE ordernumber = 'P201018142417949' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301962'
                WHERE ordernumber = 'P421018142423690' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288955'
                WHERE ordernumber = 'P201018142749208' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213491'
                WHERE ordernumber = 'P201018143029295' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344253'
                WHERE ordernumber = 'P181018143101678' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426467'
                WHERE ordernumber = 'P181018143233671' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426467'
                WHERE ordernumber = 'P181018143322259' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426469'
                WHERE ordernumber = 'P771018143804398' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426467'
                WHERE ordernumber = 'P181018143831859' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402506'
                WHERE ordernumber = 'P181018144606136' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426471'
                WHERE ordernumber = 'P731018144712787' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426472'
                WHERE ordernumber = 'P771018144954711' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388429'
                WHERE ordernumber = 'P201018145112503' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426476'
                WHERE ordernumber = 'P421018145909650' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426474'
                WHERE ordernumber = 'P631018145913513' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247625'
                WHERE ordernumber = 'P201018145950213' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426475'
                WHERE ordernumber = 'P731018150048263' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426477'
                WHERE ordernumber = 'P731018150359722' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426474'
                WHERE ordernumber = 'P631018150425450' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426479'
                WHERE ordernumber = 'P201018150436582' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426478'
                WHERE ordernumber = 'P771018150610600' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426480'
                WHERE ordernumber = 'P421018151331364' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426481'
                WHERE ordernumber = 'P421018151534388' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426482'
                WHERE ordernumber = 'P631018151552774' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426483'
                WHERE ordernumber = 'P201018151653130' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238603'
                WHERE ordernumber = 'P201018151908767' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426480'
                WHERE ordernumber = 'P421018152156966' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426484'
                WHERE ordernumber = 'P421018152352166' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426485'
                WHERE ordernumber = 'P201018152444406' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115725'
                WHERE ordernumber = 'P201018152840339' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423982'
                WHERE ordernumber = 'P591018153054467' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426486'
                WHERE ordernumber = 'P421018153408255' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426487'
                WHERE ordernumber = 'P201018153937276' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426488'
                WHERE ordernumber = 'P181018154623903' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422803'
                WHERE ordernumber = 'P181018154902916' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426490'
                WHERE ordernumber = 'P771018155158485' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425983'
                WHERE ordernumber = 'P421018155411897' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225202'
                WHERE ordernumber = 'P181018155657381' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426491'
                WHERE ordernumber = 'P631018155736422' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426493'
                WHERE ordernumber = 'P711018155856951' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426494'
                WHERE ordernumber = 'P421018155942475' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318415'
                WHERE ordernumber = 'P421018160040929' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426496'
                WHERE ordernumber = 'P201018160312630' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426495'
                WHERE ordernumber = 'P181018160355599' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426497'
                WHERE ordernumber = 'P201018160703274' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262068'
                WHERE ordernumber = 'P201018161032802' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308021'
                WHERE ordernumber = 'P201018161505191' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221676'
                WHERE ordernumber = 'P181018161511493' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '172887'
                WHERE ordernumber = 'P711018162205842' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258483'
                WHERE ordernumber = 'P181018162323485' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97768'
                WHERE ordernumber = 'P181018162651785' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426500'
                WHERE ordernumber = 'P731018162711969' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269257'
                WHERE ordernumber = 'P201018163013375' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382512'
                WHERE ordernumber = 'P201018163338730' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396899'
                WHERE ordernumber = 'P421018163444749' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426501'
                WHERE ordernumber = 'P191018163721824' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422802'
                WHERE ordernumber = 'P181018163732200' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426502'
                WHERE ordernumber = 'P771018164101796' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136215'
                WHERE ordernumber = 'P731018164358324' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347940'
                WHERE ordernumber = 'P421018164430799' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99557'
                WHERE ordernumber = 'P181018165023835' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426503'
                WHERE ordernumber = 'P191018165134930' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426503'
                WHERE ordernumber = 'P191018165738388' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426505'
                WHERE ordernumber = 'P181018170451252' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426507'
                WHERE ordernumber = 'P181018170645356' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P421018170944171' 
            
2024-10-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426508'
                WHERE ordernumber = 'P201018171735186' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426509'
                WHERE ordernumber = 'P201018171815374' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410673'
                WHERE ordernumber = 'P181018173055883' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409609'
                WHERE ordernumber = 'P201018173613814' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423048'
                WHERE ordernumber = 'P181018174021825' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '67298'
                WHERE ordernumber = 'P201018174120299' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426506'
                WHERE ordernumber = 'P771018174246600' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426510'
                WHERE ordernumber = 'P771018174717586' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '363934'
                WHERE ordernumber = 'P181018174830574' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426512'
                WHERE ordernumber = 'P421018174846302' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426511'
                WHERE ordernumber = 'P771018175051498' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426514'
                WHERE ordernumber = 'P201018175307404' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426515'
                WHERE ordernumber = 'P191018175309276' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426513'
                WHERE ordernumber = 'P771018175340897' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393164'
                WHERE ordernumber = 'P201018175619843' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391265'
                WHERE ordernumber = 'P181018175712207' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426516'
                WHERE ordernumber = 'P201018175718240' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102172'
                WHERE ordernumber = 'P181018175845558' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426517'
                WHERE ordernumber = 'P201018180310183' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '134291'
                WHERE ordernumber = 'P201018180341153' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251576'
                WHERE ordernumber = 'P201018180520520' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426523'
                WHERE ordernumber = 'P201018181005132' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426522'
                WHERE ordernumber = 'P731018181255729' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426524'
                WHERE ordernumber = 'P771018181306714' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426521'
                WHERE ordernumber = 'P731018181415218' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '290603'
                WHERE ordernumber = 'P421018181944784' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426526'
                WHERE ordernumber = 'P181018181954994' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426525'
                WHERE ordernumber = 'P201018182018213' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426529'
                WHERE ordernumber = 'P181018182103482' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '58075'
                WHERE ordernumber = 'P201018182105683' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426528'
                WHERE ordernumber = 'P771018182110376' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426527'
                WHERE ordernumber = 'P631018182146111' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426521'
                WHERE ordernumber = 'P731018182254611' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426530'
                WHERE ordernumber = 'P181018182322118' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424673'
                WHERE ordernumber = 'P201018182335477' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426531'
                WHERE ordernumber = 'P771018182414383' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426519'
                WHERE ordernumber = 'P731018182430704' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425438'
                WHERE ordernumber = 'P731018182819590' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426533'
                WHERE ordernumber = 'P181018182825289' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426532'
                WHERE ordernumber = 'P771018183158187' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121795'
                WHERE ordernumber = 'P201018183217930' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '123447'
                WHERE ordernumber = 'P181018183227161' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426534'
                WHERE ordernumber = 'P771018183732395' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426535'
                WHERE ordernumber = 'P771018183944897' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426535'
                WHERE ordernumber = 'P771018183944897' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426535'
                WHERE ordernumber = 'P771018183944897' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426536'
                WHERE ordernumber = 'P421018184159696' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426536'
                WHERE ordernumber = 'P421018184232574' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '269948'
                WHERE ordernumber = 'P421018185244666' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372263'
                WHERE ordernumber = 'P421018185709160' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426537'
                WHERE ordernumber = 'P181018185747672' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391106'
                WHERE ordernumber = 'P201018185830373' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426538'
                WHERE ordernumber = 'P421018185921176' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426539'
                WHERE ordernumber = 'P201018185940337' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426540'
                WHERE ordernumber = 'P191018190353410' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208645'
                WHERE ordernumber = 'P191018190547973' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405517'
                WHERE ordernumber = 'P201018190609813' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426541'
                WHERE ordernumber = 'P731018190701548' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357564'
                WHERE ordernumber = 'P191018190723525' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102352'
                WHERE ordernumber = 'P191018191056400' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426543'
                WHERE ordernumber = 'P201018191332575' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426542'
                WHERE ordernumber = 'P731018191536802' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405650'
                WHERE ordernumber = 'P191018191613553' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420591'
                WHERE ordernumber = 'P201018191810861' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426544'
                WHERE ordernumber = 'P771018191941368' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426545'
                WHERE ordernumber = 'P771018192048841' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242282'
                WHERE ordernumber = 'P191018192231248' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426549'
                WHERE ordernumber = 'P201018192532964' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426404'
                WHERE ordernumber = 'P771018192842695' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379361'
                WHERE ordernumber = 'P191018193007329' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426541'
                WHERE ordernumber = 'P731018193017891' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '164943'
                WHERE ordernumber = 'P771018193039258' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397910'
                WHERE ordernumber = 'P191018193106161' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426532'
                WHERE ordernumber = 'P771018193700502' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103210'
                WHERE ordernumber = 'P191018193742572' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238374'
                WHERE ordernumber = 'P631018193824232' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412749'
                WHERE ordernumber = 'P201018193825414' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319839'
                WHERE ordernumber = 'P201018194645428' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '125147'
                WHERE ordernumber = 'P201018195228705' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426550'
                WHERE ordernumber = 'P201018195452626' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P191018200040406' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426552'
                WHERE ordernumber = 'P731018202156221' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95493'
                WHERE ordernumber = 'P631018202257671' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426553'
                WHERE ordernumber = 'P771018202633200' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426553'
                WHERE ordernumber = 'P771018202633200' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295506'
                WHERE ordernumber = 'P771018204530112' 
            
2024-10-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396844'
                WHERE ordernumber = 'P631018204638904' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426555'
                WHERE ordernumber = 'P711018204851377' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426546'
                WHERE ordernumber = 'P731018205353669' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426546'
                WHERE ordernumber = 'P731018205628935' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426557'
                WHERE ordernumber = 'P771018205937213' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426558'
                WHERE ordernumber = 'P731018210200843' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426559'
                WHERE ordernumber = 'P731018210334162' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426560'
                WHERE ordernumber = 'P731018210650919' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426561'
                WHERE ordernumber = 'P771018211414873' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '142468'
                WHERE ordernumber = 'P731018214921393' 
            
2024-10-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426564'
                WHERE ordernumber = 'P771018221924213'