2023-12-25 01:00:01 -- 將會員中心id寫入data-lake
2023-12-25 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 '2023-12-24%';
        
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '250494'
                WHERE ordernumber = 'P421224100516704' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '350304'
                WHERE ordernumber = 'P421224103031758' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '222414'
                WHERE ordernumber = 'P421224103636232' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354656'
                WHERE ordernumber = 'P421224104345956' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '340272'
                WHERE ordernumber = 'P421224104731446' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354657'
                WHERE ordernumber = 'P421224105303178' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '144385'
                WHERE ordernumber = 'P201224110251141' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '241472'
                WHERE ordernumber = 'P201224110340809' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354659'
                WHERE ordernumber = 'P421224110503574' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354660'
                WHERE ordernumber = 'P181224110543626' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354662'
                WHERE ordernumber = 'P181224110913473' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354663'
                WHERE ordernumber = 'P181224111056361' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354665'
                WHERE ordernumber = 'P201224111149542' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354666'
                WHERE ordernumber = 'P181224111222323' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354668'
                WHERE ordernumber = 'P181224111520225' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354669'
                WHERE ordernumber = 'P181224111849448' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354670'
                WHERE ordernumber = 'P181224113158718' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '321982'
                WHERE ordernumber = 'P421224113249460' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '311650'
                WHERE ordernumber = 'P201224113330400' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354671'
                WHERE ordernumber = 'P421224113607461' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '352175'
                WHERE ordernumber = 'P181224113612336' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '344912'
                WHERE ordernumber = 'P181224113741697' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '240565'
                WHERE ordernumber = 'P201224113823819' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354672'
                WHERE ordernumber = 'P181224114014560' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354673'
                WHERE ordernumber = 'P181224114106440' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354627'
                WHERE ordernumber = 'P181224114434702' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '8912'
                WHERE ordernumber = 'P191224114550924' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '250434'
                WHERE ordernumber = 'P181224114745337' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '105785'
                WHERE ordernumber = 'P181224114819347' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '250434'
                WHERE ordernumber = 'P191224114858266' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354675'
                WHERE ordernumber = 'P181224114946726' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '352938'
                WHERE ordernumber = 'P421224115301117' 
            
2023-12-25 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '279840'
                WHERE ordernumber = 'P421224115434210' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354679'
                WHERE ordernumber = 'P421224115953359' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275674'
                WHERE ordernumber = 'P181224120200674' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337254'
                WHERE ordernumber = 'P421224120259562' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354681'
                WHERE ordernumber = 'P181224120450575' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90212'
                WHERE ordernumber = 'P201224120512770' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354682'
                WHERE ordernumber = 'P181224120540480' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354683'
                WHERE ordernumber = 'P181224120644855' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212578'
                WHERE ordernumber = 'P201224120644160' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354684'
                WHERE ordernumber = 'P181224120917782' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90574'
                WHERE ordernumber = 'P191224121118634' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354685'
                WHERE ordernumber = 'P181224121120697' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230861'
                WHERE ordernumber = 'P201224121141969' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354685'
                WHERE ordernumber = 'P181224121224535' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '194321'
                WHERE ordernumber = 'P421224121355922' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354688'
                WHERE ordernumber = 'P191224121458372' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354691'
                WHERE ordernumber = 'P191224121830972' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223100'
                WHERE ordernumber = 'P181224122005860' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354690'
                WHERE ordernumber = 'P421224122053373' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352183'
                WHERE ordernumber = 'P181224122209392' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352183'
                WHERE ordernumber = 'P181224122239238' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216911'
                WHERE ordernumber = 'P181224122411288' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280511'
                WHERE ordernumber = 'P181224122706122' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315332'
                WHERE ordernumber = 'P181224123049331' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347413'
                WHERE ordernumber = 'P201224123829208' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354695'
                WHERE ordernumber = 'P181224123900386' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166284'
                WHERE ordernumber = 'P181224124008286' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347094'
                WHERE ordernumber = 'P421224124310618' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299911'
                WHERE ordernumber = 'P181224124439470' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354697'
                WHERE ordernumber = 'P181224124551162' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354698'
                WHERE ordernumber = 'P181224124629370' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P181224124835479' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '190488'
                WHERE ordernumber = 'P421224124941666' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223478'
                WHERE ordernumber = 'P201224124954507' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354699'
                WHERE ordernumber = 'P421224125416156' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P181224125538783' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354701'
                WHERE ordernumber = 'P421224125704439' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '150647'
                WHERE ordernumber = 'P191224125830176' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219693'
                WHERE ordernumber = 'P421224125836973' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100672'
                WHERE ordernumber = 'P421224125920181' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '170343'
                WHERE ordernumber = 'P191224130230183' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '170343'
                WHERE ordernumber = 'P191224130413239' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '150647'
                WHERE ordernumber = 'P191224130716714' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354707'
                WHERE ordernumber = 'P421224130847913' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '149349'
                WHERE ordernumber = 'P191224130916249' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354709'
                WHERE ordernumber = 'P191224131127438' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354708'
                WHERE ordernumber = 'P421224131444765' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137196'
                WHERE ordernumber = 'P201224131552911' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354711'
                WHERE ordernumber = 'P421224131600952' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '58175'
                WHERE ordernumber = 'P181224131731586' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354713'
                WHERE ordernumber = 'P431224132051813' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354714'
                WHERE ordernumber = 'P431224132330556' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354718'
                WHERE ordernumber = 'P181224132742526' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354720'
                WHERE ordernumber = 'P181224132946979' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307765'
                WHERE ordernumber = 'P181224133159990' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354722'
                WHERE ordernumber = 'P201224133309612' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354723'
                WHERE ordernumber = 'P421224133535648' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81603'
                WHERE ordernumber = 'P181224133537188' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354725'
                WHERE ordernumber = 'P421224133721809' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354726'
                WHERE ordernumber = 'P181224133823145' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354727'
                WHERE ordernumber = 'P421224133917971' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354728'
                WHERE ordernumber = 'P181224133920395' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96063'
                WHERE ordernumber = 'P201224133921320' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354729'
                WHERE ordernumber = 'P181224134038958' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313882'
                WHERE ordernumber = 'P181224134344295' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319053'
                WHERE ordernumber = 'P181224134426661' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248025'
                WHERE ordernumber = 'P201224134449767' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310908'
                WHERE ordernumber = 'P181224134523487' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252711'
                WHERE ordernumber = 'P181224134901195' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279917'
                WHERE ordernumber = 'P181224134944115' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252711'
                WHERE ordernumber = 'P181224135035726' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168535'
                WHERE ordernumber = 'P421224135233880' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208484'
                WHERE ordernumber = 'P181224135327430' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290789'
                WHERE ordernumber = 'P201224135449406' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354736'
                WHERE ordernumber = 'P421224135636538' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99901'
                WHERE ordernumber = 'P181224135752531' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354737'
                WHERE ordernumber = 'P421224140058574' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354741'
                WHERE ordernumber = 'P181224140802549' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354742'
                WHERE ordernumber = 'P181224140945740' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354745'
                WHERE ordernumber = 'P421224141349956' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '323474'
                WHERE ordernumber = 'P201224141530589' 
            
2023-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354746'
                WHERE ordernumber = 'P191224141553567' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354747'
                WHERE ordernumber = 'P181224141806877' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162408'
                WHERE ordernumber = 'P181224141930374' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354748'
                WHERE ordernumber = 'P421224142023354' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354749'
                WHERE ordernumber = 'P181224142058461' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354751'
                WHERE ordernumber = 'P181224142206705' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354750'
                WHERE ordernumber = 'P421224142210552' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354753'
                WHERE ordernumber = 'P181224142310382' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157525'
                WHERE ordernumber = 'P201224142400967' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354755'
                WHERE ordernumber = 'P191224142457719' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339056'
                WHERE ordernumber = 'P201224142515890' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354756'
                WHERE ordernumber = 'P421224142649830' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354755'
                WHERE ordernumber = 'P181224142718553' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300260'
                WHERE ordernumber = 'P191224143322478' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354760'
                WHERE ordernumber = 'P421224143412808' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354759'
                WHERE ordernumber = 'P181224143417189' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354757'
                WHERE ordernumber = 'P201224143434859' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354758'
                WHERE ordernumber = 'P201224143521454' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94164'
                WHERE ordernumber = 'P201224143658640' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354761'
                WHERE ordernumber = 'P181224143710633' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354762'
                WHERE ordernumber = 'P421224143726760' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354763'
                WHERE ordernumber = 'P421224143835623' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303223'
                WHERE ordernumber = 'P181224144407792' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354764'
                WHERE ordernumber = 'P181224145122791' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348213'
                WHERE ordernumber = 'P201224145427483' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345178'
                WHERE ordernumber = 'P181224145627278' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354766'
                WHERE ordernumber = 'P201224145709663' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354768'
                WHERE ordernumber = 'P181224145859931' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354770'
                WHERE ordernumber = 'P181224150255122' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354769'
                WHERE ordernumber = 'P421224150359398' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116817'
                WHERE ordernumber = 'P191224150635546' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278646'
                WHERE ordernumber = 'P181224150636670' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354306'
                WHERE ordernumber = 'P421224151412834' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354775'
                WHERE ordernumber = 'P201224151650541' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354530'
                WHERE ordernumber = 'P421224151710202' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131913'
                WHERE ordernumber = 'P181224151817982' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354776'
                WHERE ordernumber = 'P181224151925829' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349881'
                WHERE ordernumber = 'P421224151938921' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350554'
                WHERE ordernumber = 'P201224152024737' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286859'
                WHERE ordernumber = 'P201224152116986' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354778'
                WHERE ordernumber = 'P181224152232792' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354779'
                WHERE ordernumber = 'P181224152732774' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237681'
                WHERE ordernumber = 'P181224153028981' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344307'
                WHERE ordernumber = 'P201224153050258' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354781'
                WHERE ordernumber = 'P181224153243457' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278683'
                WHERE ordernumber = 'P181224153349669' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354782'
                WHERE ordernumber = 'P181224153618579' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354783'
                WHERE ordernumber = 'P181224154041873' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111265'
                WHERE ordernumber = 'P201224154115154' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354784'
                WHERE ordernumber = 'P201224154246257' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278196'
                WHERE ordernumber = 'P181224154612299' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354785'
                WHERE ordernumber = 'P191224155008472' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354789'
                WHERE ordernumber = 'P181224155338257' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350887'
                WHERE ordernumber = 'P181224155533684' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354786'
                WHERE ordernumber = 'P421224155632985' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354790'
                WHERE ordernumber = 'P181224155712636' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252645'
                WHERE ordernumber = 'P181224155808501' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284772'
                WHERE ordernumber = 'P181224160007915' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '198301'
                WHERE ordernumber = 'P191224160204631' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '150633'
                WHERE ordernumber = 'P181224160339144' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265656'
                WHERE ordernumber = 'P201224160449892' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354792'
                WHERE ordernumber = 'P181224160454555' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354793'
                WHERE ordernumber = 'P181224160607718' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300576'
                WHERE ordernumber = 'P181224160639228' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92196'
                WHERE ordernumber = 'P181224161004413' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351369'
                WHERE ordernumber = 'P181224161234844' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354796'
                WHERE ordernumber = 'P181224161357934' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349165'
                WHERE ordernumber = 'P181224161625184' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354799'
                WHERE ordernumber = 'P191224161726175' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354800'
                WHERE ordernumber = 'P181224161835561' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332961'
                WHERE ordernumber = 'P421224161912123' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284929'
                WHERE ordernumber = 'P191224161917294' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354802'
                WHERE ordernumber = 'P181224162128323' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354803'
                WHERE ordernumber = 'P191224162248244' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121987'
                WHERE ordernumber = 'P181224162427352' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39392'
                WHERE ordernumber = 'P201224162509478' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354806'
                WHERE ordernumber = 'P181224162639924' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306609'
                WHERE ordernumber = 'P181224163046398' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354810'
                WHERE ordernumber = 'P181224163448727' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291308'
                WHERE ordernumber = 'P181224163651454' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353082'
                WHERE ordernumber = 'P421224163818833' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354817'
                WHERE ordernumber = 'P181224164230949' 
            
2023-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76754'
                WHERE ordernumber = 'P201224164320112' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354818'
                WHERE ordernumber = 'P181224164341658' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251017'
                WHERE ordernumber = 'P181224164620423' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251017'
                WHERE ordernumber = 'P181224164704490' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354821'
                WHERE ordernumber = 'P201224164837389' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354822'
                WHERE ordernumber = 'P181224165021612' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354823'
                WHERE ordernumber = 'P421224165028895' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354825'
                WHERE ordernumber = 'P421224165110833' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354824'
                WHERE ordernumber = 'P201224165152971' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354827'
                WHERE ordernumber = 'P421224165258437' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293262'
                WHERE ordernumber = 'P201224165356175' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350391'
                WHERE ordernumber = 'P201224165510284' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110087'
                WHERE ordernumber = 'P191224165531956' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81465'
                WHERE ordernumber = 'P191224165957344' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354829'
                WHERE ordernumber = 'P181224170011495' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354830'
                WHERE ordernumber = 'P421224170036235' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106077'
                WHERE ordernumber = 'P181224170226943' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228154'
                WHERE ordernumber = 'P201224170321517' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P181224170422456' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275640'
                WHERE ordernumber = 'P191224170433804' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228154'
                WHERE ordernumber = 'P201224170515303' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354833'
                WHERE ordernumber = 'P181224170628906' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354835'
                WHERE ordernumber = 'P181224170935993' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354836'
                WHERE ordernumber = 'P181224171110995' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354837'
                WHERE ordernumber = 'P181224171213176' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306247'
                WHERE ordernumber = 'P201224171220219' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354838'
                WHERE ordernumber = 'P421224171231885' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354839'
                WHERE ordernumber = 'P201224171313683' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354840'
                WHERE ordernumber = 'P201224171453702' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354841'
                WHERE ordernumber = 'P201224171703149' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264492'
                WHERE ordernumber = 'P181224171715771' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259736'
                WHERE ordernumber = 'P201224172053366' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354844'
                WHERE ordernumber = 'P421224172132429' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354845'
                WHERE ordernumber = 'P421224172220394' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354846'
                WHERE ordernumber = 'P201224172349492' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354848'
                WHERE ordernumber = 'P181224172612914' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248497'
                WHERE ordernumber = 'P181224172704358' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280382'
                WHERE ordernumber = 'P201224172715236' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354852'
                WHERE ordernumber = 'P181224172943217' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350278'
                WHERE ordernumber = 'P201224173005736' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270267'
                WHERE ordernumber = 'P181224173247383' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238771'
                WHERE ordernumber = 'P201224173546596' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238771'
                WHERE ordernumber = 'P201224173604592' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156506'
                WHERE ordernumber = 'P201224173715666' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302167'
                WHERE ordernumber = 'P181224173931270' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335751'
                WHERE ordernumber = 'P201224174000928' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343981'
                WHERE ordernumber = 'P201224174046680' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234893'
                WHERE ordernumber = 'P201224174134917' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295988'
                WHERE ordernumber = 'P201224174221514' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354858'
                WHERE ordernumber = 'P181224174234218' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354859'
                WHERE ordernumber = 'P201224174313283' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252957'
                WHERE ordernumber = 'P201224174419361' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354860'
                WHERE ordernumber = 'P181224174502862' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240414'
                WHERE ordernumber = 'P181224174714235' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354861'
                WHERE ordernumber = 'P191224174822456' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166056'
                WHERE ordernumber = 'P181224174938853' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340743'
                WHERE ordernumber = 'P421224175020856' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265589'
                WHERE ordernumber = 'P201224175045727' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354863'
                WHERE ordernumber = 'P191224175211206' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354864'
                WHERE ordernumber = 'P181224175245342' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316226'
                WHERE ordernumber = 'P201224175427364' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354866'
                WHERE ordernumber = 'P421224175651791' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354867'
                WHERE ordernumber = 'P181224175651758' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354870'
                WHERE ordernumber = 'P181224180157612' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354871'
                WHERE ordernumber = 'P421224180246287' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306058'
                WHERE ordernumber = 'P201224180250974' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354872'
                WHERE ordernumber = 'P181224180316778' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275849'
                WHERE ordernumber = 'P201224180442165' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354874'
                WHERE ordernumber = 'P181224181014814' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354875'
                WHERE ordernumber = 'P201224181033875' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354876'
                WHERE ordernumber = 'P181224181122814' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347640'
                WHERE ordernumber = 'P181224181257564' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354877'
                WHERE ordernumber = 'P421224181339324' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354878'
                WHERE ordernumber = 'P201224181402968' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354880'
                WHERE ordernumber = 'P421224181746668' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354881'
                WHERE ordernumber = 'P181224182021472' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345090'
                WHERE ordernumber = 'P201224182455475' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354883'
                WHERE ordernumber = 'P181224182622161' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133686'
                WHERE ordernumber = 'P181224182755588' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206345'
                WHERE ordernumber = 'P181224182930904' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289885'
                WHERE ordernumber = 'P191224184000405' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354888'
                WHERE ordernumber = 'P191224184314646' 
            
2023-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354888'
                WHERE ordernumber = 'P191224184741701' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314157'
                WHERE ordernumber = 'P191224185127634' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354890'
                WHERE ordernumber = 'P201224185127583' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253343'
                WHERE ordernumber = 'P201224185411261' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354893'
                WHERE ordernumber = 'P191224185430537' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354286'
                WHERE ordernumber = 'P191224185559874' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339296'
                WHERE ordernumber = 'P201224190050870' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354013'
                WHERE ordernumber = 'P191224191042617' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354894'
                WHERE ordernumber = 'P191224191340987' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354897'
                WHERE ordernumber = 'P421224191639483' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348002'
                WHERE ordernumber = 'P421224191930971' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111407'
                WHERE ordernumber = 'P191224193538498' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P201224194036175' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165635'
                WHERE ordernumber = 'P191224194916514' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354905'
                WHERE ordernumber = 'P421224195218210' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354907'
                WHERE ordernumber = 'P191224195334143' 
            
2023-12-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161340'
                WHERE ordernumber = 'P191224195722508'