2024-08-02 01:00:02 -- 將會員中心id寫入data-lake
2024-08-02 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-08-01%';
        
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278592'
                WHERE ordernumber = 'P200801110209569' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353694'
                WHERE ordernumber = 'P180801110410913' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404483'
                WHERE ordernumber = 'P200801110417999' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404487'
                WHERE ordernumber = 'P180801111027966' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404488'
                WHERE ordernumber = 'P420801111133154' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401915'
                WHERE ordernumber = 'P420801111235220' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253287'
                WHERE ordernumber = 'P180801111716787' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326311'
                WHERE ordernumber = 'P420801111855667' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367152'
                WHERE ordernumber = 'P180801112226192' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404494'
                WHERE ordernumber = 'P200801112240590' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404497'
                WHERE ordernumber = 'P200801112537417' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404493'
                WHERE ordernumber = 'P420801112710686' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404499'
                WHERE ordernumber = 'P420801113248288' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105536'
                WHERE ordernumber = 'P190801113701796' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '1540'
                WHERE ordernumber = 'P180801114005432' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404501'
                WHERE ordernumber = 'P200801114129247' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238127'
                WHERE ordernumber = 'P420801114303393' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404503'
                WHERE ordernumber = 'P180801114639724' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404497'
                WHERE ordernumber = 'P200801114851499' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404505'
                WHERE ordernumber = 'P190801114854851' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232297'
                WHERE ordernumber = 'P200801114933732' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404506'
                WHERE ordernumber = 'P180801115014964' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403632'
                WHERE ordernumber = 'P420801115035605' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112237'
                WHERE ordernumber = 'P180801115200834' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392578'
                WHERE ordernumber = 'P200801115220178' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404507'
                WHERE ordernumber = 'P420801115413505' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404509'
                WHERE ordernumber = 'P420801120121914' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404510'
                WHERE ordernumber = 'P420801120336742' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267354'
                WHERE ordernumber = 'P420801121652381' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404513'
                WHERE ordernumber = 'P180801121731691' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276237'
                WHERE ordernumber = 'P420801121808311' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363317'
                WHERE ordernumber = 'P200801122638593' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404515'
                WHERE ordernumber = 'P420801122751172' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404516'
                WHERE ordernumber = 'P420801123214297' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404292'
                WHERE ordernumber = 'P180801123310287' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303905'
                WHERE ordernumber = 'P420801123416897' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316945'
                WHERE ordernumber = 'P200801123539752' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388814'
                WHERE ordernumber = 'P420801123715398' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404520'
                WHERE ordernumber = 'P420801124226237' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404521'
                WHERE ordernumber = 'P200801124729609' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404523'
                WHERE ordernumber = 'P180801124830704' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404524'
                WHERE ordernumber = 'P200801125159655' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404525'
                WHERE ordernumber = 'P180801125624957' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404527'
                WHERE ordernumber = 'P420801130102654' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308592'
                WHERE ordernumber = 'P420801130153685' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404528'
                WHERE ordernumber = 'P200801130659457' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404529'
                WHERE ordernumber = 'P420801130754640' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113370'
                WHERE ordernumber = 'P190801130810195' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390002'
                WHERE ordernumber = 'P200801130846491' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321668'
                WHERE ordernumber = 'P420801131019555' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331741'
                WHERE ordernumber = 'P180801131027431' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404532'
                WHERE ordernumber = 'P420801131513369' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354485'
                WHERE ordernumber = 'P180801131523649' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286100'
                WHERE ordernumber = 'P190801131613302' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404533'
                WHERE ordernumber = 'P420801131804247' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404535'
                WHERE ordernumber = 'P420801131953812' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '45072'
                WHERE ordernumber = 'P200801132042250' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115040'
                WHERE ordernumber = 'P180801132557363' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143625'
                WHERE ordernumber = 'P180801133522166' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404538'
                WHERE ordernumber = 'P180801133638927' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404539'
                WHERE ordernumber = 'P420801133904759' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118464'
                WHERE ordernumber = 'P190801134324423' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281909'
                WHERE ordernumber = 'P190801134413307' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286511'
                WHERE ordernumber = 'P190801134858177' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226100'
                WHERE ordernumber = 'P200801135002478' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404543'
                WHERE ordernumber = 'P420801135611818' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404542'
                WHERE ordernumber = 'P200801135612252' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200801135738701' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384585'
                WHERE ordernumber = 'P180801140245436' 
            
2024-08-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404544'
                WHERE ordernumber = 'P200801140413458' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404546'
                WHERE ordernumber = 'P200801140651309' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '170426'
                WHERE ordernumber = 'P180801140832832' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394547'
                WHERE ordernumber = 'P190801141304249' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404548'
                WHERE ordernumber = 'P190801141736802' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168395'
                WHERE ordernumber = 'P200801141947893' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404549'
                WHERE ordernumber = 'P180801142540454' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404550'
                WHERE ordernumber = 'P190801142548588' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400065'
                WHERE ordernumber = 'P190801142726166' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404551'
                WHERE ordernumber = 'P180801142905806' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404552'
                WHERE ordernumber = 'P190801142908115' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118039'
                WHERE ordernumber = 'P190801142957465' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165130'
                WHERE ordernumber = 'P200801143339658' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342496'
                WHERE ordernumber = 'P420801143603841' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404554'
                WHERE ordernumber = 'P180801143610193' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369819'
                WHERE ordernumber = 'P180801143833788' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404554'
                WHERE ordernumber = 'P180801143954737' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344219'
                WHERE ordernumber = 'P180801145035667' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404556'
                WHERE ordernumber = 'P200801145918183' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360140'
                WHERE ordernumber = 'P420801150021287' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233932'
                WHERE ordernumber = 'P420801150058479' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401492'
                WHERE ordernumber = 'P180801150325377' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249648'
                WHERE ordernumber = 'P200801150404647' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404557'
                WHERE ordernumber = 'P420801150806732' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404559'
                WHERE ordernumber = 'P200801151123952' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404560'
                WHERE ordernumber = 'P200801151129682' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '24519'
                WHERE ordernumber = 'P180801152036782' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288625'
                WHERE ordernumber = 'P200801152251200' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404563'
                WHERE ordernumber = 'P180801152352392' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346294'
                WHERE ordernumber = 'P180801153621773' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403991'
                WHERE ordernumber = 'P200801154019903' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404565'
                WHERE ordernumber = 'P200801154529664' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404567'
                WHERE ordernumber = 'P420801155209577' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404571'
                WHERE ordernumber = 'P420801160205718' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403264'
                WHERE ordernumber = 'P200801160205867' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250471'
                WHERE ordernumber = 'P180801160454536' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403264'
                WHERE ordernumber = 'P200801160457918' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404571'
                WHERE ordernumber = 'P420801160459378' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298277'
                WHERE ordernumber = 'P180801160531750' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308784'
                WHERE ordernumber = 'P200801161641576' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349615'
                WHERE ordernumber = 'P420801161733906' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300239'
                WHERE ordernumber = 'P420801161947382' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337807'
                WHERE ordernumber = 'P200801162326667' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216313'
                WHERE ordernumber = 'P180801162419128' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404576'
                WHERE ordernumber = 'P420801162631174' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404577'
                WHERE ordernumber = 'P420801162726324' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298048'
                WHERE ordernumber = 'P180801162821862' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280690'
                WHERE ordernumber = 'P180801162933900' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404101'
                WHERE ordernumber = 'P180801163143273' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219229'
                WHERE ordernumber = 'P180801163422811' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393481'
                WHERE ordernumber = 'P180801164320119' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373962'
                WHERE ordernumber = 'P420801164329682' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373735'
                WHERE ordernumber = 'P420801165056301' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404584'
                WHERE ordernumber = 'P200801165617678' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404585'
                WHERE ordernumber = 'P180801165654851' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P200801170055667' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230515'
                WHERE ordernumber = 'P180801170554146' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404589'
                WHERE ordernumber = 'P190801171459328' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232779'
                WHERE ordernumber = 'P200801171531457' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402560'
                WHERE ordernumber = 'P180801171547870' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404593'
                WHERE ordernumber = 'P180801172121208' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399258'
                WHERE ordernumber = 'P190801172437117' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404594'
                WHERE ordernumber = 'P180801172553510' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399258'
                WHERE ordernumber = 'P190801172756329' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259823'
                WHERE ordernumber = 'P200801173225349' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404597'
                WHERE ordernumber = 'P420801173256916' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404599'
                WHERE ordernumber = 'P420801173630567' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404598'
                WHERE ordernumber = 'P200801173645318' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394584'
                WHERE ordernumber = 'P420801173719353' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404600'
                WHERE ordernumber = 'P630801173806699' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404601'
                WHERE ordernumber = 'P180801173816260' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404602'
                WHERE ordernumber = 'P420801173907863' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109817'
                WHERE ordernumber = 'P180801173945869' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382117'
                WHERE ordernumber = 'P180801174157276' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404604'
                WHERE ordernumber = 'P420801174243267' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233159'
                WHERE ordernumber = 'P630801174354271' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404606'
                WHERE ordernumber = 'P420801174431231' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291217'
                WHERE ordernumber = 'P180801175514756' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104174'
                WHERE ordernumber = 'P190801175557910' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P420801175629892' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404608'
                WHERE ordernumber = 'P190801175818131' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404609'
                WHERE ordernumber = 'P420801175858914' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400868'
                WHERE ordernumber = 'P200801175900896' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168729'
                WHERE ordernumber = 'P420801180037620' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404610'
                WHERE ordernumber = 'P180801180139506' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404050'
                WHERE ordernumber = 'P190801180313236' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P420801180315904' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404612'
                WHERE ordernumber = 'P180801180432348' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404613'
                WHERE ordernumber = 'P200801180616754' 
            
2024-08-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404615'
                WHERE ordernumber = 'P420801181021183' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404617'
                WHERE ordernumber = 'P420801181652190' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276760'
                WHERE ordernumber = 'P200801181819209' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404619'
                WHERE ordernumber = 'P180801181831661' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339644'
                WHERE ordernumber = 'P420801181909553' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380585'
                WHERE ordernumber = 'P180801182029616' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404620'
                WHERE ordernumber = 'P420801182210761' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96618'
                WHERE ordernumber = 'P180801182325590' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96618'
                WHERE ordernumber = 'P180801182528999' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384279'
                WHERE ordernumber = 'P180801182632981' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404622'
                WHERE ordernumber = 'P200801182850718' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380851'
                WHERE ordernumber = 'P180801183106423' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401410'
                WHERE ordernumber = 'P200801183244379' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403707'
                WHERE ordernumber = 'P420801183435510' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403707'
                WHERE ordernumber = 'P420801183513168' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404626'
                WHERE ordernumber = 'P420801183739885' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404627'
                WHERE ordernumber = 'P420801184057472' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200801184138653' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404629'
                WHERE ordernumber = 'P180801184150410' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118048'
                WHERE ordernumber = 'P200801184524284' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404630'
                WHERE ordernumber = 'P180801184553587' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404631'
                WHERE ordernumber = 'P200801184707381' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247102'
                WHERE ordernumber = 'P180801184813818' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '117759'
                WHERE ordernumber = 'P200801184855486' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276582'
                WHERE ordernumber = 'P180801184903381' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218995'
                WHERE ordernumber = 'P420801184948900' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404633'
                WHERE ordernumber = 'P190801185144704' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404635'
                WHERE ordernumber = 'P200801185213454' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382134'
                WHERE ordernumber = 'P190801185248437' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403809'
                WHERE ordernumber = 'P200801185336891' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '332624'
                WHERE ordernumber = 'P420801185453525' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305464'
                WHERE ordernumber = 'P200801185700735' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385037'
                WHERE ordernumber = 'P420801185718790' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98302'
                WHERE ordernumber = 'P200801185854877' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404638'
                WHERE ordernumber = 'P190801190741373' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283798'
                WHERE ordernumber = 'P200801190822741' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397024'
                WHERE ordernumber = 'P190801190912436' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397994'
                WHERE ordernumber = 'P200801191006422' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404640'
                WHERE ordernumber = 'P200801191153553' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P190801191947715' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404642'
                WHERE ordernumber = 'P200801192143300' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P190801192626893' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326954'
                WHERE ordernumber = 'P200801192638962' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '106858'
                WHERE ordernumber = 'P200801193128864' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '82016'
                WHERE ordernumber = 'P630801193525382' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293592'
                WHERE ordernumber = 'P200801193713388' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '172011'
                WHERE ordernumber = 'P190801193716263' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295213'
                WHERE ordernumber = 'P190801193941182' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251344'
                WHERE ordernumber = 'P190801194120763' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292403'
                WHERE ordernumber = 'P190801194512941' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404647'
                WHERE ordernumber = 'P200801195615741' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404648'
                WHERE ordernumber = 'P200801195822450' 
            
2024-08-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234480'
                WHERE ordernumber = 'P200801195923898'