2024-12-07 01:00:01 -- 將會員中心id寫入data-lake
2024-12-07 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-12-06%';
        
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94231'
                WHERE ordernumber = 'P2412060000115' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340908'
                WHERE ordernumber = 'P2412060000356' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132930'
                WHERE ordernumber = 'P2412060000523' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '83238'
                WHERE ordernumber = 'P2412060000736' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P2412060001023' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433507'
                WHERE ordernumber = 'P2412060001387' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433508'
                WHERE ordernumber = 'P2412060001580' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433512'
                WHERE ordernumber = 'P2412060001644' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433514'
                WHERE ordernumber = 'P2412060001753' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433513'
                WHERE ordernumber = 'P2412060001891' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433515'
                WHERE ordernumber = 'P2412060002060' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433511'
                WHERE ordernumber = 'P2412060002186' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268445'
                WHERE ordernumber = 'P2412060002251' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273892'
                WHERE ordernumber = 'P2412060002336' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433517'
                WHERE ordernumber = 'P2412060002412' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433518'
                WHERE ordernumber = 'P2412060002555' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243715'
                WHERE ordernumber = 'P2412060002724' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118846'
                WHERE ordernumber = 'P2412060003164' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432709'
                WHERE ordernumber = 'P2412060003493' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100967'
                WHERE ordernumber = 'P2412060003631' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433522'
                WHERE ordernumber = 'P2412060003842' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404622'
                WHERE ordernumber = 'P2412060003984' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218516'
                WHERE ordernumber = 'P2412060004049' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433523'
                WHERE ordernumber = 'P2412060004154' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262435'
                WHERE ordernumber = 'P2412060004234' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433524'
                WHERE ordernumber = 'P2412060004585' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433525'
                WHERE ordernumber = 'P2412060004745' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433528'
                WHERE ordernumber = 'P2412060004879' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433527'
                WHERE ordernumber = 'P2412060005097' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254415'
                WHERE ordernumber = 'P2412060005172' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433529'
                WHERE ordernumber = 'P2412060005211' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420446'
                WHERE ordernumber = 'P2412060005344' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402561'
                WHERE ordernumber = 'P2412060005483' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433530'
                WHERE ordernumber = 'P2412060005537' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433533'
                WHERE ordernumber = 'P2412060005652' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433534'
                WHERE ordernumber = 'P2412060005749' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302805'
                WHERE ordernumber = 'P2412060006149' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433536'
                WHERE ordernumber = 'P2412060006259' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433539'
                WHERE ordernumber = 'P2412060006447' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433537'
                WHERE ordernumber = 'P2412060006528' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389085'
                WHERE ordernumber = 'P2412060006765' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426834'
                WHERE ordernumber = 'P2412060006886' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '39815'
                WHERE ordernumber = 'P2412060006920' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433536'
                WHERE ordernumber = 'P2412060007137' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211249'
                WHERE ordernumber = 'P2412060007368' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273234'
                WHERE ordernumber = 'P2412060007528' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433541'
                WHERE ordernumber = 'P2412060007646' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263742'
                WHERE ordernumber = 'P2412060007740' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127747'
                WHERE ordernumber = 'P2412060007760' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328828'
                WHERE ordernumber = 'P2412060008021' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101375'
                WHERE ordernumber = 'P2412060008267' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307192'
                WHERE ordernumber = 'P2412060008323' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433544'
                WHERE ordernumber = 'P2412060008667' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421785'
                WHERE ordernumber = 'P2412060008977' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397160'
                WHERE ordernumber = 'P2412060009156' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433546'
                WHERE ordernumber = 'P2412060009284' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433547'
                WHERE ordernumber = 'P2412060009384' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433384'
                WHERE ordernumber = 'P2412060009451' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402370'
                WHERE ordernumber = 'P2412060009564' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433549'
                WHERE ordernumber = 'P2412060009625' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129132'
                WHERE ordernumber = 'P2412060009780' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P2412060009820' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433455'
                WHERE ordernumber = 'P2412060009924' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400937'
                WHERE ordernumber = 'P2412060010030' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396627'
                WHERE ordernumber = 'P2412060010196' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255632'
                WHERE ordernumber = 'P2412060010288' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433552'
                WHERE ordernumber = 'P2412060010423' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128554'
                WHERE ordernumber = 'P2412060010745' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303700'
                WHERE ordernumber = 'P2412060010858' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310406'
                WHERE ordernumber = 'P2412060011017' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391720'
                WHERE ordernumber = 'P2412060011130' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105630'
                WHERE ordernumber = 'P2412060011252' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425427'
                WHERE ordernumber = 'P2412060011393' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268726'
                WHERE ordernumber = 'P2412060011452' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113502'
                WHERE ordernumber = 'P2412060011538' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268726'
                WHERE ordernumber = 'P2412060011615' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433558'
                WHERE ordernumber = 'P2412060011818' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433559'
                WHERE ordernumber = 'P2412060011979' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273762'
                WHERE ordernumber = 'P2412060012092' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433563'
                WHERE ordernumber = 'P2412060012125' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433563'
                WHERE ordernumber = 'P2412060012333' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433562'
                WHERE ordernumber = 'P2412060012449' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433562'
                WHERE ordernumber = 'P2412060012520' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433567'
                WHERE ordernumber = 'P2412060012772' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433011'
                WHERE ordernumber = 'P2412060013026' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430231'
                WHERE ordernumber = 'P2412060013239' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '146448'
                WHERE ordernumber = 'P2412060013453' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433572'
                WHERE ordernumber = 'P2412060013556' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315404'
                WHERE ordernumber = 'P2412060013736' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307752'
                WHERE ordernumber = 'P2412060013835' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433573'
                WHERE ordernumber = 'P2412060013923' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389121'
                WHERE ordernumber = 'P2412060014638' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433176'
                WHERE ordernumber = 'P2412060014732' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433577'
                WHERE ordernumber = 'P2412060014840' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345721'
                WHERE ordernumber = 'P2412060014968' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342030'
                WHERE ordernumber = 'P2412060015015' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406753'
                WHERE ordernumber = 'P2412060015179' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433575'
                WHERE ordernumber = 'P2412060015230' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98509'
                WHERE ordernumber = 'P2412060015417' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433581'
                WHERE ordernumber = 'P2412060015680' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433579'
                WHERE ordernumber = 'P2412060015831' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433580'
                WHERE ordernumber = 'P2412060015911' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305284'
                WHERE ordernumber = 'P2412060016171' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427183'
                WHERE ordernumber = 'P2412060016238' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P2412060016483' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401994'
                WHERE ordernumber = 'P2412060016514' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433574'
                WHERE ordernumber = 'P2412060016663' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433109'
                WHERE ordernumber = 'P2412060016734' 
            
2024-12-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433585'
                WHERE ordernumber = 'P2412060016812' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433569'
                WHERE ordernumber = 'P2412060016973' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433586'
                WHERE ordernumber = 'P2412060017099' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396609'
                WHERE ordernumber = 'P2412060017136' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433587'
                WHERE ordernumber = 'P2412060017461' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433589'
                WHERE ordernumber = 'P2412060018289' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433592'
                WHERE ordernumber = 'P2412060018324' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226318'
                WHERE ordernumber = 'P2412060018449' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433591'
                WHERE ordernumber = 'P2412060018588' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433593'
                WHERE ordernumber = 'P2412060018896' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394174'
                WHERE ordernumber = 'P2412060019098' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P2412060019182' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314795'
                WHERE ordernumber = 'P2412060019220' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412521'
                WHERE ordernumber = 'P2412060019329' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433594'
                WHERE ordernumber = 'P2412060019523' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100668'
                WHERE ordernumber = 'P2412060020049' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433597'
                WHERE ordernumber = 'P2412060020142' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431877'
                WHERE ordernumber = 'P2412060020254' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433600'
                WHERE ordernumber = 'P2412060020445' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433598'
                WHERE ordernumber = 'P2412060020635' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381164'
                WHERE ordernumber = 'P2412060020828' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433602'
                WHERE ordernumber = 'P2412060020968' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230105'
                WHERE ordernumber = 'P2412060021070' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433605'
                WHERE ordernumber = 'P2412060021116' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433606'
                WHERE ordernumber = 'P2412060021266' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236606'
                WHERE ordernumber = 'P2412060021340' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430236'
                WHERE ordernumber = 'P2412060021555' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280910'
                WHERE ordernumber = 'P2412060021720' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97423'
                WHERE ordernumber = 'P2412060021824' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433607'
                WHERE ordernumber = 'P2412060022111' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242291'
                WHERE ordernumber = 'P2412060022356' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433609'
                WHERE ordernumber = 'P2412060022564' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131888'
                WHERE ordernumber = 'P2412060022769' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431742'
                WHERE ordernumber = 'P2412060022839' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431742'
                WHERE ordernumber = 'P2412060022997' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433611'
                WHERE ordernumber = 'P2412060023090' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433610'
                WHERE ordernumber = 'P2412060023191' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433612'
                WHERE ordernumber = 'P2412060023295' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433613'
                WHERE ordernumber = 'P2412060023333' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432753'
                WHERE ordernumber = 'P2412060023420' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433610'
                WHERE ordernumber = 'P2412060023666' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433616'
                WHERE ordernumber = 'P2412060023756' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241095'
                WHERE ordernumber = 'P2412060023899' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382512'
                WHERE ordernumber = 'P2412060023927' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433618'
                WHERE ordernumber = 'P2412060024078' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410211'
                WHERE ordernumber = 'P2412060024169' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295686'
                WHERE ordernumber = 'P2412060024247' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433621'
                WHERE ordernumber = 'P2412060024322' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326143'
                WHERE ordernumber = 'P2412060024468' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433622'
                WHERE ordernumber = 'P2412060024597' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '72830'
                WHERE ordernumber = 'P2412060024628' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401690'
                WHERE ordernumber = 'P2412060024788' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427097'
                WHERE ordernumber = 'P2412060024896' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260961'
                WHERE ordernumber = 'P2412060024956' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260961'
                WHERE ordernumber = 'P2412060025025' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430577'
                WHERE ordernumber = 'P2412060025170' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433624'
                WHERE ordernumber = 'P2412060025348' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433619'
                WHERE ordernumber = 'P2412060025426' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430577'
                WHERE ordernumber = 'P2412060025776' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433626'
                WHERE ordernumber = 'P2412060025998' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114985'
                WHERE ordernumber = 'P2412060026088' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142572'
                WHERE ordernumber = 'P2412060026546' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433629'
                WHERE ordernumber = 'P2412060026699' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219323'
                WHERE ordernumber = 'P2412060026737' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433631'
                WHERE ordernumber = 'P2412060027033' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378239'
                WHERE ordernumber = 'P2412060027181' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249813'
                WHERE ordernumber = 'P2412060027226' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433639'
                WHERE ordernumber = 'P2412060027436' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283325'
                WHERE ordernumber = 'P2412060027566' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259652'
                WHERE ordernumber = 'P2412060027740' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389810'
                WHERE ordernumber = 'P2412060027887' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433634'
                WHERE ordernumber = 'P2412060027862' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229742'
                WHERE ordernumber = 'P2412060028071' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428210'
                WHERE ordernumber = 'P2412060028135' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433061'
                WHERE ordernumber = 'P2412060028230' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388070'
                WHERE ordernumber = 'P2412060028529' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433640'
                WHERE ordernumber = 'P2412060028786' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433641'
                WHERE ordernumber = 'P2412060028892' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386151'
                WHERE ordernumber = 'P2412060028975' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409770'
                WHERE ordernumber = 'P2412060029037' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433642'
                WHERE ordernumber = 'P2412060029328' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206960'
                WHERE ordernumber = 'P2412060029486' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351916'
                WHERE ordernumber = 'P2412060029557' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271495'
                WHERE ordernumber = 'P2412060029735' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207234'
                WHERE ordernumber = 'P2412060029859' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240871'
                WHERE ordernumber = 'P2412060029954' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433644'
                WHERE ordernumber = 'P2412060030135' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433645'
                WHERE ordernumber = 'P2412060030432' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433491'
                WHERE ordernumber = 'P2412060030543' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433648'
                WHERE ordernumber = 'P2412060030617' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259176'
                WHERE ordernumber = 'P2412060030733' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433649'
                WHERE ordernumber = 'P2412060030830' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432827'
                WHERE ordernumber = 'P2412060030988' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403084'
                WHERE ordernumber = 'P2412060031019' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433651'
                WHERE ordernumber = 'P2412060031135' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433652'
                WHERE ordernumber = 'P2412060031258' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419775'
                WHERE ordernumber = 'P2412060031318' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433654'
                WHERE ordernumber = 'P2412060031461' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433655'
                WHERE ordernumber = 'P2412060031582' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433653'
                WHERE ordernumber = 'P2412060031655' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433656'
                WHERE ordernumber = 'P2412060031997' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419775'
                WHERE ordernumber = 'P2412060032161' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389981'
                WHERE ordernumber = 'P2412060032253' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137599'
                WHERE ordernumber = 'P2412060032519' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266066'
                WHERE ordernumber = 'P2412060032722' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433660'
                WHERE ordernumber = 'P2412060032830' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433659'
                WHERE ordernumber = 'P2412060032963' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P2412060033095' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228781'
                WHERE ordernumber = 'P2412060033128' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62723'
                WHERE ordernumber = 'P2412060033234' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360119'
                WHERE ordernumber = 'P2412060033324' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433661'
                WHERE ordernumber = 'P2412060033492' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433664'
                WHERE ordernumber = 'P2412060033656' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433665'
                WHERE ordernumber = 'P2412060033772' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433663'
                WHERE ordernumber = 'P2412060033866' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433666'
                WHERE ordernumber = 'P2412060033984' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273160'
                WHERE ordernumber = 'P2412060034116' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433662'
                WHERE ordernumber = 'P2412060034245' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143306'
                WHERE ordernumber = 'P2412060034364' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433668'
                WHERE ordernumber = 'P2412060034415' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433667'
                WHERE ordernumber = 'P2412060034596' 
            
2024-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433669'
                WHERE ordernumber = 'P2412060034659' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433670'
                WHERE ordernumber = 'P2412060034837' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433670'
                WHERE ordernumber = 'P2412060035067' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161113'
                WHERE ordernumber = 'P2412060035162' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340960'
                WHERE ordernumber = 'P2412060035221' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386162'
                WHERE ordernumber = 'P2412060035359' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433672'
                WHERE ordernumber = 'P2412060035757' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433673'
                WHERE ordernumber = 'P2412060035869' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231420'
                WHERE ordernumber = 'P2412060036046' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433674'
                WHERE ordernumber = 'P2412060036211' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433675'
                WHERE ordernumber = 'P2412060036316' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433676'
                WHERE ordernumber = 'P2412060036460' 
            
2024-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342315'
                WHERE ordernumber = 'P2412060036771'