2024-06-15 01:00:02 -- 將會員中心id寫入data-lake
2024-06-15 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-06-14%';
        
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94004'
                WHERE ordernumber = 'P630614101848667' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384334'
                WHERE ordernumber = 'P630614102231630' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216899'
                WHERE ordernumber = 'P200614110106559' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241208'
                WHERE ordernumber = 'P200614110231471' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149035'
                WHERE ordernumber = 'P190614110336251' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255812'
                WHERE ordernumber = 'P180614110452194' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395940'
                WHERE ordernumber = 'P180614110649349' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395941'
                WHERE ordernumber = 'P180614110753691' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109673'
                WHERE ordernumber = 'P180614111047446' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395942'
                WHERE ordernumber = 'P780614111333394' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146031'
                WHERE ordernumber = 'P190614111440753' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395943'
                WHERE ordernumber = 'P190614111508263' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279874'
                WHERE ordernumber = 'P200614111803758' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395944'
                WHERE ordernumber = 'P200614111903967' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395945'
                WHERE ordernumber = 'P180614112336797' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96893'
                WHERE ordernumber = 'P180614112414132' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395946'
                WHERE ordernumber = 'P190614112541228' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395948'
                WHERE ordernumber = 'P200614112616623' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263058'
                WHERE ordernumber = 'P200614112944941' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392894'
                WHERE ordernumber = 'P180614113009377' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392894'
                WHERE ordernumber = 'P180614113108432' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395932'
                WHERE ordernumber = 'P180614113807838' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393246'
                WHERE ordernumber = 'P420614114019741' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218548'
                WHERE ordernumber = 'P200614114358207' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365771'
                WHERE ordernumber = 'P180614115256729' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394714'
                WHERE ordernumber = 'P190614115309662' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395954'
                WHERE ordernumber = 'P180614115656164' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324137'
                WHERE ordernumber = 'P420614115718331' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '54285'
                WHERE ordernumber = 'P200614120525871' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376026'
                WHERE ordernumber = 'P180614120824824' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376026'
                WHERE ordernumber = 'P180614120838714' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395955'
                WHERE ordernumber = 'P420614120955235' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395957'
                WHERE ordernumber = 'P190614121409515' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386263'
                WHERE ordernumber = 'P180614122012702' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394547'
                WHERE ordernumber = 'P180614122332297' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281601'
                WHERE ordernumber = 'P180614122447905' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368838'
                WHERE ordernumber = 'P420614122539973' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395960'
                WHERE ordernumber = 'P190614122714225' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217445'
                WHERE ordernumber = 'P180614122826287' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217445'
                WHERE ordernumber = 'P180614122947628' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108227'
                WHERE ordernumber = 'P180614123450552' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395963'
                WHERE ordernumber = 'P190614123636419' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395962'
                WHERE ordernumber = 'P200614123649554' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395964'
                WHERE ordernumber = 'P200614123826417' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108997'
                WHERE ordernumber = 'P200614124050802' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395965'
                WHERE ordernumber = 'P180614124152970' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262488'
                WHERE ordernumber = 'P420614124221176' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395966'
                WHERE ordernumber = 'P200614124223679' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395967'
                WHERE ordernumber = 'P200614124543828' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318957'
                WHERE ordernumber = 'P420614125353219' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114534'
                WHERE ordernumber = 'P180614125734550' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395969'
                WHERE ordernumber = 'P180614130214959' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395970'
                WHERE ordernumber = 'P180614130613663' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '78136'
                WHERE ordernumber = 'P180614130711534' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383434'
                WHERE ordernumber = 'P420614130815263' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395971'
                WHERE ordernumber = 'P420614130951973' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369330'
                WHERE ordernumber = 'P420614131528864' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381601'
                WHERE ordernumber = 'P420614132241138' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395973'
                WHERE ordernumber = 'P180614132830701' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395974'
                WHERE ordernumber = 'P630614133244185' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378896'
                WHERE ordernumber = 'P420614133349996' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210678'
                WHERE ordernumber = 'P180614133354335' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302695'
                WHERE ordernumber = 'P180614133624223' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395975'
                WHERE ordernumber = 'P180614133937328' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285872'
                WHERE ordernumber = 'P200614134254743' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294305'
                WHERE ordernumber = 'P180614134712581' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395976'
                WHERE ordernumber = 'P180614135406307' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395977'
                WHERE ordernumber = 'P420614135707657' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384245'
                WHERE ordernumber = 'P200614135747308' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293866'
                WHERE ordernumber = 'P420614140025643' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334506'
                WHERE ordernumber = 'P420614140435157' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354293'
                WHERE ordernumber = 'P190614141242297' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227407'
                WHERE ordernumber = 'P630614141313121' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383660'
                WHERE ordernumber = 'P200614141733770' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395978'
                WHERE ordernumber = 'P630614142042745' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208654'
                WHERE ordernumber = 'P180614142249395' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395979'
                WHERE ordernumber = 'P780614142351781' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315096'
                WHERE ordernumber = 'P200614142359454' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382609'
                WHERE ordernumber = 'P420614142730510' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296849'
                WHERE ordernumber = 'P420614143744393' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342873'
                WHERE ordernumber = 'P420614143959508' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395981'
                WHERE ordernumber = 'P420614144314416' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395518'
                WHERE ordernumber = 'P180614144626260' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395983'
                WHERE ordernumber = 'P180614145512757' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274368'
                WHERE ordernumber = 'P190614145617794' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395984'
                WHERE ordernumber = 'P420614145620133' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319979'
                WHERE ordernumber = 'P180614145630335' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347511'
                WHERE ordernumber = 'P200614145744686' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219719'
                WHERE ordernumber = 'P420614145805553' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274368'
                WHERE ordernumber = 'P190614145942455' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395985'
                WHERE ordernumber = 'P420614145950469' 
            
2024-06-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395986'
                WHERE ordernumber = 'P180614150522552' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395987'
                WHERE ordernumber = 'P180614150806942' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377600'
                WHERE ordernumber = 'P180614151031981' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395988'
                WHERE ordernumber = 'P420614151620879' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350014'
                WHERE ordernumber = 'P200614151746900' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395989'
                WHERE ordernumber = 'P180614151852566' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395990'
                WHERE ordernumber = 'P180614151953342' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395991'
                WHERE ordernumber = 'P190614152010341' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370926'
                WHERE ordernumber = 'P420614152059796' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308401'
                WHERE ordernumber = 'P180614152204266' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216159'
                WHERE ordernumber = 'P200614152213975' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395993'
                WHERE ordernumber = 'P180614152804411' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394355'
                WHERE ordernumber = 'P420614152846547' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395994'
                WHERE ordernumber = 'P190614153251925' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395995'
                WHERE ordernumber = 'P190614153433733' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395996'
                WHERE ordernumber = 'P420614153544571' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395998'
                WHERE ordernumber = 'P180614153821866' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395999'
                WHERE ordernumber = 'P200614153903907' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396001'
                WHERE ordernumber = 'P180614154605968' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62067'
                WHERE ordernumber = 'P200614154932155' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62067'
                WHERE ordernumber = 'P200614155017701' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396002'
                WHERE ordernumber = 'P420614155039137' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82231'
                WHERE ordernumber = 'P200614155122574' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396004'
                WHERE ordernumber = 'P180614155123155' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395961'
                WHERE ordernumber = 'P420614155618251' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396005'
                WHERE ordernumber = 'P200614155815707' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396006'
                WHERE ordernumber = 'P180614155951703' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339493'
                WHERE ordernumber = 'P200614160201425' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396007'
                WHERE ordernumber = 'P200614160331386' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306708'
                WHERE ordernumber = 'P180614160510899' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306708'
                WHERE ordernumber = 'P180614160523490' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385057'
                WHERE ordernumber = 'P420614160709791' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P180614160939829' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314008'
                WHERE ordernumber = 'P420614161039739' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246060'
                WHERE ordernumber = 'P190614161759475' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341087'
                WHERE ordernumber = 'P190614162022496' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396009'
                WHERE ordernumber = 'P200614162237627' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210370'
                WHERE ordernumber = 'P190614162423989' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395853'
                WHERE ordernumber = 'P190614162555486' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P190614162714938' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123629'
                WHERE ordernumber = 'P200614162917579' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81976'
                WHERE ordernumber = 'P190614163234976' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396011'
                WHERE ordernumber = 'P180614163248756' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377355'
                WHERE ordernumber = 'P420614163452341' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264650'
                WHERE ordernumber = 'P180614163633254' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396012'
                WHERE ordernumber = 'P420614164153462' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324164'
                WHERE ordernumber = 'P200614164206317' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396013'
                WHERE ordernumber = 'P180614164415977' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149109'
                WHERE ordernumber = 'P200614164519446' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320456'
                WHERE ordernumber = 'P200614165254894' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217089'
                WHERE ordernumber = 'P190614165650378' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396014'
                WHERE ordernumber = 'P190614165832240' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266459'
                WHERE ordernumber = 'P630614165906884' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396015'
                WHERE ordernumber = 'P200614170254268' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396016'
                WHERE ordernumber = 'P190614170341479' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395173'
                WHERE ordernumber = 'P190614170556177' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396017'
                WHERE ordernumber = 'P420614170745810' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294088'
                WHERE ordernumber = 'P190614170807699' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215819'
                WHERE ordernumber = 'P200614170830232' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396018'
                WHERE ordernumber = 'P190614171023338' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395802'
                WHERE ordernumber = 'P190614171104212' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216234'
                WHERE ordernumber = 'P190614171308493' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396019'
                WHERE ordernumber = 'P180614171407759' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395178'
                WHERE ordernumber = 'P420614171443200' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387346'
                WHERE ordernumber = 'P180614171724532' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396020'
                WHERE ordernumber = 'P780614172014963' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253145'
                WHERE ordernumber = 'P180614172046855' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386423'
                WHERE ordernumber = 'P200614173102296' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396021'
                WHERE ordernumber = 'P180614173107734' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252055'
                WHERE ordernumber = 'P200614173401130' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396023'
                WHERE ordernumber = 'P420614173435466' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139727'
                WHERE ordernumber = 'P200614173729621' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389586'
                WHERE ordernumber = 'P200614173811753' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353104'
                WHERE ordernumber = 'P180614174130950' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352419'
                WHERE ordernumber = 'P200614174339353' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154308'
                WHERE ordernumber = 'P180614174435551' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259307'
                WHERE ordernumber = 'P180614174643788' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352052'
                WHERE ordernumber = 'P200614174649143' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87107'
                WHERE ordernumber = 'P180614174814507' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219723'
                WHERE ordernumber = 'P200614175244392' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328377'
                WHERE ordernumber = 'P180614175332312' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396024'
                WHERE ordernumber = 'P180614175459343' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255493'
                WHERE ordernumber = 'P190614175538318' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396025'
                WHERE ordernumber = 'P420614175602586' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P200614175633936' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396026'
                WHERE ordernumber = 'P200614175825293' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396027'
                WHERE ordernumber = 'P200614175952457' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381521'
                WHERE ordernumber = 'P180614180152511' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396028'
                WHERE ordernumber = 'P420614180702157' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396030'
                WHERE ordernumber = 'P180614181139750' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395885'
                WHERE ordernumber = 'P420614181159274' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396031'
                WHERE ordernumber = 'P200614181213366' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146845'
                WHERE ordernumber = 'P630614181247123' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307262'
                WHERE ordernumber = 'P200614181253505' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396032'
                WHERE ordernumber = 'P420614181756226' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396033'
                WHERE ordernumber = 'P200614181910301' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225398'
                WHERE ordernumber = 'P180614181918320' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396034'
                WHERE ordernumber = 'P200614182000342' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298889'
                WHERE ordernumber = 'P420614182109211' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396035'
                WHERE ordernumber = 'P630614182901156' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99103'
                WHERE ordernumber = 'P200614182954780' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290059'
                WHERE ordernumber = 'P420614183308603' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396037'
                WHERE ordernumber = 'P200614183700183' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244882'
                WHERE ordernumber = 'P180614183918719' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136008'
                WHERE ordernumber = 'P200614183958340' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396038'
                WHERE ordernumber = 'P630614184107391' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206606'
                WHERE ordernumber = 'P420614184646477' 
            
2024-06-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210763'
                WHERE ordernumber = 'P190614184856953' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395922'
                WHERE ordernumber = 'P420614185111436' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396039'
                WHERE ordernumber = 'P200614185146260' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396040'
                WHERE ordernumber = 'P200614185340622' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396041'
                WHERE ordernumber = 'P190614185430651' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271196'
                WHERE ordernumber = 'P190614185826436' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238186'
                WHERE ordernumber = 'P200614185948464' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336162'
                WHERE ordernumber = 'P420614190523460' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396044'
                WHERE ordernumber = 'P200614190834989' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358676'
                WHERE ordernumber = 'P200614191309626' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236530'
                WHERE ordernumber = 'P200614191353342' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396045'
                WHERE ordernumber = 'P200614191447340' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396046'
                WHERE ordernumber = 'P190614191914196' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344787'
                WHERE ordernumber = 'P190614191954638' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385716'
                WHERE ordernumber = 'P630614192226627' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396029'
                WHERE ordernumber = 'P190614193759926' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396048'
                WHERE ordernumber = 'P200614194034608' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228228'
                WHERE ordernumber = 'P190614194039362' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396049'
                WHERE ordernumber = 'P200614194111818' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396050'
                WHERE ordernumber = 'P190614194546738' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291714'
                WHERE ordernumber = 'P200614194845580' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93448'
                WHERE ordernumber = 'P200614195150527' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '77648'
                WHERE ordernumber = 'P200614195303916' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386761'
                WHERE ordernumber = 'P200614195550383' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300331'
                WHERE ordernumber = 'P190614195901968' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '58075'
                WHERE ordernumber = 'P630614200004473' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81119'
                WHERE ordernumber = 'P190614200101682' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396056'
                WHERE ordernumber = 'P630614205803821' 
            
2024-06-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396059'
                WHERE ordernumber = 'P780614211821946'