2023-12-28 01:00:02 -- 將會員中心id寫入data-lake
2023-12-28 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 '2023-12-27%';
        
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353714'
                WHERE ordernumber = 'P181227110401435' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355531'
                WHERE ordernumber = 'P181227110514117' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355531'
                WHERE ordernumber = 'P181227110600409' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355562'
                WHERE ordernumber = 'P181227110650785' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262484'
                WHERE ordernumber = 'P181227110725393' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103003'
                WHERE ordernumber = 'P201227111100489' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300574'
                WHERE ordernumber = 'P181227111110749' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355567'
                WHERE ordernumber = 'P201227111324374' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355569'
                WHERE ordernumber = 'P181227111502624' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355571'
                WHERE ordernumber = 'P181227111554742' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355565'
                WHERE ordernumber = 'P181227111633668' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355565'
                WHERE ordernumber = 'P181227111703665' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353679'
                WHERE ordernumber = 'P191227111934571' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355572'
                WHERE ordernumber = 'P181227111958643' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340888'
                WHERE ordernumber = 'P421227112303913' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291075'
                WHERE ordernumber = 'P181227112616178' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P201227112705670' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '179447'
                WHERE ordernumber = 'P181227112801157' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134896'
                WHERE ordernumber = 'P181227112904111' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126295'
                WHERE ordernumber = 'P181227113230798' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355578'
                WHERE ordernumber = 'P181227113537486' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125242'
                WHERE ordernumber = 'P181227113629238' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311893'
                WHERE ordernumber = 'P201227113721426' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169290'
                WHERE ordernumber = 'P181227113752341' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '735'
                WHERE ordernumber = 'P181227113844712' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355581'
                WHERE ordernumber = 'P201227113847446' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355582'
                WHERE ordernumber = 'P181227113929259' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '44069'
                WHERE ordernumber = 'P191227114200353' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P201227114401725' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351827'
                WHERE ordernumber = 'P181227114835448' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355585'
                WHERE ordernumber = 'P181227115037488' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354335'
                WHERE ordernumber = 'P191227115050165' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355575'
                WHERE ordernumber = 'P421227115126899' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354335'
                WHERE ordernumber = 'P191227115130524' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355586'
                WHERE ordernumber = 'P181227115235147' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353729'
                WHERE ordernumber = 'P201227115438240' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355588'
                WHERE ordernumber = 'P181227115539804' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336569'
                WHERE ordernumber = 'P421227120845525' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355593'
                WHERE ordernumber = 'P181227121201428' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347176'
                WHERE ordernumber = 'P421227121342329' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267840'
                WHERE ordernumber = 'P421227121657613' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329420'
                WHERE ordernumber = 'P181227121730752' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355595'
                WHERE ordernumber = 'P181227122322611' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349704'
                WHERE ordernumber = 'P181227122515395' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355598'
                WHERE ordernumber = 'P421227123001716' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355601'
                WHERE ordernumber = 'P181227123221548' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355603'
                WHERE ordernumber = 'P181227123556649' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240968'
                WHERE ordernumber = 'P201227123652182' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355605'
                WHERE ordernumber = 'P421227123935345' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232257'
                WHERE ordernumber = 'P201227123947585' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355608'
                WHERE ordernumber = 'P421227124224351' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239906'
                WHERE ordernumber = 'P181227125423302' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126335'
                WHERE ordernumber = 'P181227125647290' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236627'
                WHERE ordernumber = 'P201227130035534' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355614'
                WHERE ordernumber = 'P201227130246180' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355613'
                WHERE ordernumber = 'P181227130326490' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355618'
                WHERE ordernumber = 'P181227130937892' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355617'
                WHERE ordernumber = 'P191227130956479' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355620'
                WHERE ordernumber = 'P181227131035635' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340947'
                WHERE ordernumber = 'P421227131042755' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127159'
                WHERE ordernumber = 'P181227131202148' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105833'
                WHERE ordernumber = 'P181227131412330' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271232'
                WHERE ordernumber = 'P181227131602309' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355621'
                WHERE ordernumber = 'P201227131838515' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355623'
                WHERE ordernumber = 'P421227132152327' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335369'
                WHERE ordernumber = 'P201227132213754' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '68003'
                WHERE ordernumber = 'P201227132514961' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355624'
                WHERE ordernumber = 'P201227132604707' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354366'
                WHERE ordernumber = 'P181227132655443' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242005'
                WHERE ordernumber = 'P201227132739671' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355625'
                WHERE ordernumber = 'P201227132826455' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351153'
                WHERE ordernumber = 'P181227133643389' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355627'
                WHERE ordernumber = 'P201227134110794' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355629'
                WHERE ordernumber = 'P201227134327910' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355520'
                WHERE ordernumber = 'P181227134507219' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240185'
                WHERE ordernumber = 'P181227134625402' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65608'
                WHERE ordernumber = 'P201227135106763' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P181227135126787' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116312'
                WHERE ordernumber = 'P201227135148666' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355632'
                WHERE ordernumber = 'P201227135307671' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349895'
                WHERE ordernumber = 'P201227135357468' 
            
2023-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276492'
                WHERE ordernumber = 'P201227135513893' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285249'
                WHERE ordernumber = 'P201227135716300' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296969'
                WHERE ordernumber = 'P421227135804149' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355636'
                WHERE ordernumber = 'P181227135912208' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355637'
                WHERE ordernumber = 'P181227140125712' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259520'
                WHERE ordernumber = 'P201227140210958' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336979'
                WHERE ordernumber = 'P201227140333251' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355638'
                WHERE ordernumber = 'P181227140408574' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270926'
                WHERE ordernumber = 'P201227140423717' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331238'
                WHERE ordernumber = 'P421227140533969' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355639'
                WHERE ordernumber = 'P181227140559151' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355640'
                WHERE ordernumber = 'P181227140704872' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355641'
                WHERE ordernumber = 'P421227140739865' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355640'
                WHERE ordernumber = 'P181227140744462' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166284'
                WHERE ordernumber = 'P181227140850277' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355642'
                WHERE ordernumber = 'P421227140915429' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355644'
                WHERE ordernumber = 'P181227141013320' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355645'
                WHERE ordernumber = 'P201227141037422' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355646'
                WHERE ordernumber = 'P181227141232885' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335294'
                WHERE ordernumber = 'P201227141259426' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355647'
                WHERE ordernumber = 'P181227141414166' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347482'
                WHERE ordernumber = 'P421227141451884' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217463'
                WHERE ordernumber = 'P201227142233436' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355649'
                WHERE ordernumber = 'P181227142448549' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355650'
                WHERE ordernumber = 'P191227142924962' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304074'
                WHERE ordernumber = 'P191227143200855' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355651'
                WHERE ordernumber = 'P181227143425176' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350377'
                WHERE ordernumber = 'P201227143718932' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355659'
                WHERE ordernumber = 'P181227144108426' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354593'
                WHERE ordernumber = 'P421227144142688' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263060'
                WHERE ordernumber = 'P201227144247492' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95203'
                WHERE ordernumber = 'P181227144253290' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355661'
                WHERE ordernumber = 'P181227144426639' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355014'
                WHERE ordernumber = 'P201227144438584' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284747'
                WHERE ordernumber = 'P181227144508674' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355014'
                WHERE ordernumber = 'P201227144537528' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355662'
                WHERE ordernumber = 'P181227144609995' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331499'
                WHERE ordernumber = 'P201227144714865' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355665'
                WHERE ordernumber = 'P201227145031450' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98143'
                WHERE ordernumber = 'P181227145044781' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334962'
                WHERE ordernumber = 'P181227145214807' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355666'
                WHERE ordernumber = 'P181227145341769' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355667'
                WHERE ordernumber = 'P181227145423366' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355668'
                WHERE ordernumber = 'P201227145546205' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355669'
                WHERE ordernumber = 'P181227145607355' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280848'
                WHERE ordernumber = 'P421227145802167' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260168'
                WHERE ordernumber = 'P201227150138626' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355671'
                WHERE ordernumber = 'P181227150255225' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311961'
                WHERE ordernumber = 'P201227150256195' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355673'
                WHERE ordernumber = 'P201227150405678' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338295'
                WHERE ordernumber = 'P181227150608893' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338295'
                WHERE ordernumber = 'P181227150655848' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350319'
                WHERE ordernumber = 'P181227150838592' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355675'
                WHERE ordernumber = 'P421227150919293' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355675'
                WHERE ordernumber = 'P421227151145390' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131857'
                WHERE ordernumber = 'P181227151516949' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355339'
                WHERE ordernumber = 'P201227152134376' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355679'
                WHERE ordernumber = 'P421227152349850' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355408'
                WHERE ordernumber = 'P201227152409342' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349283'
                WHERE ordernumber = 'P181227152438489' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355680'
                WHERE ordernumber = 'P421227152533759' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355573'
                WHERE ordernumber = 'P181227152553761' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355573'
                WHERE ordernumber = 'P181227152624960' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355681'
                WHERE ordernumber = 'P421227152657308' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218335'
                WHERE ordernumber = 'P421227152924222' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346545'
                WHERE ordernumber = 'P181227153017653' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355682'
                WHERE ordernumber = 'P201227153121507' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259990'
                WHERE ordernumber = 'P201227153254946' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355544'
                WHERE ordernumber = 'P181227153446980' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355544'
                WHERE ordernumber = 'P181227153517276' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355683'
                WHERE ordernumber = 'P421227153517790' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348946'
                WHERE ordernumber = 'P201227153532460' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254624'
                WHERE ordernumber = 'P181227153612619' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355684'
                WHERE ordernumber = 'P181227153727689' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342652'
                WHERE ordernumber = 'P181227153830996' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353658'
                WHERE ordernumber = 'P191227154733818' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285872'
                WHERE ordernumber = 'P201227154751684' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209595'
                WHERE ordernumber = 'P181227154756817' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355685'
                WHERE ordernumber = 'P421227154850536' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226816'
                WHERE ordernumber = 'P201227154941677' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355686'
                WHERE ordernumber = 'P191227155002635' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344719'
                WHERE ordernumber = 'P181227155630309' 
            
2023-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355688'
                WHERE ordernumber = 'P201227155712894' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355689'
                WHERE ordernumber = 'P201227155856775' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258581'
                WHERE ordernumber = 'P201227155951645' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355690'
                WHERE ordernumber = 'P181227160032130' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101636'
                WHERE ordernumber = 'P181227160134637' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355693'
                WHERE ordernumber = 'P181227160437553' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101636'
                WHERE ordernumber = 'P181227160603378' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355694'
                WHERE ordernumber = 'P201227160911203' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355695'
                WHERE ordernumber = 'P421227161110541' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100515'
                WHERE ordernumber = 'P191227161356950' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96134'
                WHERE ordernumber = 'P181227161737761' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334953'
                WHERE ordernumber = 'P421227161854610' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '224147'
                WHERE ordernumber = 'P201227162119452' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337234'
                WHERE ordernumber = 'P201227162252266' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258511'
                WHERE ordernumber = 'P181227162336982' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212547'
                WHERE ordernumber = 'P181227162522525' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351275'
                WHERE ordernumber = 'P421227162526706' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166214'
                WHERE ordernumber = 'P181227162645387' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167301'
                WHERE ordernumber = 'P181227162707427' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355698'
                WHERE ordernumber = 'P201227163020420' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227749'
                WHERE ordernumber = 'P201227163218295' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '108952'
                WHERE ordernumber = 'P201227163435922' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345622'
                WHERE ordernumber = 'P201227163912902' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229917'
                WHERE ordernumber = 'P181227164331727' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355701'
                WHERE ordernumber = 'P181227164623708' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355702'
                WHERE ordernumber = 'P201227164943236' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '46645'
                WHERE ordernumber = 'P421227165014622' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355703'
                WHERE ordernumber = 'P201227165102149' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '244056'
                WHERE ordernumber = 'P181227165109487' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355704'
                WHERE ordernumber = 'P181227165242322' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355705'
                WHERE ordernumber = 'P201227165301900' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355706'
                WHERE ordernumber = 'P201227165420226' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '147009'
                WHERE ordernumber = 'P181227165443599' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355708'
                WHERE ordernumber = 'P201227165911373' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355709'
                WHERE ordernumber = 'P421227170236986' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225398'
                WHERE ordernumber = 'P181227170247340' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347068'
                WHERE ordernumber = 'P201227170341268' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127611'
                WHERE ordernumber = 'P181227170408847' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355710'
                WHERE ordernumber = 'P421227170629203' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347068'
                WHERE ordernumber = 'P201227170945807' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105101'
                WHERE ordernumber = 'P181227171010132' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '243888'
                WHERE ordernumber = 'P201227171039553' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P181227171105684' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128240'
                WHERE ordernumber = 'P191227171143659' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355713'
                WHERE ordernumber = 'P421227171225714' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128240'
                WHERE ordernumber = 'P191227171300612' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355714'
                WHERE ordernumber = 'P421227172359813' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355715'
                WHERE ordernumber = 'P201227172543987' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '146294'
                WHERE ordernumber = 'P421227172827636' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355716'
                WHERE ordernumber = 'P181227172856849' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298816'
                WHERE ordernumber = 'P181227173004767' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355717'
                WHERE ordernumber = 'P181227173157652' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '261980'
                WHERE ordernumber = 'P201227173157929' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281701'
                WHERE ordernumber = 'P181227173232687' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355718'
                WHERE ordernumber = 'P191227173312196' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '146294'
                WHERE ordernumber = 'P421227173331279' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355719'
                WHERE ordernumber = 'P201227173334174' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355720'
                WHERE ordernumber = 'P201227173454691' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299744'
                WHERE ordernumber = 'P201227173808487' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348263'
                WHERE ordernumber = 'P421227174018753' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355502'
                WHERE ordernumber = 'P191227174054450' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355721'
                WHERE ordernumber = 'P421227174148722' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '112916'
                WHERE ordernumber = 'P181227174537692' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355723'
                WHERE ordernumber = 'P421227174829909' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295562'
                WHERE ordernumber = 'P201227175031769' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355726'
                WHERE ordernumber = 'P181227175412150' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355727'
                WHERE ordernumber = 'P181227175522552' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355728'
                WHERE ordernumber = 'P201227175639462' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355729'
                WHERE ordernumber = 'P421227175739430' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345799'
                WHERE ordernumber = 'P181227175826461' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355730'
                WHERE ordernumber = 'P181227180056585' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288844'
                WHERE ordernumber = 'P201227180104935' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355731'
                WHERE ordernumber = 'P181227180229356' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351131'
                WHERE ordernumber = 'P181227180407134' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355732'
                WHERE ordernumber = 'P181227180900397' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355211'
                WHERE ordernumber = 'P421227181138788' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340951'
                WHERE ordernumber = 'P201227181554803' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222613'
                WHERE ordernumber = 'P181227182013680' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345063'
                WHERE ordernumber = 'P181227182134331' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355737'
                WHERE ordernumber = 'P181227182337290' 
            
2023-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355739'
                WHERE ordernumber = 'P181227182545356' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355742'
                WHERE ordernumber = 'P421227183113460' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '277610'
                WHERE ordernumber = 'P201227183120823' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355743'
                WHERE ordernumber = 'P421227183240135' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355744'
                WHERE ordernumber = 'P201227183718138' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '235017'
                WHERE ordernumber = 'P201227184052674' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355746'
                WHERE ordernumber = 'P421227184339698' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '162042'
                WHERE ordernumber = 'P181227184346652' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355747'
                WHERE ordernumber = 'P201227185138475' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355748'
                WHERE ordernumber = 'P421227185233384' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '266525'
                WHERE ordernumber = 'P201227185541795' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355751'
                WHERE ordernumber = 'P201227185710639' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352453'
                WHERE ordernumber = 'P181227185712279' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355752'
                WHERE ordernumber = 'P181227185845222' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355741'
                WHERE ordernumber = 'P181227190129893' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355751'
                WHERE ordernumber = 'P201227190227412' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355741'
                WHERE ordernumber = 'P181227190230908' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355741'
                WHERE ordernumber = 'P181227190305259' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96897'
                WHERE ordernumber = 'P181227190417544' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '315558'
                WHERE ordernumber = 'P421227190420799' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '19835'
                WHERE ordernumber = 'P201227190509155' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '276033'
                WHERE ordernumber = 'P201227190534848' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353529'
                WHERE ordernumber = 'P421227190617811' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355751'
                WHERE ordernumber = 'P201227190700424' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355756'
                WHERE ordernumber = 'P181227190848833' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '317935'
                WHERE ordernumber = 'P181227190949586' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346054'
                WHERE ordernumber = 'P191227191204334' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355757'
                WHERE ordernumber = 'P191227191528588' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355758'
                WHERE ordernumber = 'P191227191648735' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '81699'
                WHERE ordernumber = 'P191227191744687' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355759'
                WHERE ordernumber = 'P191227192040757' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355762'
                WHERE ordernumber = 'P191227192251115' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '246747'
                WHERE ordernumber = 'P191227192740129' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355765'
                WHERE ordernumber = 'P191227193301279' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '98302'
                WHERE ordernumber = 'P201227193311908' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355766'
                WHERE ordernumber = 'P201227193407845' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355768'
                WHERE ordernumber = 'P201227193506414' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '280643'
                WHERE ordernumber = 'P201227193655965' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355769'
                WHERE ordernumber = 'P191227193709474' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355767'
                WHERE ordernumber = 'P201227193800358' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355770'
                WHERE ordernumber = 'P191227193847507' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355771'
                WHERE ordernumber = 'P201227193950514' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355773'
                WHERE ordernumber = 'P191227194200316' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355775'
                WHERE ordernumber = 'P191227194429767' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355778'
                WHERE ordernumber = 'P191227194928686' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351240'
                WHERE ordernumber = 'P201227195334365' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '115561'
                WHERE ordernumber = 'P191227195457270' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355780'
                WHERE ordernumber = 'P201227195716382' 
            
2023-12-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '355782'
                WHERE ordernumber = 'P201227195834641'