2024-02-21 01:00:02 -- 將會員中心id寫入data-lake
2024-02-21 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-02-20%';
        
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378148'
                WHERE ordernumber = 'P420220110250467' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '215054'
                WHERE ordernumber = 'P190220110325183' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378149'
                WHERE ordernumber = 'P180220110433198' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208557'
                WHERE ordernumber = 'P190220110442950' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344411'
                WHERE ordernumber = 'P180220110937805' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378150'
                WHERE ordernumber = 'P180220111036967' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275889'
                WHERE ordernumber = 'P190220111104190' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378149'
                WHERE ordernumber = 'P180220111114317' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180220111315460' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378151'
                WHERE ordernumber = 'P420220111653279' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378153'
                WHERE ordernumber = 'P180220111938918' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213327'
                WHERE ordernumber = 'P200220111958863' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378154'
                WHERE ordernumber = 'P420220112258938' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351402'
                WHERE ordernumber = 'P180220112702471' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283209'
                WHERE ordernumber = 'P180220112838345' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378155'
                WHERE ordernumber = 'P200220113230822' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102473'
                WHERE ordernumber = 'P190220115041388' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378158'
                WHERE ordernumber = 'P180220115105138' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344536'
                WHERE ordernumber = 'P180220115145281' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378159'
                WHERE ordernumber = 'P200220115350415' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378160'
                WHERE ordernumber = 'P180220120112911' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349895'
                WHERE ordernumber = 'P200220120635394' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378162'
                WHERE ordernumber = 'P180220121348922' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294766'
                WHERE ordernumber = 'P180220121634799' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372264'
                WHERE ordernumber = 'P420220122059832' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98135'
                WHERE ordernumber = 'P200220122104614' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278549'
                WHERE ordernumber = 'P200220122213345' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301918'
                WHERE ordernumber = 'P420220122721767' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378164'
                WHERE ordernumber = 'P200220122918296' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378165'
                WHERE ordernumber = 'P180220123245952' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378166'
                WHERE ordernumber = 'P200220123447442' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377372'
                WHERE ordernumber = 'P190220123900697' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378170'
                WHERE ordernumber = 'P420220124236343' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378169'
                WHERE ordernumber = 'P200220124247231' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377742'
                WHERE ordernumber = 'P180220124714510' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377466'
                WHERE ordernumber = 'P420220124853688' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378171'
                WHERE ordernumber = 'P420220125106235' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287602'
                WHERE ordernumber = 'P190220125727521' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305490'
                WHERE ordernumber = 'P190220125831933' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296906'
                WHERE ordernumber = 'P420220130041949' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374762'
                WHERE ordernumber = 'P190220130132424' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222810'
                WHERE ordernumber = 'P200220131245768' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226599'
                WHERE ordernumber = 'P420220131839182' 
            
2024-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378173'
                WHERE ordernumber = 'P180220132046990' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378175'
                WHERE ordernumber = 'P180220132427446' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378174'
                WHERE ordernumber = 'P420220132432645' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378176'
                WHERE ordernumber = 'P200220132516791' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306525'
                WHERE ordernumber = 'P420220132545648' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378177'
                WHERE ordernumber = 'P180220132611530' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376163'
                WHERE ordernumber = 'P420220132640613' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280382'
                WHERE ordernumber = 'P200220132841166' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377582'
                WHERE ordernumber = 'P200220132930427' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354821'
                WHERE ordernumber = 'P200220133850393' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378178'
                WHERE ordernumber = 'P180220133900685' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378179'
                WHERE ordernumber = 'P200220133943734' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219324'
                WHERE ordernumber = 'P180220134249554' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358693'
                WHERE ordernumber = 'P180220134416665' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378168'
                WHERE ordernumber = 'P200220134523455' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378168'
                WHERE ordernumber = 'P200220134539741' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378168'
                WHERE ordernumber = 'P200220134832933' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300090'
                WHERE ordernumber = 'P180220134900671' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378182'
                WHERE ordernumber = 'P200220135120542' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230984'
                WHERE ordernumber = 'P200220135244903' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378183'
                WHERE ordernumber = 'P180220135457476' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88518'
                WHERE ordernumber = 'P180220135614874' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253344'
                WHERE ordernumber = 'P200220135705926' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378186'
                WHERE ordernumber = 'P180220140735239' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378188'
                WHERE ordernumber = 'P180220140940865' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378188'
                WHERE ordernumber = 'P180220141149928' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311888'
                WHERE ordernumber = 'P200220141248321' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378188'
                WHERE ordernumber = 'P180220141252240' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278020'
                WHERE ordernumber = 'P180220141354743' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278020'
                WHERE ordernumber = 'P180220141526175' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378189'
                WHERE ordernumber = 'P180220142423267' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378190'
                WHERE ordernumber = 'P420220143539447' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378192'
                WHERE ordernumber = 'P190220144100639' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378193'
                WHERE ordernumber = 'P190220144344813' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378194'
                WHERE ordernumber = 'P420220144719394' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329178'
                WHERE ordernumber = 'P420220145115793' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88926'
                WHERE ordernumber = 'P180220145525958' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344318'
                WHERE ordernumber = 'P420220145532486' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271259'
                WHERE ordernumber = 'P200220145647247' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378197'
                WHERE ordernumber = 'P190220150138843' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312702'
                WHERE ordernumber = 'P180220151255464' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239380'
                WHERE ordernumber = 'P180220151631150' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378198'
                WHERE ordernumber = 'P180220151759308' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350922'
                WHERE ordernumber = 'P180220151917214' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286579'
                WHERE ordernumber = 'P200220151939373' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93404'
                WHERE ordernumber = 'P180220153047748' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375802'
                WHERE ordernumber = 'P180220153307619' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107770'
                WHERE ordernumber = 'P180220153633368' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378204'
                WHERE ordernumber = 'P420220153916696' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276353'
                WHERE ordernumber = 'P200220154058477' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378207'
                WHERE ordernumber = 'P180220155146527' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358690'
                WHERE ordernumber = 'P180220155311763' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208574'
                WHERE ordernumber = 'P180220155753797' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378208'
                WHERE ordernumber = 'P420220160301654' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102058'
                WHERE ordernumber = 'P200220161438921' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P420220161452559' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378210'
                WHERE ordernumber = 'P200220161755849' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262763'
                WHERE ordernumber = 'P180220161954384' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253541'
                WHERE ordernumber = 'P180220162251968' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378211'
                WHERE ordernumber = 'P180220162358722' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146192'
                WHERE ordernumber = 'P180220162647696' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378212'
                WHERE ordernumber = 'P180220162833584' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326214'
                WHERE ordernumber = 'P180220163207993' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357592'
                WHERE ordernumber = 'P200220163957201' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378213'
                WHERE ordernumber = 'P200220164117330' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79422'
                WHERE ordernumber = 'P180220164238953' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97572'
                WHERE ordernumber = 'P200220164652381' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378214'
                WHERE ordernumber = 'P200220165538672' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378215'
                WHERE ordernumber = 'P420220170154973' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378216'
                WHERE ordernumber = 'P420220170620407' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378215'
                WHERE ordernumber = 'P420220171046435' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272413'
                WHERE ordernumber = 'P190220171440482' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378217'
                WHERE ordernumber = 'P180220171922804' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378218'
                WHERE ordernumber = 'P200220172204207' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378219'
                WHERE ordernumber = 'P420220172728524' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378220'
                WHERE ordernumber = 'P180220172800664' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309009'
                WHERE ordernumber = 'P420220172903980' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377702'
                WHERE ordernumber = 'P180220173005172' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214777'
                WHERE ordernumber = 'P200220173015681' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76805'
                WHERE ordernumber = 'P180220173101168' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378221'
                WHERE ordernumber = 'P420220173113301' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378222'
                WHERE ordernumber = 'P200220173330866' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378224'
                WHERE ordernumber = 'P200220173752254' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378225'
                WHERE ordernumber = 'P420220173908289' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378226'
                WHERE ordernumber = 'P200220174028450' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378227'
                WHERE ordernumber = 'P420220174206566' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345427'
                WHERE ordernumber = 'P190220174352510' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '6964'
                WHERE ordernumber = 'P420220174802564' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377278'
                WHERE ordernumber = 'P180220174926352' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130125'
                WHERE ordernumber = 'P190220175315131' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378231'
                WHERE ordernumber = 'P190220175504185' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211568'
                WHERE ordernumber = 'P180220175606382' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222473'
                WHERE ordernumber = 'P420220175913159' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377776'
                WHERE ordernumber = 'P180220180022309' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378232'
                WHERE ordernumber = 'P420220180156258' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328280'
                WHERE ordernumber = 'P180220180903664' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229560'
                WHERE ordernumber = 'P180220180947194' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378233'
                WHERE ordernumber = 'P200220181118636' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280902'
                WHERE ordernumber = 'P200220182131395' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275218'
                WHERE ordernumber = 'P180220182341735' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378234'
                WHERE ordernumber = 'P420220182418811' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378235'
                WHERE ordernumber = 'P180220182541580' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277994'
                WHERE ordernumber = 'P200220182704189' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340787'
                WHERE ordernumber = 'P200220182828756' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378236'
                WHERE ordernumber = 'P420220182902473' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216076'
                WHERE ordernumber = 'P200220182951378' 
            
2024-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306570'
                WHERE ordernumber = 'P180220183031889' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368945'
                WHERE ordernumber = 'P200220183055855' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305075'
                WHERE ordernumber = 'P200220183226448' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378238'
                WHERE ordernumber = 'P420220183241367' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140770'
                WHERE ordernumber = 'P420220183407660' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217309'
                WHERE ordernumber = 'P200220183527905' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378239'
                WHERE ordernumber = 'P200220183644584' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283374'
                WHERE ordernumber = 'P180220184028152' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245088'
                WHERE ordernumber = 'P200220184049840' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378241'
                WHERE ordernumber = 'P180220184648894' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378243'
                WHERE ordernumber = 'P200220185509761' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378244'
                WHERE ordernumber = 'P200220185610266' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378245'
                WHERE ordernumber = 'P420220190224732' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378249'
                WHERE ordernumber = 'P200220191822258' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283857'
                WHERE ordernumber = 'P190220193314912' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378250'
                WHERE ordernumber = 'P190220193701309' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353079'
                WHERE ordernumber = 'P190220193936912' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366944'
                WHERE ordernumber = 'P420220194048382' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162779'
                WHERE ordernumber = 'P420220194554779' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378254'
                WHERE ordernumber = 'P190220194945511' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141295'
                WHERE ordernumber = 'P200220195004576' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378256'
                WHERE ordernumber = 'P420220195118602' 
            
2024-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167865'
                WHERE ordernumber = 'P200220200234764'