2024-10-12 01:00:01 -- 將會員中心id寫入data-lake
2024-10-12 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-10-11%';
        
2024-10-12 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '148654'
                WHERE ordernumber = 'P711011110241736' 
            
2024-10-12 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '136223'
                WHERE ordernumber = 'P201011110347905' 
            
2024-10-12 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '244714'
                WHERE ordernumber = 'P191011110555708' 
            
2024-10-12 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '425269'
                WHERE ordernumber = 'P421011110624744' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '190225'
                WHERE ordernumber = 'P421011110843851' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217639'
                WHERE ordernumber = 'P191011111128978' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314020'
                WHERE ordernumber = 'P201011111328168' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425273'
                WHERE ordernumber = 'P191011111417945' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282647'
                WHERE ordernumber = 'P421011111439140' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346885'
                WHERE ordernumber = 'P201011111553518' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425274'
                WHERE ordernumber = 'P191011111707358' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423465'
                WHERE ordernumber = 'P201011111853536' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351153'
                WHERE ordernumber = 'P191011111941592' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425275'
                WHERE ordernumber = 'P421011112048806' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425276'
                WHERE ordernumber = 'P201011112233533' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96282'
                WHERE ordernumber = 'P201011112532340' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425279'
                WHERE ordernumber = 'P181011112545385' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101775'
                WHERE ordernumber = 'P191011112705418' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425278'
                WHERE ordernumber = 'P421011112722243' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425280'
                WHERE ordernumber = 'P181011112816727' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425277'
                WHERE ordernumber = 'P181011113038675' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425282'
                WHERE ordernumber = 'P181011114153703' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425283'
                WHERE ordernumber = 'P711011114548633' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425215'
                WHERE ordernumber = 'P421011114623546' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402378'
                WHERE ordernumber = 'P191011114857123' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326495'
                WHERE ordernumber = 'P201011115309631' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88985'
                WHERE ordernumber = 'P181011115440811' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320057'
                WHERE ordernumber = 'P201011115531204' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425288'
                WHERE ordernumber = 'P191011115911830' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311550'
                WHERE ordernumber = 'P181011120357627' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425290'
                WHERE ordernumber = 'P421011120535269' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425291'
                WHERE ordernumber = 'P181011121120144' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425286'
                WHERE ordernumber = 'P191011121314906' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425292'
                WHERE ordernumber = 'P181011121839241' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425294'
                WHERE ordernumber = 'P201011122045617' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425295'
                WHERE ordernumber = 'P201011122211215' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425291'
                WHERE ordernumber = 'P181011122220997' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425296'
                WHERE ordernumber = 'P201011122533867' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226838'
                WHERE ordernumber = 'P201011122617963' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425293'
                WHERE ordernumber = 'P181011122855515' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425296'
                WHERE ordernumber = 'P201011123036156' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376977'
                WHERE ordernumber = 'P711011123037186' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258964'
                WHERE ordernumber = 'P201011123303361' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425297'
                WHERE ordernumber = 'P201011123452291' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425299'
                WHERE ordernumber = 'P181011123523408' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425300'
                WHERE ordernumber = 'P181011123644359' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425301'
                WHERE ordernumber = 'P181011124057721' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425302'
                WHERE ordernumber = 'P711011124313646' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '330640'
                WHERE ordernumber = 'P421011124416546' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425304'
                WHERE ordernumber = 'P181011124428540' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284599'
                WHERE ordernumber = 'P201011124445839' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425303'
                WHERE ordernumber = 'P181011124731388' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103520'
                WHERE ordernumber = 'P181011124944295' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98621'
                WHERE ordernumber = 'P421011125258893' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425305'
                WHERE ordernumber = 'P181011125333749' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220669'
                WHERE ordernumber = 'P201011125805947' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '20'
                WHERE ordernumber = 'P181011125809569' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333579'
                WHERE ordernumber = 'P181011130059763' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425309'
                WHERE ordernumber = 'P201011130140183' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129132'
                WHERE ordernumber = 'P181011130242244' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93464'
                WHERE ordernumber = 'P711011130936459' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425306'
                WHERE ordernumber = 'P181011131130769' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425308'
                WHERE ordernumber = 'P181011131415855' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392762'
                WHERE ordernumber = 'P181011131610833' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425310'
                WHERE ordernumber = 'P191011132543319' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425311'
                WHERE ordernumber = 'P711011132835290' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376605'
                WHERE ordernumber = 'P421011132934201' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94987'
                WHERE ordernumber = 'P181011133030838' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307752'
                WHERE ordernumber = 'P201011133146440' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393562'
                WHERE ordernumber = 'P191011133224807' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425312'
                WHERE ordernumber = 'P181011133704146' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425312'
                WHERE ordernumber = 'P181011133743150' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425313'
                WHERE ordernumber = 'P421011133845372' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425314'
                WHERE ordernumber = 'P711011134139695' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425316'
                WHERE ordernumber = 'P191011135109396' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423518'
                WHERE ordernumber = 'P181011140329611' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425317'
                WHERE ordernumber = 'P181011140632269' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425318'
                WHERE ordernumber = 'P421011140653976' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406199'
                WHERE ordernumber = 'P201011140914958' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425319'
                WHERE ordernumber = 'P421011141216859' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309593'
                WHERE ordernumber = 'P201011141403680' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425321'
                WHERE ordernumber = 'P421011142136392' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301284'
                WHERE ordernumber = 'P181011142451544' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425323'
                WHERE ordernumber = 'P421011142655289' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425324'
                WHERE ordernumber = 'P181011142704547' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '147323'
                WHERE ordernumber = 'P201011142935327' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425326'
                WHERE ordernumber = 'P421011143249112' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425328'
                WHERE ordernumber = 'P711011143732339' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86775'
                WHERE ordernumber = 'P181011144442620' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406903'
                WHERE ordernumber = 'P201011144543707' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81698'
                WHERE ordernumber = 'P181011144642921' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425329'
                WHERE ordernumber = 'P191011144729583' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425333'
                WHERE ordernumber = 'P201011145112781' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425330'
                WHERE ordernumber = 'P421011145148448' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115139'
                WHERE ordernumber = 'P181011145322719' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358001'
                WHERE ordernumber = 'P181011145510160' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425334'
                WHERE ordernumber = 'P191011145803614' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264532'
                WHERE ordernumber = 'P181011145843938' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425336'
                WHERE ordernumber = 'P421011150211624' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425335'
                WHERE ordernumber = 'P731011150231809' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425337'
                WHERE ordernumber = 'P421011150452120' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425338'
                WHERE ordernumber = 'P421011150557550' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225810'
                WHERE ordernumber = 'P201011150832146' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425340'
                WHERE ordernumber = 'P181011151242344' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425341'
                WHERE ordernumber = 'P181011151336483' 
            
2024-10-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425339'
                WHERE ordernumber = 'P711011151403484' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425344'
                WHERE ordernumber = 'P181011151717934' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425342'
                WHERE ordernumber = 'P421011151745427' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425345'
                WHERE ordernumber = 'P181011152036143' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401153'
                WHERE ordernumber = 'P201011152139582' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97071'
                WHERE ordernumber = 'P181011152311737' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408727'
                WHERE ordernumber = 'P421011152351675' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425343'
                WHERE ordernumber = 'P181011152523217' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425346'
                WHERE ordernumber = 'P711011152607655' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425343'
                WHERE ordernumber = 'P181011152618292' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273486'
                WHERE ordernumber = 'P181011152701247' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425347'
                WHERE ordernumber = 'P201011152749673' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385439'
                WHERE ordernumber = 'P201011153112261' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425348'
                WHERE ordernumber = 'P181011153137589' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385439'
                WHERE ordernumber = 'P201011153217755' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425350'
                WHERE ordernumber = 'P181011153256426' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425349'
                WHERE ordernumber = 'P421011153343794' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283210'
                WHERE ordernumber = 'P421011153502644' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425348'
                WHERE ordernumber = 'P181011153600963' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425351'
                WHERE ordernumber = 'P191011153622711' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425352'
                WHERE ordernumber = 'P191011154030920' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425353'
                WHERE ordernumber = 'P201011154103227' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400648'
                WHERE ordernumber = 'P421011154338550' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390158'
                WHERE ordernumber = 'P191011154448928' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425354'
                WHERE ordernumber = 'P421011155134611' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425357'
                WHERE ordernumber = 'P201011155330536' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '151368'
                WHERE ordernumber = 'P201011155427274' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425355'
                WHERE ordernumber = 'P711011155546492' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425356'
                WHERE ordernumber = 'P421011155646374' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425358'
                WHERE ordernumber = 'P711011155740919' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425359'
                WHERE ordernumber = 'P181011155747260' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P711011155845364' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181011155858498' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425360'
                WHERE ordernumber = 'P181011160011127' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425362'
                WHERE ordernumber = 'P191011160207361' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425361'
                WHERE ordernumber = 'P711011160243305' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181011160444217' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425364'
                WHERE ordernumber = 'P711011160448635' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425363'
                WHERE ordernumber = 'P711011160649907' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181011160703367' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425365'
                WHERE ordernumber = 'P191011160732315' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425363'
                WHERE ordernumber = 'P711011160749788' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181011160937860' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81316'
                WHERE ordernumber = 'P191011161143389' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181011161152545' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425366'
                WHERE ordernumber = 'P711011161212987' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425368'
                WHERE ordernumber = 'P421011161320292' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425367'
                WHERE ordernumber = 'P711011161337522' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425355'
                WHERE ordernumber = 'P711011161435438' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181011161448332' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425372'
                WHERE ordernumber = 'P201011161735114' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425369'
                WHERE ordernumber = 'P191011161816669' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425371'
                WHERE ordernumber = 'P421011161943843' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181011162106788' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398611'
                WHERE ordernumber = 'P631011162118158' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425373'
                WHERE ordernumber = 'P201011162138386' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425370'
                WHERE ordernumber = 'P191011162213558' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392985'
                WHERE ordernumber = 'P201011162310616' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425375'
                WHERE ordernumber = 'P201011162357803' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181011162412864' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P191011162454973' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425374'
                WHERE ordernumber = 'P421011162531653' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425376'
                WHERE ordernumber = 'P201011162651875' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241589'
                WHERE ordernumber = 'P191011162753322' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213314'
                WHERE ordernumber = 'P181011162819459' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425373'
                WHERE ordernumber = 'P201011163152787' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425377'
                WHERE ordernumber = 'P191011163424779' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425378'
                WHERE ordernumber = 'P191011163729393' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425381'
                WHERE ordernumber = 'P201011164007478' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425380'
                WHERE ordernumber = 'P421011164036441' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105630'
                WHERE ordernumber = 'P201011164151804' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425379'
                WHERE ordernumber = 'P731011164209237' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280165'
                WHERE ordernumber = 'P421011164412844' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425382'
                WHERE ordernumber = 'P421011164457973' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425383'
                WHERE ordernumber = 'P421011164748224' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425384'
                WHERE ordernumber = 'P181011164853711' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252973'
                WHERE ordernumber = 'P181011165111696' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388971'
                WHERE ordernumber = 'P181011165249592' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425385'
                WHERE ordernumber = 'P711011165327236' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384006'
                WHERE ordernumber = 'P421011165548816' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425386'
                WHERE ordernumber = 'P421011170420476' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425388'
                WHERE ordernumber = 'P181011170756244' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423834'
                WHERE ordernumber = 'P421011170933718' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135384'
                WHERE ordernumber = 'P191011170940421' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425389'
                WHERE ordernumber = 'P711011171125347' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425390'
                WHERE ordernumber = 'P181011171319207' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425391'
                WHERE ordernumber = 'P201011171845312' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339775'
                WHERE ordernumber = 'P181011172138984' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63410'
                WHERE ordernumber = 'P421011172406233' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90191'
                WHERE ordernumber = 'P201011172824980' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425392'
                WHERE ordernumber = 'P711011172849579' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354894'
                WHERE ordernumber = 'P181011172852742' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258492'
                WHERE ordernumber = 'P181011173109402' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339872'
                WHERE ordernumber = 'P631011173112415' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P201011173155493' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425393'
                WHERE ordernumber = 'P421011173202480' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425393'
                WHERE ordernumber = 'P421011173301715' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424665'
                WHERE ordernumber = 'P181011173646706' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423666'
                WHERE ordernumber = 'P421011174133837' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212548'
                WHERE ordernumber = 'P181011174443307' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212548'
                WHERE ordernumber = 'P181011174519776' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425395'
                WHERE ordernumber = 'P181011174712486' 
            
2024-10-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425399'
                WHERE ordernumber = 'P201011175208740' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238643'
                WHERE ordernumber = 'P181011175419919' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350077'
                WHERE ordernumber = 'P181011175641612' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425398'
                WHERE ordernumber = 'P181011175910586' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425400'
                WHERE ordernumber = 'P181011180021500' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425401'
                WHERE ordernumber = 'P711011180112113' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411189'
                WHERE ordernumber = 'P191011180112792' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425402'
                WHERE ordernumber = 'P201011180145951' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398271'
                WHERE ordernumber = 'P421011180455958' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300239'
                WHERE ordernumber = 'P421011180602912' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425403'
                WHERE ordernumber = 'P181011180614809' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390006'
                WHERE ordernumber = 'P191011180623152' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425407'
                WHERE ordernumber = 'P201011180647138' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425404'
                WHERE ordernumber = 'P191011180817333' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425405'
                WHERE ordernumber = 'P191011180953167' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425406'
                WHERE ordernumber = 'P181011181025619' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235271'
                WHERE ordernumber = 'P201011181042668' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425406'
                WHERE ordernumber = 'P181011181314515' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291983'
                WHERE ordernumber = 'P191011181450431' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425409'
                WHERE ordernumber = 'P201011181620782' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425410'
                WHERE ordernumber = 'P191011181657616' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425408'
                WHERE ordernumber = 'P181011181734606' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246667'
                WHERE ordernumber = 'P181011181828136' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '145397'
                WHERE ordernumber = 'P181011182016181' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425406'
                WHERE ordernumber = 'P181011182406433' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425411'
                WHERE ordernumber = 'P421011182600438' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284324'
                WHERE ordernumber = 'P181011182818205' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154706'
                WHERE ordernumber = 'P731011183206449' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425414'
                WHERE ordernumber = 'P201011183611951' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331449'
                WHERE ordernumber = 'P181011183719690' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280986'
                WHERE ordernumber = 'P181011184153234' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425413'
                WHERE ordernumber = 'P181011184313315' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345956'
                WHERE ordernumber = 'P191011184316965' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425416'
                WHERE ordernumber = 'P201011184530882' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425412'
                WHERE ordernumber = 'P181011184643831' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283420'
                WHERE ordernumber = 'P201011184648243' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425415'
                WHERE ordernumber = 'P191011184704578' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425416'
                WHERE ordernumber = 'P201011184755654' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242828'
                WHERE ordernumber = 'P191011185119123' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214355'
                WHERE ordernumber = 'P201011185230810' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425419'
                WHERE ordernumber = 'P201011185656906' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425420'
                WHERE ordernumber = 'P711011190127171' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381376'
                WHERE ordernumber = 'P631011190453116' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379470'
                WHERE ordernumber = 'P201011190529799' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114397'
                WHERE ordernumber = 'P191011191120292' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423159'
                WHERE ordernumber = 'P711011191140843' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425423'
                WHERE ordernumber = 'P201011191259734' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425421'
                WHERE ordernumber = 'P191011191428364' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425422'
                WHERE ordernumber = 'P711011191533581' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326189'
                WHERE ordernumber = 'P201011191543486' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271069'
                WHERE ordernumber = 'P711011191636577' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344237'
                WHERE ordernumber = 'P201011191803452' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425424'
                WHERE ordernumber = 'P191011192200178' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425426'
                WHERE ordernumber = 'P191011192454503' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424164'
                WHERE ordernumber = 'P711011192517278' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425425'
                WHERE ordernumber = 'P191011192529507' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425428'
                WHERE ordernumber = 'P201011192858318' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425429'
                WHERE ordernumber = 'P201011193121393' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389404'
                WHERE ordernumber = 'P191011193511580' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394922'
                WHERE ordernumber = 'P191011194242299' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425431'
                WHERE ordernumber = 'P191011194742174' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425430'
                WHERE ordernumber = 'P191011194823208' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P201011194917573' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425432'
                WHERE ordernumber = 'P191011195550731' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425433'
                WHERE ordernumber = 'P191011195821754' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409791'
                WHERE ordernumber = 'P191011195910881' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260925'
                WHERE ordernumber = 'P631011201320651' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423987'
                WHERE ordernumber = 'P731011202932258' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424979'
                WHERE ordernumber = 'P731011204217544' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373875'
                WHERE ordernumber = 'P711011205944734' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425436'
                WHERE ordernumber = 'P711011212008483' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425096'
                WHERE ordernumber = 'P711011212726338' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325806'
                WHERE ordernumber = 'P631011213118569' 
            
2024-10-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425438'
                WHERE ordernumber = 'P731011215941379'