2024-11-21 01:00:01 -- 將會員中心id寫入data-lake
2024-11-21 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-11-20%';
        
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234846'
                WHERE ordernumber = 'P2411200000248' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430988'
                WHERE ordernumber = 'P2411200000450' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430989'
                WHERE ordernumber = 'P2411200000539' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384877'
                WHERE ordernumber = 'P2411200000629' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409737'
                WHERE ordernumber = 'P2411200000850' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430991'
                WHERE ordernumber = 'P2411200000932' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430990'
                WHERE ordernumber = 'P2411200001019' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122705'
                WHERE ordernumber = 'P2411200001152' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295649'
                WHERE ordernumber = 'P2411200001259' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430994'
                WHERE ordernumber = 'P2411200001597' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427011'
                WHERE ordernumber = 'P2411200001751' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427011'
                WHERE ordernumber = 'P2411200001896' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251553'
                WHERE ordernumber = 'P2411200002083' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430996'
                WHERE ordernumber = 'P2411200002131' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430997'
                WHERE ordernumber = 'P2411200002489' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '1540'
                WHERE ordernumber = 'P2411200002542' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '41125'
                WHERE ordernumber = 'P2411200002780' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314044'
                WHERE ordernumber = 'P2411200002933' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431001'
                WHERE ordernumber = 'P2411200003336' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431001'
                WHERE ordernumber = 'P2411200003725' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288868'
                WHERE ordernumber = 'P2411200004110' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383419'
                WHERE ordernumber = 'P2411200004387' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102271'
                WHERE ordernumber = 'P2411200004599' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221617'
                WHERE ordernumber = 'P2411200004979' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431007'
                WHERE ordernumber = 'P2411200005178' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328218'
                WHERE ordernumber = 'P2411200005227' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328218'
                WHERE ordernumber = 'P2411200005390' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431009'
                WHERE ordernumber = 'P2411200005435' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431013'
                WHERE ordernumber = 'P2411200005737' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '68515'
                WHERE ordernumber = 'P2411200005833' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314788'
                WHERE ordernumber = 'P2411200006026' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P2411200006335' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431014'
                WHERE ordernumber = 'P2411200006480' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389260'
                WHERE ordernumber = 'P2411200006535' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P2411200006622' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431016'
                WHERE ordernumber = 'P2411200006717' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431019'
                WHERE ordernumber = 'P2411200006823' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431021'
                WHERE ordernumber = 'P2411200007033' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430998'
                WHERE ordernumber = 'P2411200007198' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431022'
                WHERE ordernumber = 'P2411200007272' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429102'
                WHERE ordernumber = 'P2411200007357' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430166'
                WHERE ordernumber = 'P2411200007571' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431015'
                WHERE ordernumber = 'P2411200007653' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431024'
                WHERE ordernumber = 'P2411200007736' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118801'
                WHERE ordernumber = 'P2411200007853' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431025'
                WHERE ordernumber = 'P2411200007924' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395664'
                WHERE ordernumber = 'P2411200008054' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308755'
                WHERE ordernumber = 'P2411200008364' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431015'
                WHERE ordernumber = 'P2411200008571' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431024'
                WHERE ordernumber = 'P2411200008672' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222490'
                WHERE ordernumber = 'P2411200008757' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308755'
                WHERE ordernumber = 'P2411200008839' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281250'
                WHERE ordernumber = 'P2411200008928' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431028'
                WHERE ordernumber = 'P2411200009059' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431029'
                WHERE ordernumber = 'P2411200009291' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116317'
                WHERE ordernumber = 'P2411200009427' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159844'
                WHERE ordernumber = 'P2411200009580' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P2411200009698' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431034'
                WHERE ordernumber = 'P2411200009742' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431035'
                WHERE ordernumber = 'P2411200009918' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97778'
                WHERE ordernumber = 'P2411200010070' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424636'
                WHERE ordernumber = 'P2411200010185' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281578'
                WHERE ordernumber = 'P2411200010240' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431037'
                WHERE ordernumber = 'P2411200010533' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431038'
                WHERE ordernumber = 'P2411200010728' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431039'
                WHERE ordernumber = 'P2411200011197' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238597'
                WHERE ordernumber = 'P2411200011263' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421874'
                WHERE ordernumber = 'P2411200011699' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388338'
                WHERE ordernumber = 'P2411200011756' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431042'
                WHERE ordernumber = 'P2411200012074' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381315'
                WHERE ordernumber = 'P2411200012122' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431045'
                WHERE ordernumber = 'P2411200013033' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431048'
                WHERE ordernumber = 'P2411200013276' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431047'
                WHERE ordernumber = 'P2411200013351' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431044'
                WHERE ordernumber = 'P2411200013434' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426026'
                WHERE ordernumber = 'P2411200013571' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98228'
                WHERE ordernumber = 'P2411200013640' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426026'
                WHERE ordernumber = 'P2411200013828' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426026'
                WHERE ordernumber = 'P2411200013978' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431052'
                WHERE ordernumber = 'P2411200014195' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431053'
                WHERE ordernumber = 'P2411200014240' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431054'
                WHERE ordernumber = 'P2411200014412' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431055'
                WHERE ordernumber = 'P2411200014878' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327626'
                WHERE ordernumber = 'P2411200014964' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285018'
                WHERE ordernumber = 'P2411200015191' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431051'
                WHERE ordernumber = 'P2411200015331' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431058'
                WHERE ordernumber = 'P2411200015579' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395563'
                WHERE ordernumber = 'P2411200015699' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96065'
                WHERE ordernumber = 'P2411200015756' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420592'
                WHERE ordernumber = 'P2411200015891' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395190'
                WHERE ordernumber = 'P2411200015985' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217757'
                WHERE ordernumber = 'P2411200016195' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398716'
                WHERE ordernumber = 'P2411200016210' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431060'
                WHERE ordernumber = 'P2411200016439' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431061'
                WHERE ordernumber = 'P2411200016577' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430999'
                WHERE ordernumber = 'P2411200016642' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431062'
                WHERE ordernumber = 'P2411200016775' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399567'
                WHERE ordernumber = 'P2411200016879' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431063'
                WHERE ordernumber = 'P2411200016961' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429060'
                WHERE ordernumber = 'P2411200017312' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431065'
                WHERE ordernumber = 'P2411200017466' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431068'
                WHERE ordernumber = 'P2411200017547' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431069'
                WHERE ordernumber = 'P2411200017644' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421985'
                WHERE ordernumber = 'P2411200017799' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431070'
                WHERE ordernumber = 'P2411200017981' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431071'
                WHERE ordernumber = 'P2411200018092' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405696'
                WHERE ordernumber = 'P2411200018269' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167176'
                WHERE ordernumber = 'P2411200018317' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431072'
                WHERE ordernumber = 'P2411200018494' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431073'
                WHERE ordernumber = 'P2411200018584' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P2411200018722' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277908'
                WHERE ordernumber = 'P2411200018888' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236904'
                WHERE ordernumber = 'P2411200019139' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366850'
                WHERE ordernumber = 'P2411200019223' 
            
2024-11-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261941'
                WHERE ordernumber = 'P2411200019474' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314044'
                WHERE ordernumber = 'P2411200019669' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345751'
                WHERE ordernumber = 'P2411200019861' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431078'
                WHERE ordernumber = 'P2411200019957' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431080'
                WHERE ordernumber = 'P2411200020033' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329369'
                WHERE ordernumber = 'P2411200020125' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422323'
                WHERE ordernumber = 'P2411200020219' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431082'
                WHERE ordernumber = 'P2411200020313' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142919'
                WHERE ordernumber = 'P2411200020596' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299059'
                WHERE ordernumber = 'P2411200020622' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '7373'
                WHERE ordernumber = 'P2411200020797' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331533'
                WHERE ordernumber = 'P2411200020876' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79786'
                WHERE ordernumber = 'P2411200021750' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '43453'
                WHERE ordernumber = 'P2411200022185' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339562'
                WHERE ordernumber = 'P2411200022299' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428789'
                WHERE ordernumber = 'P2411200022367' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P2411200022516' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431084'
                WHERE ordernumber = 'P2411200022810' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298155'
                WHERE ordernumber = 'P2411200022935' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394857'
                WHERE ordernumber = 'P2411200023011' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240408'
                WHERE ordernumber = 'P2411200023189' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431085'
                WHERE ordernumber = 'P2411200023260' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431086'
                WHERE ordernumber = 'P2411200023495' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318415'
                WHERE ordernumber = 'P2411200023548' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431086'
                WHERE ordernumber = 'P2411200023616' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139102'
                WHERE ordernumber = 'P2411200023822' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383533'
                WHERE ordernumber = 'P2411200023992' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103922'
                WHERE ordernumber = 'P2411200024038' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431088'
                WHERE ordernumber = 'P2411200024137' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431090'
                WHERE ordernumber = 'P2411200024383' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431092'
                WHERE ordernumber = 'P2411200024446' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431091'
                WHERE ordernumber = 'P2411200024559' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81134'
                WHERE ordernumber = 'P2411200024685' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161147'
                WHERE ordernumber = 'P2411200024777' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208599'
                WHERE ordernumber = 'P2411200024881' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431094'
                WHERE ordernumber = 'P2411200025144' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431093'
                WHERE ordernumber = 'P2411200025258' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431095'
                WHERE ordernumber = 'P2411200025398' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348117'
                WHERE ordernumber = 'P2411200025410' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250269'
                WHERE ordernumber = 'P2411200025664' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138926'
                WHERE ordernumber = 'P2411200025754' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431096'
                WHERE ordernumber = 'P2411200025848' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117528'
                WHERE ordernumber = 'P2411200026022' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358060'
                WHERE ordernumber = 'P2411200026249' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115334'
                WHERE ordernumber = 'P2411200026366' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431089'
                WHERE ordernumber = 'P2411200026414' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431097'
                WHERE ordernumber = 'P2411200026544' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86284'
                WHERE ordernumber = 'P2411200026692' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430462'
                WHERE ordernumber = 'P2411200026776' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304848'
                WHERE ordernumber = 'P2411200026818' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431099'
                WHERE ordernumber = 'P2411200027047' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282773'
                WHERE ordernumber = 'P2411200027153' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430228'
                WHERE ordernumber = 'P2411200027260' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430274'
                WHERE ordernumber = 'P2411200027345' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137620'
                WHERE ordernumber = 'P2411200027455' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P2411200027779' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430114'
                WHERE ordernumber = 'P2411200027852' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405778'
                WHERE ordernumber = 'P2411200027993' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106563'
                WHERE ordernumber = 'P2411200028033' 
            
2024-11-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106563'
                WHERE ordernumber = 'P2411200028143'