2024-12-26 01:00:02 -- 將會員中心id寫入data-lake
2024-12-26 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-12-25%';
        
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119317'
                WHERE ordernumber = 'P2412250000021' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439121'
                WHERE ordernumber = 'P2412250000022' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401489'
                WHERE ordernumber = 'P2412250000023' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317081'
                WHERE ordernumber = 'P2412250000026' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249484'
                WHERE ordernumber = 'P2412250000034' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385026'
                WHERE ordernumber = 'P2412250000041' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429346'
                WHERE ordernumber = 'P2412250000042' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439202'
                WHERE ordernumber = 'P2412250000044' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287499'
                WHERE ordernumber = 'P2412250000045' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439059'
                WHERE ordernumber = 'P2412250000046' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144947'
                WHERE ordernumber = 'P2412250000047' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112676'
                WHERE ordernumber = 'P2412250000048' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121146'
                WHERE ordernumber = 'P2412250000049' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439205'
                WHERE ordernumber = 'P2412250000051' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233299'
                WHERE ordernumber = 'P2412250000055' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296067'
                WHERE ordernumber = 'P2412250000057' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439208'
                WHERE ordernumber = 'P2412250000058' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386623'
                WHERE ordernumber = 'P2412250000068' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439214'
                WHERE ordernumber = 'P2412250000072' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P2412250000073' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386623'
                WHERE ordernumber = 'P2412250000075' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439213'
                WHERE ordernumber = 'P2412250000076' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439211'
                WHERE ordernumber = 'P2412250000078' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235087'
                WHERE ordernumber = 'P2412250000081' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438957'
                WHERE ordernumber = 'P2412250000085' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439163'
                WHERE ordernumber = 'P2412250000086' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235087'
                WHERE ordernumber = 'P2412250000087' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439163'
                WHERE ordernumber = 'P2412250000088' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163620'
                WHERE ordernumber = 'P2412250000090' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163620'
                WHERE ordernumber = 'P2412250000092' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232256'
                WHERE ordernumber = 'P2412250000094' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434783'
                WHERE ordernumber = 'P2412250000101' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431877'
                WHERE ordernumber = 'P2412250000104' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434783'
                WHERE ordernumber = 'P2412250000105' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212232'
                WHERE ordernumber = 'P2412250000108' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428259'
                WHERE ordernumber = 'P2412250000110' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421142'
                WHERE ordernumber = 'P2412250000111' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439221'
                WHERE ordernumber = 'P2412250000114' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245075'
                WHERE ordernumber = 'P2412250000118' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319079'
                WHERE ordernumber = 'P2412250000121' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435038'
                WHERE ordernumber = 'P2412250000127' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439225'
                WHERE ordernumber = 'P2412250000128' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439226'
                WHERE ordernumber = 'P2412250000129' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439145'
                WHERE ordernumber = 'P2412250000132' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439230'
                WHERE ordernumber = 'P2412250000133' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439233'
                WHERE ordernumber = 'P2412250000136' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430872'
                WHERE ordernumber = 'P2412250000139' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439235'
                WHERE ordernumber = 'P2412250000141' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274222'
                WHERE ordernumber = 'P2412250000142' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439234'
                WHERE ordernumber = 'P2412250000145' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439236'
                WHERE ordernumber = 'P2412250000146' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422775'
                WHERE ordernumber = 'P2412250000149' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439241'
                WHERE ordernumber = 'P2412250000161' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405523'
                WHERE ordernumber = 'P2412250000163' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439239'
                WHERE ordernumber = 'P2412250000165' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265377'
                WHERE ordernumber = 'P2412250000167' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439240'
                WHERE ordernumber = 'P2412250000168' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439244'
                WHERE ordernumber = 'P2412250000171' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223258'
                WHERE ordernumber = 'P2412250000175' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259811'
                WHERE ordernumber = 'P2412250000178' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439246'
                WHERE ordernumber = 'P2412250000180' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323463'
                WHERE ordernumber = 'P2412250000181' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435834'
                WHERE ordernumber = 'P2412250000186' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439252'
                WHERE ordernumber = 'P2412250000188' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439250'
                WHERE ordernumber = 'P2412250000189' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439253'
                WHERE ordernumber = 'P2412250000190' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439254'
                WHERE ordernumber = 'P2412250000191' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439255'
                WHERE ordernumber = 'P2412250000197' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143999'
                WHERE ordernumber = 'P2412250000198' 
            
2024-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P2412250000199' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430039'
                WHERE ordernumber = 'P2412250000200' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96935'
                WHERE ordernumber = 'P2412250000202' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374267'
                WHERE ordernumber = 'P2412250000204' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435281'
                WHERE ordernumber = 'P2412250000213' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217292'
                WHERE ordernumber = 'P2412250000218' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298889'
                WHERE ordernumber = 'P2412250000220' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237513'
                WHERE ordernumber = 'P2412250000224' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243942'
                WHERE ordernumber = 'P2412250000227' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353754'
                WHERE ordernumber = 'P2412250000234' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434446'
                WHERE ordernumber = 'P2412250000235' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99718'
                WHERE ordernumber = 'P2412250000237' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439264'
                WHERE ordernumber = 'P2412250000240' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363947'
                WHERE ordernumber = 'P2412250000249' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293262'
                WHERE ordernumber = 'P2412250000251' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389093'
                WHERE ordernumber = 'P2412250000254' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433138'
                WHERE ordernumber = 'P2412250000256' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237288'
                WHERE ordernumber = 'P2412250000257' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426246'
                WHERE ordernumber = 'P2412250000263' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439276'
                WHERE ordernumber = 'P2412250000273' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439277'
                WHERE ordernumber = 'P2412250000274' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439278'
                WHERE ordernumber = 'P2412250000275' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439278'
                WHERE ordernumber = 'P2412250000282' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439283'
                WHERE ordernumber = 'P2412250000293' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439287'
                WHERE ordernumber = 'P2412250000294' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439285'
                WHERE ordernumber = 'P2412250000295' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299346'
                WHERE ordernumber = 'P2412250000296' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273202'
                WHERE ordernumber = 'P2412250000298' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439284'
                WHERE ordernumber = 'P2412250000300' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92045'
                WHERE ordernumber = 'P2412250000301' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439281'
                WHERE ordernumber = 'P2412250000302' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359890'
                WHERE ordernumber = 'P2412250000306' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439292'
                WHERE ordernumber = 'P2412250000309' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358816'
                WHERE ordernumber = 'P2412250000312' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282418'
                WHERE ordernumber = 'P2412250000313' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427778'
                WHERE ordernumber = 'P2412250000320' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382258'
                WHERE ordernumber = 'P2412250000324' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P2412250000325' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146448'
                WHERE ordernumber = 'P2412250000326' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434600'
                WHERE ordernumber = 'P2412250000336' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439296'
                WHERE ordernumber = 'P2412250000337' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427092'
                WHERE ordernumber = 'P2412250000340' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439298'
                WHERE ordernumber = 'P2412250000341' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310215'
                WHERE ordernumber = 'P2412250000345' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438899'
                WHERE ordernumber = 'P2412250000346' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439301'
                WHERE ordernumber = 'P2412250000349' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439303'
                WHERE ordernumber = 'P2412250000350' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439146'
                WHERE ordernumber = 'P2412250000352' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439302'
                WHERE ordernumber = 'P2412250000353' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439305'
                WHERE ordernumber = 'P2412250000354' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439122'
                WHERE ordernumber = 'P2412250000359' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439122'
                WHERE ordernumber = 'P2412250000362' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439308'
                WHERE ordernumber = 'P2412250000363' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228024'
                WHERE ordernumber = 'P2412250000364' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228024'
                WHERE ordernumber = 'P2412250000366' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439310'
                WHERE ordernumber = 'P2412250000370' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398151'
                WHERE ordernumber = 'P2412250000374' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439311'
                WHERE ordernumber = 'P2412250000375' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435281'
                WHERE ordernumber = 'P2412250000376' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228024'
                WHERE ordernumber = 'P2412250000378' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432849'
                WHERE ordernumber = 'P2412250000379' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439314'
                WHERE ordernumber = 'P2412250000380' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439314'
                WHERE ordernumber = 'P2412250000381' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439315'
                WHERE ordernumber = 'P2412250000383' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '203990'
                WHERE ordernumber = 'P2412250000390' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P2412250000394' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439319'
                WHERE ordernumber = 'P2412250000404' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439322'
                WHERE ordernumber = 'P2412250000406' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343932'
                WHERE ordernumber = 'P2412250000413' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439320'
                WHERE ordernumber = 'P2412250000415' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439332'
                WHERE ordernumber = 'P2412250000418' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30306'
                WHERE ordernumber = 'P2412250000422' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439331'
                WHERE ordernumber = 'P2412250000425' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439333'
                WHERE ordernumber = 'P2412250000427' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402225'
                WHERE ordernumber = 'P2412250000430' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439334'
                WHERE ordernumber = 'P2412250000434' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250283'
                WHERE ordernumber = 'P2412250000442' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '63064'
                WHERE ordernumber = 'P2412250000443' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258030'
                WHERE ordernumber = 'P2412250000448' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439339'
                WHERE ordernumber = 'P2412250000453' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439338'
                WHERE ordernumber = 'P2412250000455' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364701'
                WHERE ordernumber = 'P2412250000458' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434962'
                WHERE ordernumber = 'P2412250000461' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141550'
                WHERE ordernumber = 'P2412250000464' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439340'
                WHERE ordernumber = 'P2412250000470' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322480'
                WHERE ordernumber = 'P2412250000472' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302708'
                WHERE ordernumber = 'P2412250000473' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439343'
                WHERE ordernumber = 'P2412250000478' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100492'
                WHERE ordernumber = 'P2412250000487' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368618'
                WHERE ordernumber = 'P2412250000488' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432592'
                WHERE ordernumber = 'P2412250000489' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439346'
                WHERE ordernumber = 'P2412250000494' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307658'
                WHERE ordernumber = 'P2412250000497' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326003'
                WHERE ordernumber = 'P2412250000500' 
            
2024-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439335'
                WHERE ordernumber = 'P2412250000504' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277652'
                WHERE ordernumber = 'P2412250000506' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439352'
                WHERE ordernumber = 'P2412250000514' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439353'
                WHERE ordernumber = 'P2412250000515' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P2412250000517' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439356'
                WHERE ordernumber = 'P2412250000524' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364448'
                WHERE ordernumber = 'P2412250000528' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439363'
                WHERE ordernumber = 'P2412250000530' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439365'
                WHERE ordernumber = 'P2412250000533' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96089'
                WHERE ordernumber = 'P2412250000535' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96089'
                WHERE ordernumber = 'P2412250000536' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276492'
                WHERE ordernumber = 'P2412250000538' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439361'
                WHERE ordernumber = 'P2412250000541' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439366'
                WHERE ordernumber = 'P2412250000542' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345251'
                WHERE ordernumber = 'P2412250000546' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229335'
                WHERE ordernumber = 'P2412250000550' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439370'
                WHERE ordernumber = 'P2412250000551' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439368'
                WHERE ordernumber = 'P2412250000554' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439369'
                WHERE ordernumber = 'P2412250000556' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328134'
                WHERE ordernumber = 'P2412250000557' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439367'
                WHERE ordernumber = 'P2412250000559' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439371'
                WHERE ordernumber = 'P2412250000563' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439373'
                WHERE ordernumber = 'P2412250000573' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439370'
                WHERE ordernumber = 'P2412250000575' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '431884'
                WHERE ordernumber = 'P2412250000578' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '431156'
                WHERE ordernumber = 'P2412250000581' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96618'
                WHERE ordernumber = 'P2412250000584' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439377'
                WHERE ordernumber = 'P2412250000589' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439376'
                WHERE ordernumber = 'P2412250000590' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383608'
                WHERE ordernumber = 'P2412250000599' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286707'
                WHERE ordernumber = 'P2412250000606' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286707'
                WHERE ordernumber = 'P2412250000607' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439381'
                WHERE ordernumber = 'P2412250000608' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439383'
                WHERE ordernumber = 'P2412250000612' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393101'
                WHERE ordernumber = 'P2412250000613' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439384'
                WHERE ordernumber = 'P2412250000615' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P2412250000626' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439387'
                WHERE ordernumber = 'P2412250000627' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283089'
                WHERE ordernumber = 'P2412250000630' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293034'
                WHERE ordernumber = 'P2412250000635' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293034'
                WHERE ordernumber = 'P2412250000637' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439008'
                WHERE ordernumber = 'P2412250000638' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421312'
                WHERE ordernumber = 'P2412250000639' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436911'
                WHERE ordernumber = 'P2412250000640' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436911'
                WHERE ordernumber = 'P2412250000645' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439394'
                WHERE ordernumber = 'P2412250000646' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298811'
                WHERE ordernumber = 'P2412250000647' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267805'
                WHERE ordernumber = 'P2412250000650' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '438512'
                WHERE ordernumber = 'P2412250000658' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306813'
                WHERE ordernumber = 'P2412250000662' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439109'
                WHERE ordernumber = 'P2412250000663' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439402'
                WHERE ordernumber = 'P2412250000668' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96089'
                WHERE ordernumber = 'P2412250000671' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353350'
                WHERE ordernumber = 'P2412250000673' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439406'
                WHERE ordernumber = 'P2412250000678' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439401'
                WHERE ordernumber = 'P2412250000679' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420658'
                WHERE ordernumber = 'P2412250000681' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96089'
                WHERE ordernumber = 'P2412250000682' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439408'
                WHERE ordernumber = 'P2412250000686' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439410'
                WHERE ordernumber = 'P2412250000693' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239464'
                WHERE ordernumber = 'P2412250000695' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '427639'
                WHERE ordernumber = 'P2412250000701' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232968'
                WHERE ordernumber = 'P2412250000702' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439410'
                WHERE ordernumber = 'P2412250000703' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439412'
                WHERE ordernumber = 'P2412250000705' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412749'
                WHERE ordernumber = 'P2412250000710' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267464'
                WHERE ordernumber = 'P2412250000714' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439411'
                WHERE ordernumber = 'P2412250000715' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439411'
                WHERE ordernumber = 'P2412250000716' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '115108'
                WHERE ordernumber = 'P2412250000723' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302111'
                WHERE ordernumber = 'P2412250000728' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439419'
                WHERE ordernumber = 'P2412250000731' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '87340'
                WHERE ordernumber = 'P2412250000732' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439418'
                WHERE ordernumber = 'P2412250000733' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360906'
                WHERE ordernumber = 'P2412250000734' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437852'
                WHERE ordernumber = 'P2412250000737' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439421'
                WHERE ordernumber = 'P2412250000738' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302111'
                WHERE ordernumber = 'P2412250000740' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439423'
                WHERE ordernumber = 'P2412250000744' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439424'
                WHERE ordernumber = 'P2412250000748' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234993'
                WHERE ordernumber = 'P2412250000750' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238186'
                WHERE ordernumber = 'P2412250000751' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439429'
                WHERE ordernumber = 'P2412250000753' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439430'
                WHERE ordernumber = 'P2412250000755' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439020'
                WHERE ordernumber = 'P2412250000758' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235887'
                WHERE ordernumber = 'P2412250000760' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439279'
                WHERE ordernumber = 'P2412250000762' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439434'
                WHERE ordernumber = 'P2412250000765' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217156'
                WHERE ordernumber = 'P2412250000768' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439436'
                WHERE ordernumber = 'P2412250000769' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439432'
                WHERE ordernumber = 'P2412250000773' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272135'
                WHERE ordernumber = 'P2412250000779' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '65371'
                WHERE ordernumber = 'P2412250000786' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439440'
                WHERE ordernumber = 'P2412250000789' 
            
2024-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439435'
                WHERE ordernumber = 'P2412250000791' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '218734'
                WHERE ordernumber = 'P2412250000794' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '435951'
                WHERE ordernumber = 'P2412250000799' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '439446'
                WHERE ordernumber = 'P2412250000800' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '437909'
                WHERE ordernumber = 'P2412250000802' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '439441'
                WHERE ordernumber = 'P2412250000803' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '439447'
                WHERE ordernumber = 'P2412250000804' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '244185'
                WHERE ordernumber = 'P2412250000805' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '338908'
                WHERE ordernumber = 'P2412250000806' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '439443'
                WHERE ordernumber = 'P2412250000810' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '439449'
                WHERE ordernumber = 'P2412250000812' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '439450'
                WHERE ordernumber = 'P2412250000823' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '430265'
                WHERE ordernumber = 'P2412250000825' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '315538'
                WHERE ordernumber = 'P2412250000827' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '206917'
                WHERE ordernumber = 'P2412250000833' 
            
2024-12-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '439456'
                WHERE ordernumber = 'P2412250000841'