2024-12-23 01:00:01 -- 將會員中心id寫入data-lake
2024-12-23 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-22%';
        
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438025'
                WHERE ordernumber = 'P2412220000014' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217234'
                WHERE ordernumber = 'P2412220000015' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367228'
                WHERE ordernumber = 'P2412220000016' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418687'
                WHERE ordernumber = 'P2412220000018' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406775'
                WHERE ordernumber = 'P2412220000019' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414905'
                WHERE ordernumber = 'P2412220000021' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316925'
                WHERE ordernumber = 'P2412220000024' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395141'
                WHERE ordernumber = 'P2412220000027' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339104'
                WHERE ordernumber = 'P2412220000029' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425609'
                WHERE ordernumber = 'P2412220000030' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438031'
                WHERE ordernumber = 'P2412220000031' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438033'
                WHERE ordernumber = 'P2412220000036' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438032'
                WHERE ordernumber = 'P2412220000038' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375929'
                WHERE ordernumber = 'P2412220000040' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438028'
                WHERE ordernumber = 'P2412220000041' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438033'
                WHERE ordernumber = 'P2412220000042' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438036'
                WHERE ordernumber = 'P2412220000044' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438040'
                WHERE ordernumber = 'P2412220000045' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438038'
                WHERE ordernumber = 'P2412220000046' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435343'
                WHERE ordernumber = 'P2412220000049' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366523'
                WHERE ordernumber = 'P2412220000051' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393725'
                WHERE ordernumber = 'P2412220000052' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '210801'
                WHERE ordernumber = 'P2412220000056' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438044'
                WHERE ordernumber = 'P2412220000060' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438042'
                WHERE ordernumber = 'P2412220000068' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438042'
                WHERE ordernumber = 'P2412220000071' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438046'
                WHERE ordernumber = 'P2412220000073' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438045'
                WHERE ordernumber = 'P2412220000074' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360218'
                WHERE ordernumber = 'P2412220000076' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335742'
                WHERE ordernumber = 'P2412220000077' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274867'
                WHERE ordernumber = 'P2412220000078' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329862'
                WHERE ordernumber = 'P2412220000080' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358695'
                WHERE ordernumber = 'P2412220000082' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397687'
                WHERE ordernumber = 'P2412220000083' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167604'
                WHERE ordernumber = 'P2412220000084' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353988'
                WHERE ordernumber = 'P2412220000087' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282636'
                WHERE ordernumber = 'P2412220000089' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438049'
                WHERE ordernumber = 'P2412220000092' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394626'
                WHERE ordernumber = 'P2412220000096' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393725'
                WHERE ordernumber = 'P2412220000101' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393725'
                WHERE ordernumber = 'P2412220000102' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '256223'
                WHERE ordernumber = 'P2412220000104' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438051'
                WHERE ordernumber = 'P2412220000106' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438050'
                WHERE ordernumber = 'P2412220000111' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438052'
                WHERE ordernumber = 'P2412220000112' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337993'
                WHERE ordernumber = 'P2412220000113' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238758'
                WHERE ordernumber = 'P2412220000118' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372603'
                WHERE ordernumber = 'P2412220000120' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423288'
                WHERE ordernumber = 'P2412220000121' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316188'
                WHERE ordernumber = 'P2412220000122' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288062'
                WHERE ordernumber = 'P2412220000124' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437915'
                WHERE ordernumber = 'P2412220000127' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274867'
                WHERE ordernumber = 'P2412220000130' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438056'
                WHERE ordernumber = 'P2412220000131' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431450'
                WHERE ordernumber = 'P2412220000136' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334889'
                WHERE ordernumber = 'P2412220000138' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438058'
                WHERE ordernumber = 'P2412220000139' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438059'
                WHERE ordernumber = 'P2412220000142' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438057'
                WHERE ordernumber = 'P2412220000144' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435079'
                WHERE ordernumber = 'P2412220000145' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112794'
                WHERE ordernumber = 'P2412220000153' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438061'
                WHERE ordernumber = 'P2412220000155' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400885'
                WHERE ordernumber = 'P2412220000158' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438062'
                WHERE ordernumber = 'P2412220000160' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438064'
                WHERE ordernumber = 'P2412220000161' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395181'
                WHERE ordernumber = 'P2412220000163' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248374'
                WHERE ordernumber = 'P2412220000167' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438063'
                WHERE ordernumber = 'P2412220000169' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438066'
                WHERE ordernumber = 'P2412220000171' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438069'
                WHERE ordernumber = 'P2412220000178' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328345'
                WHERE ordernumber = 'P2412220000181' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129482'
                WHERE ordernumber = 'P2412220000182' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438070'
                WHERE ordernumber = 'P2412220000183' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438072'
                WHERE ordernumber = 'P2412220000186' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438073'
                WHERE ordernumber = 'P2412220000188' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278108'
                WHERE ordernumber = 'P2412220000191' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426453'
                WHERE ordernumber = 'P2412220000195' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438078'
                WHERE ordernumber = 'P2412220000197' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438077'
                WHERE ordernumber = 'P2412220000200' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438080'
                WHERE ordernumber = 'P2412220000201' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262386'
                WHERE ordernumber = 'P2412220000202' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428616'
                WHERE ordernumber = 'P2412220000204' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438081'
                WHERE ordernumber = 'P2412220000206' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393653'
                WHERE ordernumber = 'P2412220000208' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313500'
                WHERE ordernumber = 'P2412220000212' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438084'
                WHERE ordernumber = 'P2412220000213' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95929'
                WHERE ordernumber = 'P2412220000214' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438082'
                WHERE ordernumber = 'P2412220000215' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438086'
                WHERE ordernumber = 'P2412220000220' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289497'
                WHERE ordernumber = 'P2412220000221' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '77040'
                WHERE ordernumber = 'P2412220000222' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258806'
                WHERE ordernumber = 'P2412220000223' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438088'
                WHERE ordernumber = 'P2412220000226' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437987'
                WHERE ordernumber = 'P2412220000231' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243770'
                WHERE ordernumber = 'P2412220000238' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2412220000244' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438099'
                WHERE ordernumber = 'P2412220000249' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438097'
                WHERE ordernumber = 'P2412220000251' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438100'
                WHERE ordernumber = 'P2412220000256' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401271'
                WHERE ordernumber = 'P2412220000257' 
            
2024-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438102'
                WHERE ordernumber = 'P2412220000258' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438101'
                WHERE ordernumber = 'P2412220000259' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253344'
                WHERE ordernumber = 'P2412220000262' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409503'
                WHERE ordernumber = 'P2412220000265' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438106'
                WHERE ordernumber = 'P2412220000267' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438107'
                WHERE ordernumber = 'P2412220000268' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437088'
                WHERE ordernumber = 'P2412220000271' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264848'
                WHERE ordernumber = 'P2412220000277' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288236'
                WHERE ordernumber = 'P2412220000278' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129975'
                WHERE ordernumber = 'P2412220000279' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438103'
                WHERE ordernumber = 'P2412220000282' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322276'
                WHERE ordernumber = 'P2412220000284' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438111'
                WHERE ordernumber = 'P2412220000285' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438108'
                WHERE ordernumber = 'P2412220000287' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438115'
                WHERE ordernumber = 'P2412220000288' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438110'
                WHERE ordernumber = 'P2412220000290' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438116'
                WHERE ordernumber = 'P2412220000294' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438120'
                WHERE ordernumber = 'P2412220000300' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438119'
                WHERE ordernumber = 'P2412220000306' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135353'
                WHERE ordernumber = 'P2412220000309' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438105'
                WHERE ordernumber = 'P2412220000311' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395158'
                WHERE ordernumber = 'P2412220000314' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252193'
                WHERE ordernumber = 'P2412220000315' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438121'
                WHERE ordernumber = 'P2412220000318' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438112'
                WHERE ordernumber = 'P2412220000323' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438112'
                WHERE ordernumber = 'P2412220000324' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438126'
                WHERE ordernumber = 'P2412220000325' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438105'
                WHERE ordernumber = 'P2412220000326' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323791'
                WHERE ordernumber = 'P2412220000329' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438122'
                WHERE ordernumber = 'P2412220000331' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365339'
                WHERE ordernumber = 'P2412220000332' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393169'
                WHERE ordernumber = 'P2412220000333' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438127'
                WHERE ordernumber = 'P2412220000334' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438125'
                WHERE ordernumber = 'P2412220000335' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231118'
                WHERE ordernumber = 'P2412220000340' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138070'
                WHERE ordernumber = 'P2412220000344' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438130'
                WHERE ordernumber = 'P2412220000347' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438128'
                WHERE ordernumber = 'P2412220000349' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370423'
                WHERE ordernumber = 'P2412220000354' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438131'
                WHERE ordernumber = 'P2412220000358' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438133'
                WHERE ordernumber = 'P2412220000359' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438128'
                WHERE ordernumber = 'P2412220000362' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367171'
                WHERE ordernumber = 'P2412220000365' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330969'
                WHERE ordernumber = 'P2412220000369' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438139'
                WHERE ordernumber = 'P2412220000373' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104691'
                WHERE ordernumber = 'P2412220000377' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438136'
                WHERE ordernumber = 'P2412220000378' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438138'
                WHERE ordernumber = 'P2412220000382' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373661'
                WHERE ordernumber = 'P2412220000386' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81645'
                WHERE ordernumber = 'P2412220000388' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438141'
                WHERE ordernumber = 'P2412220000391' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438145'
                WHERE ordernumber = 'P2412220000392' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438147'
                WHERE ordernumber = 'P2412220000397' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438149'
                WHERE ordernumber = 'P2412220000406' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438149'
                WHERE ordernumber = 'P2412220000408' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438151'
                WHERE ordernumber = 'P2412220000409' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438152'
                WHERE ordernumber = 'P2412220000413' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438153'
                WHERE ordernumber = 'P2412220000420' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438154'
                WHERE ordernumber = 'P2412220000421' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238603'
                WHERE ordernumber = 'P2412220000423' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438156'
                WHERE ordernumber = 'P2412220000427' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369794'
                WHERE ordernumber = 'P2412220000428' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282566'
                WHERE ordernumber = 'P2412220000434' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438158'
                WHERE ordernumber = 'P2412220000433' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438155'
                WHERE ordernumber = 'P2412220000439' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438161'
                WHERE ordernumber = 'P2412220000441' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '200009'
                WHERE ordernumber = 'P2412220000443' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438163'
                WHERE ordernumber = 'P2412220000445' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438162'
                WHERE ordernumber = 'P2412220000450' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438164'
                WHERE ordernumber = 'P2412220000451' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387129'
                WHERE ordernumber = 'P2412220000454' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167499'
                WHERE ordernumber = 'P2412220000457' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P2412220000464' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385937'
                WHERE ordernumber = 'P2412220000471' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435725'
                WHERE ordernumber = 'P2412220000478' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438167'
                WHERE ordernumber = 'P2412220000481' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438169'
                WHERE ordernumber = 'P2412220000483' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438166'
                WHERE ordernumber = 'P2412220000487' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123995'
                WHERE ordernumber = 'P2412220000492' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438170'
                WHERE ordernumber = 'P2412220000496' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438174'
                WHERE ordernumber = 'P2412220000499' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123995'
                WHERE ordernumber = 'P2412220000500' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438175'
                WHERE ordernumber = 'P2412220000503' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397188'
                WHERE ordernumber = 'P2412220000505' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429144'
                WHERE ordernumber = 'P2412220000507' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438176'
                WHERE ordernumber = 'P2412220000514' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438177'
                WHERE ordernumber = 'P2412220000517' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438179'
                WHERE ordernumber = 'P2412220000520' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438180'
                WHERE ordernumber = 'P2412220000523' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438179'
                WHERE ordernumber = 'P2412220000524' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332478'
                WHERE ordernumber = 'P2412220000526' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438182'
                WHERE ordernumber = 'P2412220000528' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438183'
                WHERE ordernumber = 'P2412220000529' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39363'
                WHERE ordernumber = 'P2412220000533' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143339'
                WHERE ordernumber = 'P2412220000537' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237608'
                WHERE ordernumber = 'P2412220000539' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438183'
                WHERE ordernumber = 'P2412220000540' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438186'
                WHERE ordernumber = 'P2412220000541' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227679'
                WHERE ordernumber = 'P2412220000543' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438189'
                WHERE ordernumber = 'P2412220000544' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295584'
                WHERE ordernumber = 'P2412220000545' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376504'
                WHERE ordernumber = 'P2412220000546' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438191'
                WHERE ordernumber = 'P2412220000549' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438187'
                WHERE ordernumber = 'P2412220000552' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290717'
                WHERE ordernumber = 'P2412220000554' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438190'
                WHERE ordernumber = 'P2412220000555' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438192'
                WHERE ordernumber = 'P2412220000556' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143339'
                WHERE ordernumber = 'P2412220000558' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438188'
                WHERE ordernumber = 'P2412220000561' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438193'
                WHERE ordernumber = 'P2412220000562' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438196'
                WHERE ordernumber = 'P2412220000564' 
            
2024-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438198'
                WHERE ordernumber = 'P2412220000572' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346832'
                WHERE ordernumber = 'P2412220000575' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437659'
                WHERE ordernumber = 'P2412220000576' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306269'
                WHERE ordernumber = 'P2412220000581' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227679'
                WHERE ordernumber = 'P2412220000584' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380077'
                WHERE ordernumber = 'P2412220000590' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438201'
                WHERE ordernumber = 'P2412220000591' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173533'
                WHERE ordernumber = 'P2412220000597' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436972'
                WHERE ordernumber = 'P2412220000598' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436972'
                WHERE ordernumber = 'P2412220000602' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438206'
                WHERE ordernumber = 'P2412220000610' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438205'
                WHERE ordernumber = 'P2412220000616' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438208'
                WHERE ordernumber = 'P2412220000619' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438211'
                WHERE ordernumber = 'P2412220000622' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P2412220000623' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384260'
                WHERE ordernumber = 'P2412220000625' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438212'
                WHERE ordernumber = 'P2412220000626' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316038'
                WHERE ordernumber = 'P2412220000629' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409609'
                WHERE ordernumber = 'P2412220000631' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P2412220000632' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126272'
                WHERE ordernumber = 'P2412220000642' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438216'
                WHERE ordernumber = 'P2412220000647' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438215'
                WHERE ordernumber = 'P2412220000648' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335379'
                WHERE ordernumber = 'P2412220000653' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379221'
                WHERE ordernumber = 'P2412220000654' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100188'
                WHERE ordernumber = 'P2412220000655' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438218'
                WHERE ordernumber = 'P2412220000666' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434866'
                WHERE ordernumber = 'P2412220000668' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429060'
                WHERE ordernumber = 'P2412220000670' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438219'
                WHERE ordernumber = 'P2412220000674' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438223'
                WHERE ordernumber = 'P2412220000675' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435704'
                WHERE ordernumber = 'P2412220000678' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438224'
                WHERE ordernumber = 'P2412220000685' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438225'
                WHERE ordernumber = 'P2412220000687' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438226'
                WHERE ordernumber = 'P2412220000691' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438227'
                WHERE ordernumber = 'P2412220000693' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233840'
                WHERE ordernumber = 'P2412220000695' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148994'
                WHERE ordernumber = 'P2412220000696' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278762'
                WHERE ordernumber = 'P2412220000707' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438228'
                WHERE ordernumber = 'P2412220000708' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438231'
                WHERE ordernumber = 'P2412220000709' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161174'
                WHERE ordernumber = 'P2412220000712' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438234'
                WHERE ordernumber = 'P2412220000718' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265962'
                WHERE ordernumber = 'P2412220000720' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323701'
                WHERE ordernumber = 'P2412220000723' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234101'
                WHERE ordernumber = 'P2412220000726' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438231'
                WHERE ordernumber = 'P2412220000728' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435396'
                WHERE ordernumber = 'P2412220000730' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438234'
                WHERE ordernumber = 'P2412220000731' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438236'
                WHERE ordernumber = 'P2412220000732' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438237'
                WHERE ordernumber = 'P2412220000736' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341887'
                WHERE ordernumber = 'P2412220000743' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438240'
                WHERE ordernumber = 'P2412220000746' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341887'
                WHERE ordernumber = 'P2412220000748' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277492'
                WHERE ordernumber = 'P2412220000754' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438242'
                WHERE ordernumber = 'P2412220000755' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267401'
                WHERE ordernumber = 'P2412220000757' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438246'
                WHERE ordernumber = 'P2412220000782' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438245'
                WHERE ordernumber = 'P2412220000783' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438247'
                WHERE ordernumber = 'P2412220000786' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438249'
                WHERE ordernumber = 'P2412220000794' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438251'
                WHERE ordernumber = 'P2412220000799' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438252'
                WHERE ordernumber = 'P2412220000800' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306282'
                WHERE ordernumber = 'P2412220000802' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438254'
                WHERE ordernumber = 'P2412220000804' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438256'
                WHERE ordernumber = 'P2412220000808' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438258'
                WHERE ordernumber = 'P2412220000813' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438262'
                WHERE ordernumber = 'P2412220000819' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438264'
                WHERE ordernumber = 'P2412220000824' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438260'
                WHERE ordernumber = 'P2412220000826' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236542'
                WHERE ordernumber = 'P2412220000828' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96869'
                WHERE ordernumber = 'P2412220000844' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273463'
                WHERE ordernumber = 'P2412220000847' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273463'
                WHERE ordernumber = 'P2412220000848' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111367'
                WHERE ordernumber = 'P2412220000851' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438272'
                WHERE ordernumber = 'P2412220000856' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399108'
                WHERE ordernumber = 'P2412220000862' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296887'
                WHERE ordernumber = 'P2412220000865' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378119'
                WHERE ordernumber = 'P2412220000866' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438274'
                WHERE ordernumber = 'P2412220000874' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243213'
                WHERE ordernumber = 'P2412220000875' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109643'
                WHERE ordernumber = 'P2412220000889' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435015'
                WHERE ordernumber = 'P2412220000891' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438277'
                WHERE ordernumber = 'P2412220000895' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438093'
                WHERE ordernumber = 'P2412220000896' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438284'
                WHERE ordernumber = 'P2412220000907' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438286'
                WHERE ordernumber = 'P2412220000911' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '61566'
                WHERE ordernumber = 'P2412220000916' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438288'
                WHERE ordernumber = 'P2412220000917' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438279'
                WHERE ordernumber = 'P2412220000920' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438289'
                WHERE ordernumber = 'P2412220000924' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300665'
                WHERE ordernumber = 'P2412220000925' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300665'
                WHERE ordernumber = 'P2412220000927' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438290'
                WHERE ordernumber = 'P2412220000928' 
            
2024-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270879'
                WHERE ordernumber = 'P2412220000931'