2024-12-15 01:00:02 -- 將會員中心id寫入data-lake
2024-12-15 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-14%';
        
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95771'
                WHERE ordernumber = 'P2412140000117' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266705'
                WHERE ordernumber = 'P2412140000271' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412140000375' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267579'
                WHERE ordernumber = 'P2412140000560' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230475'
                WHERE ordernumber = 'P2412140000646' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P2412140000798' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '153148'
                WHERE ordernumber = 'P2412140001142' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435576'
                WHERE ordernumber = 'P2412140001260' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403084'
                WHERE ordernumber = 'P2412140001323' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327626'
                WHERE ordernumber = 'P2412140001685' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435579'
                WHERE ordernumber = 'P2412140001723' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435581'
                WHERE ordernumber = 'P2412140001823' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435582'
                WHERE ordernumber = 'P2412140002051' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435583'
                WHERE ordernumber = 'P2412140002155' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435578'
                WHERE ordernumber = 'P2412140002391' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435585'
                WHERE ordernumber = 'P2412140002546' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435586'
                WHERE ordernumber = 'P2412140002834' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435587'
                WHERE ordernumber = 'P2412140003173' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435590'
                WHERE ordernumber = 'P2412140003645' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351025'
                WHERE ordernumber = 'P2412140003751' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338342'
                WHERE ordernumber = 'P2412140003870' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103419'
                WHERE ordernumber = 'P2412140003946' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351025'
                WHERE ordernumber = 'P2412140004031' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435592'
                WHERE ordernumber = 'P2412140004197' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391919'
                WHERE ordernumber = 'P2412140004280' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97079'
                WHERE ordernumber = 'P2412140004351' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435593'
                WHERE ordernumber = 'P2412140004426' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434675'
                WHERE ordernumber = 'P2412140004911' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435596'
                WHERE ordernumber = 'P2412140005561' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435589'
                WHERE ordernumber = 'P2412140005629' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315781'
                WHERE ordernumber = 'P2412140005899' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351025'
                WHERE ordernumber = 'P2412140006049' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435317'
                WHERE ordernumber = 'P2412140006362' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111822'
                WHERE ordernumber = 'P2412140006469' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435599'
                WHERE ordernumber = 'P2412140007029' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111822'
                WHERE ordernumber = 'P2412140007380' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372870'
                WHERE ordernumber = 'P2412140007427' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435600'
                WHERE ordernumber = 'P2412140007531' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340161'
                WHERE ordernumber = 'P2412140007778' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369293'
                WHERE ordernumber = 'P2412140008026' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435598'
                WHERE ordernumber = 'P2412140008263' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435603'
                WHERE ordernumber = 'P2412140008370' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227393'
                WHERE ordernumber = 'P2412140008730' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435577'
                WHERE ordernumber = 'P2412140009063' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P2412140009120' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435577'
                WHERE ordernumber = 'P2412140009271' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435604'
                WHERE ordernumber = 'P2412140009223' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435608'
                WHERE ordernumber = 'P2412140009579' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435609'
                WHERE ordernumber = 'P2412140009614' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435611'
                WHERE ordernumber = 'P2412140009812' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381872'
                WHERE ordernumber = 'P2412140009949' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432732'
                WHERE ordernumber = 'P2412140010027' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225145'
                WHERE ordernumber = 'P2412140010146' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225145'
                WHERE ordernumber = 'P2412140010233' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385350'
                WHERE ordernumber = 'P2412140010460' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430317'
                WHERE ordernumber = 'P2412140010598' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225144'
                WHERE ordernumber = 'P2412140010616' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225144'
                WHERE ordernumber = 'P2412140010739' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435613'
                WHERE ordernumber = 'P2412140010887' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271799'
                WHERE ordernumber = 'P2412140010933' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435615'
                WHERE ordernumber = 'P2412140011321' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427132'
                WHERE ordernumber = 'P2412140011411' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283493'
                WHERE ordernumber = 'P2412140011589' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245786'
                WHERE ordernumber = 'P2412140011633' 
            
2024-12-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435616'
                WHERE ordernumber = 'P2412140011758' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433491'
                WHERE ordernumber = 'P2412140012059' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435617'
                WHERE ordernumber = 'P2412140012110' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435216'
                WHERE ordernumber = 'P2412140012370' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435618'
                WHERE ordernumber = 'P2412140012642' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435620'
                WHERE ordernumber = 'P2412140013181' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376510'
                WHERE ordernumber = 'P2412140013675' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435621'
                WHERE ordernumber = 'P2412140013755' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435622'
                WHERE ordernumber = 'P2412140013919' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P2412140014383' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435623'
                WHERE ordernumber = 'P2412140014449' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434353'
                WHERE ordernumber = 'P2412140014649' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121945'
                WHERE ordernumber = 'P2412140014772' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435626'
                WHERE ordernumber = 'P2412140014982' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424285'
                WHERE ordernumber = 'P2412140015097' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424285'
                WHERE ordernumber = 'P2412140015160' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209969'
                WHERE ordernumber = 'P2412140015335' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64750'
                WHERE ordernumber = 'P2412140015431' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301320'
                WHERE ordernumber = 'P2412140015650' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435635'
                WHERE ordernumber = 'P2412140015878' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435636'
                WHERE ordernumber = 'P2412140016031' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434806'
                WHERE ordernumber = 'P2412140016161' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435638'
                WHERE ordernumber = 'P2412140016214' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405125'
                WHERE ordernumber = 'P2412140016520' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391933'
                WHERE ordernumber = 'P2412140016620' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241368'
                WHERE ordernumber = 'P2412140016785' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435554'
                WHERE ordernumber = 'P2412140016932' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431897'
                WHERE ordernumber = 'P2412140017035' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435637'
                WHERE ordernumber = 'P2412140017281' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435642'
                WHERE ordernumber = 'P2412140017590' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429061'
                WHERE ordernumber = 'P2412140017676' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435645'
                WHERE ordernumber = 'P2412140017762' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '197499'
                WHERE ordernumber = 'P2412140017893' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435647'
                WHERE ordernumber = 'P2412140017927' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435648'
                WHERE ordernumber = 'P2412140018148' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435651'
                WHERE ordernumber = 'P2412140018416' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238267'
                WHERE ordernumber = 'P2412140018660' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223674'
                WHERE ordernumber = 'P2412140018711' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223674'
                WHERE ordernumber = 'P2412140018826' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314818'
                WHERE ordernumber = 'P2412140018955' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383101'
                WHERE ordernumber = 'P2412140019390' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322761'
                WHERE ordernumber = 'P2412140019520' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435653'
                WHERE ordernumber = 'P2412140019685' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435654'
                WHERE ordernumber = 'P2412140019757' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435656'
                WHERE ordernumber = 'P2412140019877' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305315'
                WHERE ordernumber = 'P2412140019956' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435657'
                WHERE ordernumber = 'P2412140020234' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261745'
                WHERE ordernumber = 'P2412140020366' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407980'
                WHERE ordernumber = 'P2412140020467' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435658'
                WHERE ordernumber = 'P2412140020528' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435660'
                WHERE ordernumber = 'P2412140020719' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435655'
                WHERE ordernumber = 'P2412140020813' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398845'
                WHERE ordernumber = 'P2412140020993' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435661'
                WHERE ordernumber = 'P2412140021044' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435662'
                WHERE ordernumber = 'P2412140021198' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346065'
                WHERE ordernumber = 'P2412140021244' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435663'
                WHERE ordernumber = 'P2412140021380' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435665'
                WHERE ordernumber = 'P2412140021491' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435667'
                WHERE ordernumber = 'P2412140021619' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435668'
                WHERE ordernumber = 'P2412140021794' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144461'
                WHERE ordernumber = 'P2412140021874' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132149'
                WHERE ordernumber = 'P2412140022085' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343620'
                WHERE ordernumber = 'P2412140022278' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435673'
                WHERE ordernumber = 'P2412140022384' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430331'
                WHERE ordernumber = 'P2412140022537' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237984'
                WHERE ordernumber = 'P2412140022849' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409737'
                WHERE ordernumber = 'P2412140023032' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '151038'
                WHERE ordernumber = 'P2412140023150' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '151038'
                WHERE ordernumber = 'P2412140023320' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98143'
                WHERE ordernumber = 'P2412140023457' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435675'
                WHERE ordernumber = 'P2412140023681' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435678'
                WHERE ordernumber = 'P2412140023792' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435682'
                WHERE ordernumber = 'P2412140023948' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P2412140024057' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425381'
                WHERE ordernumber = 'P2412140024362' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435683'
                WHERE ordernumber = 'P2412140024472' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P2412140024654' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435685'
                WHERE ordernumber = 'P2412140024737' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434777'
                WHERE ordernumber = 'P2412140025172' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434777'
                WHERE ordernumber = 'P2412140025218' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435688'
                WHERE ordernumber = 'P2412140025438' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435691'
                WHERE ordernumber = 'P2412140025786' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435693'
                WHERE ordernumber = 'P2412140025972' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435694'
                WHERE ordernumber = 'P2412140026182' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435315'
                WHERE ordernumber = 'P2412140026232' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355681'
                WHERE ordernumber = 'P2412140026386' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388338'
                WHERE ordernumber = 'P2412140026598' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435695'
                WHERE ordernumber = 'P2412140026648' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435696'
                WHERE ordernumber = 'P2412140026752' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161112'
                WHERE ordernumber = 'P2412140027272' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227161'
                WHERE ordernumber = 'P2412140027343' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435699'
                WHERE ordernumber = 'P2412140027423' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435689'
                WHERE ordernumber = 'P2412140027647' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319901'
                WHERE ordernumber = 'P2412140027863' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435702'
                WHERE ordernumber = 'P2412140028022' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433801'
                WHERE ordernumber = 'P2412140028131' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435706'
                WHERE ordernumber = 'P2412140028247' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435704'
                WHERE ordernumber = 'P2412140028319' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435707'
                WHERE ordernumber = 'P2412140028536' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226445'
                WHERE ordernumber = 'P2412140028689' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435709'
                WHERE ordernumber = 'P2412140028740' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435705'
                WHERE ordernumber = 'P2412140028986' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435711'
                WHERE ordernumber = 'P2412140029127' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435712'
                WHERE ordernumber = 'P2412140029222' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435713'
                WHERE ordernumber = 'P2412140029473' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435710'
                WHERE ordernumber = 'P2412140029585' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418346'
                WHERE ordernumber = 'P2412140029822' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435720'
                WHERE ordernumber = 'P2412140029972' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236690'
                WHERE ordernumber = 'P2412140030178' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435724'
                WHERE ordernumber = 'P2412140030697' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306819'
                WHERE ordernumber = 'P2412140030796' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293433'
                WHERE ordernumber = 'P2412140030833' 
            
2024-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435725'
                WHERE ordernumber = 'P2412140030986' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430489'
                WHERE ordernumber = 'P2412140031097' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435726'
                WHERE ordernumber = 'P2412140031257' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418346'
                WHERE ordernumber = 'P2412140031331' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432127'
                WHERE ordernumber = 'P2412140031470' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370353'
                WHERE ordernumber = 'P2412140031740' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223258'
                WHERE ordernumber = 'P2412140031868' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435727'
                WHERE ordernumber = 'P2412140032083' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435724'
                WHERE ordernumber = 'P2412140032334' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395002'
                WHERE ordernumber = 'P2412140032488' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435726'
                WHERE ordernumber = 'P2412140032513' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435734'
                WHERE ordernumber = 'P2412140032748' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435728'
                WHERE ordernumber = 'P2412140033042' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435735'
                WHERE ordernumber = 'P2412140033724' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421147'
                WHERE ordernumber = 'P2412140033880' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434468'
                WHERE ordernumber = 'P2412140033927' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358665'
                WHERE ordernumber = 'P2412140034052' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225612'
                WHERE ordernumber = 'P2412140034227' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435737'
                WHERE ordernumber = 'P2412140034378' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435738'
                WHERE ordernumber = 'P2412140034468' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214021'
                WHERE ordernumber = 'P2412140034547' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435739'
                WHERE ordernumber = 'P2412140034728' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435740'
                WHERE ordernumber = 'P2412140034951' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430553'
                WHERE ordernumber = 'P2412140035790' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430553'
                WHERE ordernumber = 'P2412140035845' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376902'
                WHERE ordernumber = 'P2412140035958' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431844'
                WHERE ordernumber = 'P2412140036184' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310196'
                WHERE ordernumber = 'P2412140036233' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '2431'
                WHERE ordernumber = 'P2412140036833' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435743'
                WHERE ordernumber = 'P2412140036999' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403500'
                WHERE ordernumber = 'P2412140037139' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435748'
                WHERE ordernumber = 'P2412140037540' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435745'
                WHERE ordernumber = 'P2412140037782' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435750'
                WHERE ordernumber = 'P2412140037878' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435751'
                WHERE ordernumber = 'P2412140037963' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435747'
                WHERE ordernumber = 'P2412140038244' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435753'
                WHERE ordernumber = 'P2412140038741' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119761'
                WHERE ordernumber = 'P2412140038845' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435754'
                WHERE ordernumber = 'P2412140038931' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236130'
                WHERE ordernumber = 'P2412140039316' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435729'
                WHERE ordernumber = 'P2412140039528' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253937'
                WHERE ordernumber = 'P2412140039766' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '53652'
                WHERE ordernumber = 'P2412140039858' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433266'
                WHERE ordernumber = 'P2412140039958' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433266'
                WHERE ordernumber = 'P2412140040022' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433266'
                WHERE ordernumber = 'P2412140040249' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434943'
                WHERE ordernumber = 'P2412140040328' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253937'
                WHERE ordernumber = 'P2412140040427' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435757'
                WHERE ordernumber = 'P2412140040542' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434943'
                WHERE ordernumber = 'P2412140040619' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435758'
                WHERE ordernumber = 'P2412140040710' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435756'
                WHERE ordernumber = 'P2412140040816' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435729'
                WHERE ordernumber = 'P2412140040980' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253937'
                WHERE ordernumber = 'P2412140041015' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435759'
                WHERE ordernumber = 'P2412140041149' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338630'
                WHERE ordernumber = 'P2412140041257' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354279'
                WHERE ordernumber = 'P2412140041312' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411364'
                WHERE ordernumber = 'P2412140041482' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335693'
                WHERE ordernumber = 'P2412140041550' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435760'
                WHERE ordernumber = 'P2412140041872' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431402'
                WHERE ordernumber = 'P2412140042298' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425036'
                WHERE ordernumber = 'P2412140042515' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302554'
                WHERE ordernumber = 'P2412140042663' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435768'
                WHERE ordernumber = 'P2412140042940' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344119'
                WHERE ordernumber = 'P2412140043046' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435769'
                WHERE ordernumber = 'P2412140043155' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419560'
                WHERE ordernumber = 'P2412140043215' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435773'
                WHERE ordernumber = 'P2412140043322' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435774'
                WHERE ordernumber = 'P2412140043432' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363024'
                WHERE ordernumber = 'P2412140043779' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435775'
                WHERE ordernumber = 'P2412140043831' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430676'
                WHERE ordernumber = 'P2412140043984' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119658'
                WHERE ordernumber = 'P2412140044345' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238188'
                WHERE ordernumber = 'P2412140044652' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423448'
                WHERE ordernumber = 'P2412140044742' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435777'
                WHERE ordernumber = 'P2412140044969' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433720'
                WHERE ordernumber = 'P2412140045126' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99853'
                WHERE ordernumber = 'P2412140045259' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434874'
                WHERE ordernumber = 'P2412140045323' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224149'
                WHERE ordernumber = 'P2412140045627' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434202'
                WHERE ordernumber = 'P2412140045774' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P2412140046164' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '33195'
                WHERE ordernumber = 'P2412140046638' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432551'
                WHERE ordernumber = 'P2412140047690' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138469'
                WHERE ordernumber = 'P2412140047847' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435789'
                WHERE ordernumber = 'P2412140047978' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288395'
                WHERE ordernumber = 'P2412140048061' 
            
2024-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '57216'
                WHERE ordernumber = 'P2412140048392'