2024-05-27 01:00:02 -- 將會員中心id寫入data-lake
2024-05-27 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-05-26%';
        
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392128'
                WHERE ordernumber = 'P420526105911467' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392129'
                WHERE ordernumber = 'P710526110201317' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392131'
                WHERE ordernumber = 'P200526110311967' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95171'
                WHERE ordernumber = 'P180526110343792' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303576'
                WHERE ordernumber = 'P180526110753287' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392132'
                WHERE ordernumber = 'P420526110800516' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180526110912982' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214003'
                WHERE ordernumber = 'P200526111017789' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382611'
                WHERE ordernumber = 'P180526111233933' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392134'
                WHERE ordernumber = 'P200526111327424' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392133'
                WHERE ordernumber = 'P420526111508596' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392135'
                WHERE ordernumber = 'P420526112003384' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378316'
                WHERE ordernumber = 'P420526112149928' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392136'
                WHERE ordernumber = 'P420526112434841' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392136'
                WHERE ordernumber = 'P420526112514331' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392137'
                WHERE ordernumber = 'P180526112808628' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313514'
                WHERE ordernumber = 'P420526112920273' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '152506'
                WHERE ordernumber = 'P180526112953251' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392138'
                WHERE ordernumber = 'P630526113552524' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284064'
                WHERE ordernumber = 'P180526113925405' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383126'
                WHERE ordernumber = 'P420526114026717' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319792'
                WHERE ordernumber = 'P200526114452642' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392139'
                WHERE ordernumber = 'P420526114630263' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100350'
                WHERE ordernumber = 'P790526114757361' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392139'
                WHERE ordernumber = 'P420526114836411' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392140'
                WHERE ordernumber = 'P420526115216539' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391529'
                WHERE ordernumber = 'P180526115316928' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392141'
                WHERE ordernumber = 'P710526115437314' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223098'
                WHERE ordernumber = 'P180526115632458' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392142'
                WHERE ordernumber = 'P420526120538243' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239979'
                WHERE ordernumber = 'P180526120934156' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390812'
                WHERE ordernumber = 'P180526121105844' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392143'
                WHERE ordernumber = 'P420526121137462' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390812'
                WHERE ordernumber = 'P180526121138898' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390343'
                WHERE ordernumber = 'P180526121319299' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389958'
                WHERE ordernumber = 'P420526121407140' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388012'
                WHERE ordernumber = 'P420526121440972' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392144'
                WHERE ordernumber = 'P200526121820633' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392146'
                WHERE ordernumber = 'P420526122339252' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381237'
                WHERE ordernumber = 'P190526122413268' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190526122451391' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302930'
                WHERE ordernumber = 'P180526122635245' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392147'
                WHERE ordernumber = 'P200526122847374' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382319'
                WHERE ordernumber = 'P200526122949148' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391240'
                WHERE ordernumber = 'P190526123012796' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392147'
                WHERE ordernumber = 'P200526123032532' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392149'
                WHERE ordernumber = 'P190526123301265' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391656'
                WHERE ordernumber = 'P420526123502727' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93434'
                WHERE ordernumber = 'P790526124112364' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392152'
                WHERE ordernumber = 'P200526124216989' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392151'
                WHERE ordernumber = 'P710526124258208' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392153'
                WHERE ordernumber = 'P180526124350212' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392154'
                WHERE ordernumber = 'P200526124503700' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392155'
                WHERE ordernumber = 'P420526125122617' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391421'
                WHERE ordernumber = 'P790526125149151' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392156'
                WHERE ordernumber = 'P180526125320248' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392157'
                WHERE ordernumber = 'P180526125557187' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392158'
                WHERE ordernumber = 'P200526125745676' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136876'
                WHERE ordernumber = 'P180526130038500' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392160'
                WHERE ordernumber = 'P190526130250860' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392161'
                WHERE ordernumber = 'P180526131039304' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392162'
                WHERE ordernumber = 'P710526131203957' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392163'
                WHERE ordernumber = 'P200526131327913' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139071'
                WHERE ordernumber = 'P200526131421136' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392165'
                WHERE ordernumber = 'P190526132020572' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392166'
                WHERE ordernumber = 'P180526132142212' 
            
2024-05-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392167'
                WHERE ordernumber = 'P420526132145873' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251049'
                WHERE ordernumber = 'P190526132304599' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234056'
                WHERE ordernumber = 'P180526132454460' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392168'
                WHERE ordernumber = 'P420526132529812' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222506'
                WHERE ordernumber = 'P790526133137396' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392169'
                WHERE ordernumber = 'P420526133448816' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391318'
                WHERE ordernumber = 'P790526133521417' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385499'
                WHERE ordernumber = 'P420526133629625' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379127'
                WHERE ordernumber = 'P420526133935208' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388510'
                WHERE ordernumber = 'P630526134009440' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392170'
                WHERE ordernumber = 'P180526134154401' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392171'
                WHERE ordernumber = 'P190526134231544' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230981'
                WHERE ordernumber = 'P190526134420293' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391842'
                WHERE ordernumber = 'P790526134708421' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392172'
                WHERE ordernumber = 'P790526135501835' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392175'
                WHERE ordernumber = 'P420526140016409' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392176'
                WHERE ordernumber = 'P190526140211744' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286112'
                WHERE ordernumber = 'P200526140253675' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392177'
                WHERE ordernumber = 'P190526140514329' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392179'
                WHERE ordernumber = 'P180526140950398' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213262'
                WHERE ordernumber = 'P190526141203372' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392181'
                WHERE ordernumber = 'P190526141337294' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210644'
                WHERE ordernumber = 'P180526141541388' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '61402'
                WHERE ordernumber = 'P180526142033990' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392183'
                WHERE ordernumber = 'P200526142523745' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310531'
                WHERE ordernumber = 'P200526142646210' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392184'
                WHERE ordernumber = 'P790526142942650' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392186'
                WHERE ordernumber = 'P180526143013923' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392185'
                WHERE ordernumber = 'P710526143137544' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392188'
                WHERE ordernumber = 'P420526143218801' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392189'
                WHERE ordernumber = 'P190526143317709' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392190'
                WHERE ordernumber = 'P200526143535208' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392191'
                WHERE ordernumber = 'P180526143542378' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392192'
                WHERE ordernumber = 'P420526143625292' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392193'
                WHERE ordernumber = 'P180526143652930' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113064'
                WHERE ordernumber = 'P180526143915720' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392194'
                WHERE ordernumber = 'P200526144055477' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392196'
                WHERE ordernumber = 'P180526144348768' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392195'
                WHERE ordernumber = 'P420526144349595' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343420'
                WHERE ordernumber = 'P710526144421397' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392197'
                WHERE ordernumber = 'P180526144439802' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392130'
                WHERE ordernumber = 'P420526144852370' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241633'
                WHERE ordernumber = 'P180526145353618' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246677'
                WHERE ordernumber = 'P180526145523584' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203568'
                WHERE ordernumber = 'P200526150046306' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392201'
                WHERE ordernumber = 'P180526150258393' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392202'
                WHERE ordernumber = 'P190526150314444' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124697'
                WHERE ordernumber = 'P710526150424224' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392203'
                WHERE ordernumber = 'P180526150505547' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392202'
                WHERE ordernumber = 'P190526150701954' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392204'
                WHERE ordernumber = 'P180526150725888' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67607'
                WHERE ordernumber = 'P420526151021453' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392206'
                WHERE ordernumber = 'P180526151034120' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392205'
                WHERE ordernumber = 'P710526151053229' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208327'
                WHERE ordernumber = 'P190526151102349' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211119'
                WHERE ordernumber = 'P190526151208130' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392207'
                WHERE ordernumber = 'P180526151220410' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392208'
                WHERE ordernumber = 'P420526151233762' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392209'
                WHERE ordernumber = 'P420526151705341' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114727'
                WHERE ordernumber = 'P200526151922741' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392211'
                WHERE ordernumber = 'P180526151925876' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392212'
                WHERE ordernumber = 'P190526151929328' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392211'
                WHERE ordernumber = 'P180526152017864' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391716'
                WHERE ordernumber = 'P200526152132579' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392213'
                WHERE ordernumber = 'P180526152147987' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247902'
                WHERE ordernumber = 'P180526152543913' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392214'
                WHERE ordernumber = 'P420526152655231' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392215'
                WHERE ordernumber = 'P180526152736145' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388311'
                WHERE ordernumber = 'P200526153038135' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271903'
                WHERE ordernumber = 'P420526153055867' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392217'
                WHERE ordernumber = 'P180526153118987' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392218'
                WHERE ordernumber = 'P200526153231575' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389100'
                WHERE ordernumber = 'P630526153428161' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392219'
                WHERE ordernumber = 'P200526153429761' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392221'
                WHERE ordernumber = 'P180526153605168' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392222'
                WHERE ordernumber = 'P200526153610442' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392223'
                WHERE ordernumber = 'P180526153945569' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392225'
                WHERE ordernumber = 'P180526154038871' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392226'
                WHERE ordernumber = 'P190526154103213' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392227'
                WHERE ordernumber = 'P180526154146837' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392229'
                WHERE ordernumber = 'P190526154224992' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290172'
                WHERE ordernumber = 'P420526154601948' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392231'
                WHERE ordernumber = 'P180526154608535' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392230'
                WHERE ordernumber = 'P200526154636465' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392231'
                WHERE ordernumber = 'P180526154723911' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392220'
                WHERE ordernumber = 'P420526154912950' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392232'
                WHERE ordernumber = 'P180526154948207' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392234'
                WHERE ordernumber = 'P190526155145199' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391575'
                WHERE ordernumber = 'P180526155444517' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392220'
                WHERE ordernumber = 'P420526155805549' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '198136'
                WHERE ordernumber = 'P710526155814972' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392237'
                WHERE ordernumber = 'P190526155838353' 
            
2024-05-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392228'
                WHERE ordernumber = 'P180526155921292' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391481'
                WHERE ordernumber = 'P200526160030435' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392236'
                WHERE ordernumber = 'P790526160249764' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373000'
                WHERE ordernumber = 'P790526160521416' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392240'
                WHERE ordernumber = 'P710526160642454' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303362'
                WHERE ordernumber = 'P630526160706471' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392243'
                WHERE ordernumber = 'P420526160930745' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392241'
                WHERE ordernumber = 'P790526161050398' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392245'
                WHERE ordernumber = 'P180526161224839' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392244'
                WHERE ordernumber = 'P710526161417455' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392246'
                WHERE ordernumber = 'P420526161422753' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392247'
                WHERE ordernumber = 'P420526161644177' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392238'
                WHERE ordernumber = 'P180526161804267' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101605'
                WHERE ordernumber = 'P710526161838775' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392248'
                WHERE ordernumber = 'P180526162043976' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392249'
                WHERE ordernumber = 'P190526162127423' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392251'
                WHERE ordernumber = 'P200526162410705' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392252'
                WHERE ordernumber = 'P180526162508327' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392253'
                WHERE ordernumber = 'P200526162516658' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303338'
                WHERE ordernumber = 'P190526162654815' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392254'
                WHERE ordernumber = 'P420526162757579' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392255'
                WHERE ordernumber = 'P180526162832621' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '151256'
                WHERE ordernumber = 'P420526163009622' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392257'
                WHERE ordernumber = 'P420526163453689' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392258'
                WHERE ordernumber = 'P180526163741124' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '29454'
                WHERE ordernumber = 'P630526164020453' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310389'
                WHERE ordernumber = 'P180526164029831' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392259'
                WHERE ordernumber = 'P790526164034266' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392263'
                WHERE ordernumber = 'P420526165144406' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333591'
                WHERE ordernumber = 'P200526165144160' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392150'
                WHERE ordernumber = 'P180526165341835' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392261'
                WHERE ordernumber = 'P790526165351654' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392150'
                WHERE ordernumber = 'P180526165403888' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392159'
                WHERE ordernumber = 'P180526165428989' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392265'
                WHERE ordernumber = 'P420526165907436' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392264'
                WHERE ordernumber = 'P200526165958648' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392266'
                WHERE ordernumber = 'P180526170037628' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134060'
                WHERE ordernumber = 'P180526170214167' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392267'
                WHERE ordernumber = 'P420526170253457' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392268'
                WHERE ordernumber = 'P420526170439405' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385301'
                WHERE ordernumber = 'P200526170534798' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392269'
                WHERE ordernumber = 'P420526171205591' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392270'
                WHERE ordernumber = 'P180526171635336' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392271'
                WHERE ordernumber = 'P180526171734634' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392272'
                WHERE ordernumber = 'P180526171958545' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392273'
                WHERE ordernumber = 'P420526172121537' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213209'
                WHERE ordernumber = 'P180526172739476' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101960'
                WHERE ordernumber = 'P710526172854811' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392274'
                WHERE ordernumber = 'P190526172855328' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392275'
                WHERE ordernumber = 'P420526173058799' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392276'
                WHERE ordernumber = 'P200526173144774' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107945'
                WHERE ordernumber = 'P200526173301265' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391648'
                WHERE ordernumber = 'P420526173458743' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392277'
                WHERE ordernumber = 'P180526173636914' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97867'
                WHERE ordernumber = 'P420526173724778' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385904'
                WHERE ordernumber = 'P200526173755495' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '17382'
                WHERE ordernumber = 'P710526174624751' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392278'
                WHERE ordernumber = 'P190526174829466' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391708'
                WHERE ordernumber = 'P200526174921371' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385765'
                WHERE ordernumber = 'P630526175247161' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392281'
                WHERE ordernumber = 'P630526175307856' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392282'
                WHERE ordernumber = 'P790526175446157' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392283'
                WHERE ordernumber = 'P200526175714183' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392280'
                WHERE ordernumber = 'P710526175729394' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392284'
                WHERE ordernumber = 'P190526175833352' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392280'
                WHERE ordernumber = 'P710526180152341' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273038'
                WHERE ordernumber = 'P420526180600624' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392283'
                WHERE ordernumber = 'P200526180717436' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392286'
                WHERE ordernumber = 'P790526180802818' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200526180824617' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392288'
                WHERE ordernumber = 'P420526180912399' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392289'
                WHERE ordernumber = 'P790526181733219' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392290'
                WHERE ordernumber = 'P420526181922617' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392292'
                WHERE ordernumber = 'P200526182429304' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392293'
                WHERE ordernumber = 'P180526182438222' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391963'
                WHERE ordernumber = 'P790526182445688' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392262'
                WHERE ordernumber = 'P790526182521759' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391843'
                WHERE ordernumber = 'P790526182549235' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392294'
                WHERE ordernumber = 'P420526182611314' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391619'
                WHERE ordernumber = 'P420526182915473' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392295'
                WHERE ordernumber = 'P710526183156182' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392296'
                WHERE ordernumber = 'P420526183910358' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161620'
                WHERE ordernumber = 'P200526184359762' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338253'
                WHERE ordernumber = 'P180526184430554' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392298'
                WHERE ordernumber = 'P710526184937604' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392300'
                WHERE ordernumber = 'P190526185052777' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389122'
                WHERE ordernumber = 'P190526185137833' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392299'
                WHERE ordernumber = 'P710526185155371' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392301'
                WHERE ordernumber = 'P200526185157132' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242055'
                WHERE ordernumber = 'P710526185348447' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392302'
                WHERE ordernumber = 'P710526185441920' 
            
2024-05-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392303'
                WHERE ordernumber = 'P190526185542166' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229589'
                WHERE ordernumber = 'P190526185703855' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390790'
                WHERE ordernumber = 'P190526185900903' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282805'
                WHERE ordernumber = 'P190526190650447' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340824'
                WHERE ordernumber = 'P200526190912555' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392305'
                WHERE ordernumber = 'P710526190942934' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392306'
                WHERE ordernumber = 'P190526191948587' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392306'
                WHERE ordernumber = 'P190526192138658' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392307'
                WHERE ordernumber = 'P190526192341805' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379469'
                WHERE ordernumber = 'P200526192824846' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392308'
                WHERE ordernumber = 'P710526193103995' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298240'
                WHERE ordernumber = 'P200526193151148' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392309'
                WHERE ordernumber = 'P710526193506367' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420526193939909' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390945'
                WHERE ordernumber = 'P190526194337890' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '171250'
                WHERE ordernumber = 'P630526194424789' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '171250'
                WHERE ordernumber = 'P630526194615398' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392314'
                WHERE ordernumber = 'P190526194900796' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392317'
                WHERE ordernumber = 'P190526195145758' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392315'
                WHERE ordernumber = 'P790526195213328' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103860'
                WHERE ordernumber = 'P190526200044927' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392318'
                WHERE ordernumber = 'P420526200110473' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241779'
                WHERE ordernumber = 'P790526205928642' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392324'
                WHERE ordernumber = 'P710526205937810' 
            
2024-05-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392326'
                WHERE ordernumber = 'P790526211855378'