2024-06-13 01:00:01 -- 將會員中心id寫入data-lake
2024-06-13 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-06-12%';
        
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342339'
                WHERE ordernumber = 'P630612101959894' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395648'
                WHERE ordernumber = 'P630612104227292' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127878'
                WHERE ordernumber = 'P200612110148382' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395651'
                WHERE ordernumber = 'P200612110315387' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271189'
                WHERE ordernumber = 'P180612110758475' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395652'
                WHERE ordernumber = 'P200612110808176' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268333'
                WHERE ordernumber = 'P180612111201975' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395653'
                WHERE ordernumber = 'P190612111339579' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '63826'
                WHERE ordernumber = 'P180612111608521' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346212'
                WHERE ordernumber = 'P190612111619959' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395655'
                WHERE ordernumber = 'P180612111828951' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395654'
                WHERE ordernumber = 'P420612111831813' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '63826'
                WHERE ordernumber = 'P190612111923981' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395657'
                WHERE ordernumber = 'P420612111955570' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274730'
                WHERE ordernumber = 'P710612112008591' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355408'
                WHERE ordernumber = 'P420612112138827' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395658'
                WHERE ordernumber = 'P180612112619168' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141131'
                WHERE ordernumber = 'P200612112621191' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395659'
                WHERE ordernumber = 'P420612112936283' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395660'
                WHERE ordernumber = 'P190612113606517' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133389'
                WHERE ordernumber = 'P190612113816768' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382469'
                WHERE ordernumber = 'P180612114322929' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311842'
                WHERE ordernumber = 'P420612115010330' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395664'
                WHERE ordernumber = 'P180612115646385' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395665'
                WHERE ordernumber = 'P420612120026166' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394961'
                WHERE ordernumber = 'P200612120145159' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395666'
                WHERE ordernumber = 'P420612120348346' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395668'
                WHERE ordernumber = 'P190612120724346' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395669'
                WHERE ordernumber = 'P200612120745226' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395670'
                WHERE ordernumber = 'P200612121218784' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395671'
                WHERE ordernumber = 'P190612121417823' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140799'
                WHERE ordernumber = 'P200612121427749' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395672'
                WHERE ordernumber = 'P200612121538710' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395673'
                WHERE ordernumber = 'P200612121640236' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395521'
                WHERE ordernumber = 'P200612121925404' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395675'
                WHERE ordernumber = 'P200612122048854' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395677'
                WHERE ordernumber = 'P190612122705436' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385059'
                WHERE ordernumber = 'P190612123002508' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '171560'
                WHERE ordernumber = 'P190612123159532' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350446'
                WHERE ordernumber = 'P190612123300292' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395679'
                WHERE ordernumber = 'P190612123454700' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271313'
                WHERE ordernumber = 'P190612123955960' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395680'
                WHERE ordernumber = 'P630612124541198' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395682'
                WHERE ordernumber = 'P190612125535278' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395683'
                WHERE ordernumber = 'P420612125737721' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392366'
                WHERE ordernumber = 'P180612130746851' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395686'
                WHERE ordernumber = 'P200612131454702' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395685'
                WHERE ordernumber = 'P710612131534843' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395688'
                WHERE ordernumber = 'P180612131801968' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395687'
                WHERE ordernumber = 'P710612131814540' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243036'
                WHERE ordernumber = 'P200612132059787' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395691'
                WHERE ordernumber = 'P180612132129601' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395691'
                WHERE ordernumber = 'P180612132425975' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395692'
                WHERE ordernumber = 'P710612132435212' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '119681'
                WHERE ordernumber = 'P180612132806137' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P420612132824805' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395689'
                WHERE ordernumber = 'P180612132942900' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313776'
                WHERE ordernumber = 'P190612133010614' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395689'
                WHERE ordernumber = 'P180612133015233' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395366'
                WHERE ordernumber = 'P180612133355592' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395693'
                WHERE ordernumber = 'P180612133553469' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200612133627137' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395685'
                WHERE ordernumber = 'P710612131534843' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395694'
                WHERE ordernumber = 'P710612134507733' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395695'
                WHERE ordernumber = 'P200612135542399' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395696'
                WHERE ordernumber = 'P180612135631470' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P420612135847226' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388790'
                WHERE ordernumber = 'P180612140144871' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80921'
                WHERE ordernumber = 'P200612140838830' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304708'
                WHERE ordernumber = 'P420612140910700' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395697'
                WHERE ordernumber = 'P420612141319378' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395698'
                WHERE ordernumber = 'P180612141523925' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128720'
                WHERE ordernumber = 'P180612141736663' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395700'
                WHERE ordernumber = 'P200612142015910' 
            
2024-06-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390293'
                WHERE ordernumber = 'P200612142503114' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395701'
                WHERE ordernumber = 'P180612142509553' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286280'
                WHERE ordernumber = 'P190612142839440' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366721'
                WHERE ordernumber = 'P200612143022278' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395702'
                WHERE ordernumber = 'P200612143126485' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395703'
                WHERE ordernumber = 'P190612143130190' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395704'
                WHERE ordernumber = 'P420612143245793' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395705'
                WHERE ordernumber = 'P180612143307949' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391406'
                WHERE ordernumber = 'P190612143408529' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258525'
                WHERE ordernumber = 'P180612143750243' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395706'
                WHERE ordernumber = 'P200612143817744' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118590'
                WHERE ordernumber = 'P180612143855120' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379462'
                WHERE ordernumber = 'P180612144451512' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395708'
                WHERE ordernumber = 'P180612144945973' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395709'
                WHERE ordernumber = 'P420612145243417' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395710'
                WHERE ordernumber = 'P180612145250742' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395713'
                WHERE ordernumber = 'P180612150328755' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395712'
                WHERE ordernumber = 'P200612150417422' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395714'
                WHERE ordernumber = 'P200612150553190' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395711'
                WHERE ordernumber = 'P200612150637168' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '197318'
                WHERE ordernumber = 'P420612151016231' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316093'
                WHERE ordernumber = 'P180612151113116' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395715'
                WHERE ordernumber = 'P200612151201774' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395716'
                WHERE ordernumber = 'P200612151303989' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380975'
                WHERE ordernumber = 'P180612151656251' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395717'
                WHERE ordernumber = 'P200612152258363' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395546'
                WHERE ordernumber = 'P180612152509682' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395546'
                WHERE ordernumber = 'P180612152535863' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '190894'
                WHERE ordernumber = 'P180612152625524' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395718'
                WHERE ordernumber = 'P420612152626201' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395719'
                WHERE ordernumber = 'P420612153003602' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395720'
                WHERE ordernumber = 'P180612153134224' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395722'
                WHERE ordernumber = 'P180612153511614' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395721'
                WHERE ordernumber = 'P420612153708213' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299703'
                WHERE ordernumber = 'P200612153906123' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395724'
                WHERE ordernumber = 'P780612154315594' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395725'
                WHERE ordernumber = 'P420612154425253' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395726'
                WHERE ordernumber = 'P200612154458878' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395727'
                WHERE ordernumber = 'P200612154910700' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228983'
                WHERE ordernumber = 'P190612160226463' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395729'
                WHERE ordernumber = 'P180612160249478' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376572'
                WHERE ordernumber = 'P190612160652502' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109535'
                WHERE ordernumber = 'P180612161228872' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315127'
                WHERE ordernumber = 'P200612161516886' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395731'
                WHERE ordernumber = 'P420612161618665' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393289'
                WHERE ordernumber = 'P180612162229378' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105869'
                WHERE ordernumber = 'P200612162416562' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382660'
                WHERE ordernumber = 'P420612163022932' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395730'
                WHERE ordernumber = 'P420612163137456' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239077'
                WHERE ordernumber = 'P180612163501875' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395734'
                WHERE ordernumber = 'P200612163857372' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P180612163916795' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382336'
                WHERE ordernumber = 'P180612164029312' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258960'
                WHERE ordernumber = 'P180612164256262' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395738'
                WHERE ordernumber = 'P420612165507611' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366205'
                WHERE ordernumber = 'P630612165603518' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395739'
                WHERE ordernumber = 'P420612165606129' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107770'
                WHERE ordernumber = 'P180612165926929' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351157'
                WHERE ordernumber = 'P200612170342885' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395741'
                WHERE ordernumber = 'P180612170406325' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395742'
                WHERE ordernumber = 'P180612171033275' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314728'
                WHERE ordernumber = 'P420612171043377' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395743'
                WHERE ordernumber = 'P180612171219179' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379440'
                WHERE ordernumber = 'P420612171825816' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395744'
                WHERE ordernumber = 'P420612171951978' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365139'
                WHERE ordernumber = 'P420612172140260' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395745'
                WHERE ordernumber = 'P180612172244335' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257376'
                WHERE ordernumber = 'P710612172251748' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307752'
                WHERE ordernumber = 'P200612172449825' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395746'
                WHERE ordernumber = 'P180612172455413' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108330'
                WHERE ordernumber = 'P420612172627610' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114516'
                WHERE ordernumber = 'P180612172718289' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343608'
                WHERE ordernumber = 'P200612172953959' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386512'
                WHERE ordernumber = 'P200612173214185' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354933'
                WHERE ordernumber = 'P420612173345693' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P180612174143303' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310323'
                WHERE ordernumber = 'P200612174151933' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317335'
                WHERE ordernumber = 'P190612174301157' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214419'
                WHERE ordernumber = 'P180612174425167' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350377'
                WHERE ordernumber = 'P590612174612341' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214419'
                WHERE ordernumber = 'P180612174631174' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395751'
                WHERE ordernumber = 'P180612175350771' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395472'
                WHERE ordernumber = 'P200612175814623' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287062'
                WHERE ordernumber = 'P200612180049340' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395753'
                WHERE ordernumber = 'P200612181012579' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246342'
                WHERE ordernumber = 'P180612181433489' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394393'
                WHERE ordernumber = 'P190612181452464' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328908'
                WHERE ordernumber = 'P630612181535394' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395755'
                WHERE ordernumber = 'P180612181552464' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395756'
                WHERE ordernumber = 'P200612181636627' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394393'
                WHERE ordernumber = 'P190612181727249' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395758'
                WHERE ordernumber = 'P180612181846493' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227031'
                WHERE ordernumber = 'P180612182047120' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395759'
                WHERE ordernumber = 'P200612182226327' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366199'
                WHERE ordernumber = 'P180612182300198' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276292'
                WHERE ordernumber = 'P200612182444726' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395760'
                WHERE ordernumber = 'P420612182703166' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '196771'
                WHERE ordernumber = 'P180612182710739' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395761'
                WHERE ordernumber = 'P180612182740394' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394121'
                WHERE ordernumber = 'P420612183121445' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395763'
                WHERE ordernumber = 'P420612183335952' 
            
2024-06-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338493'
                WHERE ordernumber = 'P200612183749952' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395764'
                WHERE ordernumber = 'P420612183926152' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393981'
                WHERE ordernumber = 'P200612184010985' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394614'
                WHERE ordernumber = 'P200612184230468' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394614'
                WHERE ordernumber = 'P200612184731542' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128516'
                WHERE ordernumber = 'P190612185140740' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395766'
                WHERE ordernumber = 'P200612185154151' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169372'
                WHERE ordernumber = 'P190612185245158' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173346'
                WHERE ordernumber = 'P710612185414426' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244161'
                WHERE ordernumber = 'P200612185730704' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395767'
                WHERE ordernumber = 'P190612190025636' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395233'
                WHERE ordernumber = 'P200612190029908' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '37498'
                WHERE ordernumber = 'P190612190154704' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395768'
                WHERE ordernumber = 'P200612190331766' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238393'
                WHERE ordernumber = 'P200612190843557' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141799'
                WHERE ordernumber = 'P200612190949971' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141799'
                WHERE ordernumber = 'P200612191006978' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395769'
                WHERE ordernumber = 'P200612191211298' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395770'
                WHERE ordernumber = 'P200612191417416' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289992'
                WHERE ordernumber = 'P200612191607811' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275636'
                WHERE ordernumber = 'P200612191710913' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94486'
                WHERE ordernumber = 'P200612191840272' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395771'
                WHERE ordernumber = 'P200612192550600' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395772'
                WHERE ordernumber = 'P200612192908224' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395773'
                WHERE ordernumber = 'P200612193037170' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364137'
                WHERE ordernumber = 'P200612193230284' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395775'
                WHERE ordernumber = 'P780612193941742' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395776'
                WHERE ordernumber = 'P200612194108242' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395777'
                WHERE ordernumber = 'P200612194720489' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395779'
                WHERE ordernumber = 'P200612194901235' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395781'
                WHERE ordernumber = 'P190612195028397' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395782'
                WHERE ordernumber = 'P200612195130967' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391271'
                WHERE ordernumber = 'P200612195300317' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395780'
                WHERE ordernumber = 'P780612195422964' 
            
2024-06-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395784'
                WHERE ordernumber = 'P780612195758836'