2024-12-13 01:00:02 -- 將會員中心id寫入data-lake
2024-12-13 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-12%';
        
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431397'
                WHERE ordernumber = 'P2412120000241' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435014'
                WHERE ordernumber = 'P2412120000316' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '190306'
                WHERE ordernumber = 'P2412120000411' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '147635'
                WHERE ordernumber = 'P2412120000532' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '190306'
                WHERE ordernumber = 'P2412120000678' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400880'
                WHERE ordernumber = 'P2412120000781' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346953'
                WHERE ordernumber = 'P2412120000894' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435017'
                WHERE ordernumber = 'P2412120000922' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243370'
                WHERE ordernumber = 'P2412120001053' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94236'
                WHERE ordernumber = 'P2412120001152' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138130'
                WHERE ordernumber = 'P2412120001489' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102623'
                WHERE ordernumber = 'P2412120001527' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435023'
                WHERE ordernumber = 'P2412120001621' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420145'
                WHERE ordernumber = 'P2412120001738' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435031'
                WHERE ordernumber = 'P2412120001889' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435030'
                WHERE ordernumber = 'P2412120001984' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435032'
                WHERE ordernumber = 'P2412120002059' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '28159'
                WHERE ordernumber = 'P2412120002189' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435035'
                WHERE ordernumber = 'P2412120002252' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435033'
                WHERE ordernumber = 'P2412120002360' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435033'
                WHERE ordernumber = 'P2412120002418' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118117'
                WHERE ordernumber = 'P2412120002541' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235143'
                WHERE ordernumber = 'P2412120002935' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342308'
                WHERE ordernumber = 'P2412120003087' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435037'
                WHERE ordernumber = 'P2412120003162' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435034'
                WHERE ordernumber = 'P2412120003367' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142462'
                WHERE ordernumber = 'P2412120003467' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434767'
                WHERE ordernumber = 'P2412120003674' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433598'
                WHERE ordernumber = 'P2412120003789' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420968'
                WHERE ordernumber = 'P2412120003876' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435040'
                WHERE ordernumber = 'P2412120003926' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208567'
                WHERE ordernumber = 'P2412120004157' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220138'
                WHERE ordernumber = 'P2412120004254' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345751'
                WHERE ordernumber = 'P2412120004393' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271811'
                WHERE ordernumber = 'P2412120004756' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291837'
                WHERE ordernumber = 'P2412120005036' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301268'
                WHERE ordernumber = 'P2412120005127' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216260'
                WHERE ordernumber = 'P2412120005352' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431192'
                WHERE ordernumber = 'P2412120006070' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '202170'
                WHERE ordernumber = 'P2412120006135' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435052'
                WHERE ordernumber = 'P2412120006296' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435053'
                WHERE ordernumber = 'P2412120006448' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118408'
                WHERE ordernumber = 'P2412120006536' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433933'
                WHERE ordernumber = 'P2412120006628' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435054'
                WHERE ordernumber = 'P2412120006932' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435051'
                WHERE ordernumber = 'P2412120007072' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164917'
                WHERE ordernumber = 'P2412120007166' 
            
2024-12-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236606'
                WHERE ordernumber = 'P2412120007373' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154886'
                WHERE ordernumber = 'P2412120007581' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435057'
                WHERE ordernumber = 'P2412120007740' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435056'
                WHERE ordernumber = 'P2412120007954' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435059'
                WHERE ordernumber = 'P2412120008293' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397514'
                WHERE ordernumber = 'P2412120008333' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432326'
                WHERE ordernumber = 'P2412120008691' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435062'
                WHERE ordernumber = 'P2412120008745' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412120009259' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351987'
                WHERE ordernumber = 'P2412120009496' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406350'
                WHERE ordernumber = 'P2412120009612' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435066'
                WHERE ordernumber = 'P2412120009722' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247109'
                WHERE ordernumber = 'P2412120009898' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435072'
                WHERE ordernumber = 'P2412120010028' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420990'
                WHERE ordernumber = 'P2412120010260' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '35503'
                WHERE ordernumber = 'P2412120010469' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230649'
                WHERE ordernumber = 'P2412120010581' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251346'
                WHERE ordernumber = 'P2412120010762' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435073'
                WHERE ordernumber = 'P2412120010852' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435076'
                WHERE ordernumber = 'P2412120010919' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435077'
                WHERE ordernumber = 'P2412120011123' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '35503'
                WHERE ordernumber = 'P2412120011248' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255325'
                WHERE ordernumber = 'P2412120011556' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301149'
                WHERE ordernumber = 'P2412120011674' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125116'
                WHERE ordernumber = 'P2412120011749' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435079'
                WHERE ordernumber = 'P2412120011896' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125116'
                WHERE ordernumber = 'P2412120011968' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387822'
                WHERE ordernumber = 'P2412120012375' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93642'
                WHERE ordernumber = 'P2412120012428' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435082'
                WHERE ordernumber = 'P2412120012540' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387790'
                WHERE ordernumber = 'P2412120012958' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387790'
                WHERE ordernumber = 'P2412120013361' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348320'
                WHERE ordernumber = 'P2412120013431' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435084'
                WHERE ordernumber = 'P2412120013594' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435086'
                WHERE ordernumber = 'P2412120013819' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435088'
                WHERE ordernumber = 'P2412120014119' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435090'
                WHERE ordernumber = 'P2412120014371' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321657'
                WHERE ordernumber = 'P2412120014895' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248757'
                WHERE ordernumber = 'P2412120015147' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432415'
                WHERE ordernumber = 'P2412120015422' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435103'
                WHERE ordernumber = 'P2412120016486' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435099'
                WHERE ordernumber = 'P2412120016965' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118700'
                WHERE ordernumber = 'P2412120017051' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384494'
                WHERE ordernumber = 'P2412120017148' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336197'
                WHERE ordernumber = 'P2412120017267' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159648'
                WHERE ordernumber = 'P2412120017337' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368556'
                WHERE ordernumber = 'P2412120017472' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263902'
                WHERE ordernumber = 'P2412120017885' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435106'
                WHERE ordernumber = 'P2412120018099' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435112'
                WHERE ordernumber = 'P2412120018277' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385241'
                WHERE ordernumber = 'P2412120018329' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435113'
                WHERE ordernumber = 'P2412120018551' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2412120018713' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435112'
                WHERE ordernumber = 'P2412120018811' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398470'
                WHERE ordernumber = 'P2412120018979' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435116'
                WHERE ordernumber = 'P2412120019028' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137581'
                WHERE ordernumber = 'P2412120019194' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435118'
                WHERE ordernumber = 'P2412120019282' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434927'
                WHERE ordernumber = 'P2412120019331' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245453'
                WHERE ordernumber = 'P2412120019446' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424129'
                WHERE ordernumber = 'P2412120019612' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406535'
                WHERE ordernumber = 'P2412120019714' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P2412120019880' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435121'
                WHERE ordernumber = 'P2412120020050' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361052'
                WHERE ordernumber = 'P2412120020261' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396933'
                WHERE ordernumber = 'P2412120020346' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435122'
                WHERE ordernumber = 'P2412120020569' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435125'
                WHERE ordernumber = 'P2412120020838' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285334'
                WHERE ordernumber = 'P2412120020922' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410937'
                WHERE ordernumber = 'P2412120021030' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368044'
                WHERE ordernumber = 'P2412120021962' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435126'
                WHERE ordernumber = 'P2412120022151' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223594'
                WHERE ordernumber = 'P2412120022439' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435133'
                WHERE ordernumber = 'P2412120022780' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435137'
                WHERE ordernumber = 'P2412120023165' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435135'
                WHERE ordernumber = 'P2412120023222' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435129'
                WHERE ordernumber = 'P2412120023321' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345721'
                WHERE ordernumber = 'P2412120023447' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295067'
                WHERE ordernumber = 'P2412120023646' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404953'
                WHERE ordernumber = 'P2412120023756' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435140'
                WHERE ordernumber = 'P2412120023954' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411937'
                WHERE ordernumber = 'P2412120024036' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435136'
                WHERE ordernumber = 'P2412120024131' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435142'
                WHERE ordernumber = 'P2412120024421' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382041'
                WHERE ordernumber = 'P2412120024549' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435143'
                WHERE ordernumber = 'P2412120025144' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435145'
                WHERE ordernumber = 'P2412120025220' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379635'
                WHERE ordernumber = 'P2412120025327' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282484'
                WHERE ordernumber = 'P2412120025533' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435146'
                WHERE ordernumber = 'P2412120025610' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435147'
                WHERE ordernumber = 'P2412120025777' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435069'
                WHERE ordernumber = 'P2412120025847' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163897'
                WHERE ordernumber = 'P2412120025918' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236141'
                WHERE ordernumber = 'P2412120026263' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435150'
                WHERE ordernumber = 'P2412120026825' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435151'
                WHERE ordernumber = 'P2412120027270' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320138'
                WHERE ordernumber = 'P2412120027331' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425432'
                WHERE ordernumber = 'P2412120027427' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166939'
                WHERE ordernumber = 'P2412120027737' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396460'
                WHERE ordernumber = 'P2412120028084' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435141'
                WHERE ordernumber = 'P2412120028286' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435155'
                WHERE ordernumber = 'P2412120028468' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426333'
                WHERE ordernumber = 'P2412120028512' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391928'
                WHERE ordernumber = 'P2412120028694' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133909'
                WHERE ordernumber = 'P2412120028754' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292048'
                WHERE ordernumber = 'P2412120028928' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344219'
                WHERE ordernumber = 'P2412120029067' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435161'
                WHERE ordernumber = 'P2412120029159' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101892'
                WHERE ordernumber = 'P2412120029524' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355751'
                WHERE ordernumber = 'P2412120029617' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435162'
                WHERE ordernumber = 'P2412120029754' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298392'
                WHERE ordernumber = 'P2412120029863' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96012'
                WHERE ordernumber = 'P2412120029938' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243770'
                WHERE ordernumber = 'P2412120030026' 
            
2024-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410431'
                WHERE ordernumber = 'P2412120030271' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435164'
                WHERE ordernumber = 'P2412120030396' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341040'
                WHERE ordernumber = 'P2412120030475' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P2412120030595' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435164'
                WHERE ordernumber = 'P2412120030681' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379104'
                WHERE ordernumber = 'P2412120030770' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435169'
                WHERE ordernumber = 'P2412120030832' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435172'
                WHERE ordernumber = 'P2412120030983' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435171'
                WHERE ordernumber = 'P2412120031150' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435167'
                WHERE ordernumber = 'P2412120031232' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136649'
                WHERE ordernumber = 'P2412120031338' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242775'
                WHERE ordernumber = 'P2412120031549' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435174'
                WHERE ordernumber = 'P2412120031923' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435176'
                WHERE ordernumber = 'P2412120032021' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247609'
                WHERE ordernumber = 'P2412120032376' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210963'
                WHERE ordernumber = 'P2412120032481' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251344'
                WHERE ordernumber = 'P2412120032590' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339788'
                WHERE ordernumber = 'P2412120032765' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435177'
                WHERE ordernumber = 'P2412120032969' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228348'
                WHERE ordernumber = 'P2412120033095' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435180'
                WHERE ordernumber = 'P2412120033388' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435181'
                WHERE ordernumber = 'P2412120033478' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435183'
                WHERE ordernumber = 'P2412120033562' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435184'
                WHERE ordernumber = 'P2412120033621' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270515'
                WHERE ordernumber = 'P2412120033710' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435182'
                WHERE ordernumber = 'P2412120033889' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '172583'
                WHERE ordernumber = 'P2412120033910' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435186'
                WHERE ordernumber = 'P2412120034359' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379470'
                WHERE ordernumber = 'P2412120034442' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435188'
                WHERE ordernumber = 'P2412120034886' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166831'
                WHERE ordernumber = 'P2412120035294' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435191'
                WHERE ordernumber = 'P2412120035317' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '46166'
                WHERE ordernumber = 'P2412120035438' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118700'
                WHERE ordernumber = 'P2412120035579' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430536'
                WHERE ordernumber = 'P2412120035854' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435192'
                WHERE ordernumber = 'P2412120036150' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '28455'
                WHERE ordernumber = 'P2412120036241' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433103'
                WHERE ordernumber = 'P2412120036327' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96456'
                WHERE ordernumber = 'P2412120036478' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433496'
                WHERE ordernumber = 'P2412120036760' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239648'
                WHERE ordernumber = 'P2412120037446' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245038'
                WHERE ordernumber = 'P2412120038044' 
            
2024-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351381'
                WHERE ordernumber = 'P2412120038444'