2023-12-23 01:00:02 -- 將會員中心id寫入data-lake
2023-12-23 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 '2023-12-22%';
        
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290185'
                WHERE ordernumber = 'P421222105457162' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353933'
                WHERE ordernumber = 'P421222105720957' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353933'
                WHERE ordernumber = 'P421222105840485' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354147'
                WHERE ordernumber = 'P201222110248156' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81960'
                WHERE ordernumber = 'P181222110250586' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209287'
                WHERE ordernumber = 'P181222110317559' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224447'
                WHERE ordernumber = 'P181222110428336' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354148'
                WHERE ordernumber = 'P421222110906391' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142190'
                WHERE ordernumber = 'P181222111136554' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P201222111546751' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354150'
                WHERE ordernumber = 'P181222111642147' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P421222111808433' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354152'
                WHERE ordernumber = 'P181222112107944' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354149'
                WHERE ordernumber = 'P421222112117150' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351381'
                WHERE ordernumber = 'P201222112435662' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '33352'
                WHERE ordernumber = 'P421222112540167' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354153'
                WHERE ordernumber = 'P421222112813684' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354130'
                WHERE ordernumber = 'P181222112851855' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354130'
                WHERE ordernumber = 'P181222112925524' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352813'
                WHERE ordernumber = 'P181222112954642' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P421222113028224' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352638'
                WHERE ordernumber = 'P181222113112386' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '33352'
                WHERE ordernumber = 'P421222113124571' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352638'
                WHERE ordernumber = 'P181222113153814' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217234'
                WHERE ordernumber = 'P181222113236280' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354155'
                WHERE ordernumber = 'P181222114419628' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354156'
                WHERE ordernumber = 'P181222114800852' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342308'
                WHERE ordernumber = 'P181222115018116' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354157'
                WHERE ordernumber = 'P181222115230645' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354158'
                WHERE ordernumber = 'P181222115329876' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80649'
                WHERE ordernumber = 'P421222115452417' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342457'
                WHERE ordernumber = 'P201222115549231' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354159'
                WHERE ordernumber = 'P181222115703788' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252835'
                WHERE ordernumber = 'P181222115814368' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252835'
                WHERE ordernumber = 'P181222115849777' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227332'
                WHERE ordernumber = 'P421222115856677' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354160'
                WHERE ordernumber = 'P201222120133540' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164325'
                WHERE ordernumber = 'P201222120208754' 
            
2023-12-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354162'
                WHERE ordernumber = 'P421222120316820' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158766'
                WHERE ordernumber = 'P181222120338794' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324842'
                WHERE ordernumber = 'P421222120631888' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354163'
                WHERE ordernumber = 'P181222120737320' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262406'
                WHERE ordernumber = 'P181222120928478' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279063'
                WHERE ordernumber = 'P201222121100439' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354164'
                WHERE ordernumber = 'P181222121428256' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '194030'
                WHERE ordernumber = 'P181222121642464' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278307'
                WHERE ordernumber = 'P201222122032973' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297787'
                WHERE ordernumber = 'P181222122423170' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352214'
                WHERE ordernumber = 'P181222122850473' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '29536'
                WHERE ordernumber = 'P181222123204287' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291884'
                WHERE ordernumber = 'P421222123251276' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346296'
                WHERE ordernumber = 'P181222123256252' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220080'
                WHERE ordernumber = 'P181222123509690' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295740'
                WHERE ordernumber = 'P201222123614454' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354169'
                WHERE ordernumber = 'P201222123722264' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354170'
                WHERE ordernumber = 'P181222124141683' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354172'
                WHERE ordernumber = 'P201222124149258' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354173'
                WHERE ordernumber = 'P181222124338730' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354174'
                WHERE ordernumber = 'P181222124527212' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309057'
                WHERE ordernumber = 'P181222124630187' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80063'
                WHERE ordernumber = 'P201222124718933' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251706'
                WHERE ordernumber = 'P421222124724353' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347875'
                WHERE ordernumber = 'P181222124805951' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350995'
                WHERE ordernumber = 'P201222124955502' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354177'
                WHERE ordernumber = 'P181222125231597' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77463'
                WHERE ordernumber = 'P421222125250397' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348597'
                WHERE ordernumber = 'P421222125421439' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296213'
                WHERE ordernumber = 'P181222125548807' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354179'
                WHERE ordernumber = 'P421222125813699' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354181'
                WHERE ordernumber = 'P421222130216896' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354182'
                WHERE ordernumber = 'P181222130336784' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354183'
                WHERE ordernumber = 'P201222130358771' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354184'
                WHERE ordernumber = 'P201222130520549' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354185'
                WHERE ordernumber = 'P421222130537818' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '177234'
                WHERE ordernumber = 'P201222130643651' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162387'
                WHERE ordernumber = 'P421222130821791' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354186'
                WHERE ordernumber = 'P201222130956301' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354187'
                WHERE ordernumber = 'P181222131007135' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354188'
                WHERE ordernumber = 'P421222131017862' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273088'
                WHERE ordernumber = 'P181222131055374' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354182'
                WHERE ordernumber = 'P181222131131350' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62760'
                WHERE ordernumber = 'P201222131210371' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252835'
                WHERE ordernumber = 'P181222131438971' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252835'
                WHERE ordernumber = 'P181222131505238' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252835'
                WHERE ordernumber = 'P181222131531887' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268794'
                WHERE ordernumber = 'P201222131712879' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351992'
                WHERE ordernumber = 'P201222132650194' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354192'
                WHERE ordernumber = 'P421222132748154' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354191'
                WHERE ordernumber = 'P181222132831922' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267051'
                WHERE ordernumber = 'P201222133108393' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354194'
                WHERE ordernumber = 'P201222133250320' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310500'
                WHERE ordernumber = 'P201222133316909' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354195'
                WHERE ordernumber = 'P181222133317851' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242845'
                WHERE ordernumber = 'P191222133402625' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267051'
                WHERE ordernumber = 'P201222133420332' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354197'
                WHERE ordernumber = 'P181222133510822' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220053'
                WHERE ordernumber = 'P181222133631443' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278592'
                WHERE ordernumber = 'P201222133731650' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354198'
                WHERE ordernumber = 'P181222133908915' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339941'
                WHERE ordernumber = 'P201222133916122' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118908'
                WHERE ordernumber = 'P191222133947429' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354200'
                WHERE ordernumber = 'P201222134043692' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354201'
                WHERE ordernumber = 'P181222134107740' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354202'
                WHERE ordernumber = 'P201222134204114' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348887'
                WHERE ordernumber = 'P421222134402246' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353243'
                WHERE ordernumber = 'P181222134614835' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349584'
                WHERE ordernumber = 'P421222135221123' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277785'
                WHERE ordernumber = 'P181222135259146' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272356'
                WHERE ordernumber = 'P421222135445455' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354205'
                WHERE ordernumber = 'P181222135804307' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354206'
                WHERE ordernumber = 'P181222140000401' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172875'
                WHERE ordernumber = 'P181222140133820' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282767'
                WHERE ordernumber = 'P421222140159958' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P181222140317775' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354207'
                WHERE ordernumber = 'P181222140436218' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334506'
                WHERE ordernumber = 'P421222140901928' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351150'
                WHERE ordernumber = 'P421222141306876' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347055'
                WHERE ordernumber = 'P181222141332755' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318927'
                WHERE ordernumber = 'P181222141650112' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318927'
                WHERE ordernumber = 'P181222141733661' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354212'
                WHERE ordernumber = 'P201222141941170' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147891'
                WHERE ordernumber = 'P191222142211244' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118908'
                WHERE ordernumber = 'P191222142611641' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346744'
                WHERE ordernumber = 'P191222142641503' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354213'
                WHERE ordernumber = 'P201222143014142' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354213'
                WHERE ordernumber = 'P201222143032256' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244275'
                WHERE ordernumber = 'P181222143315465' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354216'
                WHERE ordernumber = 'P181222143718592' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348726'
                WHERE ordernumber = 'P421222143736429' 
            
2023-12-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354214'
                WHERE ordernumber = 'P181222143747137' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291853'
                WHERE ordernumber = 'P181222143850770' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P181222144154922' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84772'
                WHERE ordernumber = 'P181222144434379' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240986'
                WHERE ordernumber = 'P181222144557326' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339440'
                WHERE ordernumber = 'P201222144617361' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354218'
                WHERE ordernumber = 'P421222144900178' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354220'
                WHERE ordernumber = 'P181222145140925' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354222'
                WHERE ordernumber = 'P181222145247372' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346050'
                WHERE ordernumber = 'P201222145325900' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354225'
                WHERE ordernumber = 'P181222145454299' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335294'
                WHERE ordernumber = 'P201222145457136' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354227'
                WHERE ordernumber = 'P181222145707536' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354228'
                WHERE ordernumber = 'P181222150236776' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353161'
                WHERE ordernumber = 'P181222150342421' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280487'
                WHERE ordernumber = 'P181222150521623' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354231'
                WHERE ordernumber = 'P201222150945933' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343004'
                WHERE ordernumber = 'P201222151311562' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354232'
                WHERE ordernumber = 'P421222151525832' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261320'
                WHERE ordernumber = 'P421222151618225' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260853'
                WHERE ordernumber = 'P181222151728122' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112261'
                WHERE ordernumber = 'P201222152103509' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354235'
                WHERE ordernumber = 'P201222152421944' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354235'
                WHERE ordernumber = 'P201222152553963' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354236'
                WHERE ordernumber = 'P201222152652770' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '75984'
                WHERE ordernumber = 'P181222152712700' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354237'
                WHERE ordernumber = 'P201222152730498' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282336'
                WHERE ordernumber = 'P201222152804987' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '189793'
                WHERE ordernumber = 'P201222152923629' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354238'
                WHERE ordernumber = 'P181222152946443' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354239'
                WHERE ordernumber = 'P201222153211812' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354241'
                WHERE ordernumber = 'P201222153347793' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354242'
                WHERE ordernumber = 'P201222153727148' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354243'
                WHERE ordernumber = 'P191222153728807' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354242'
                WHERE ordernumber = 'P201222153926688' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323040'
                WHERE ordernumber = 'P421222154021657' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354245'
                WHERE ordernumber = 'P201222154122605' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272140'
                WHERE ordernumber = 'P181222154347276' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354248'
                WHERE ordernumber = 'P201222155405916' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286120'
                WHERE ordernumber = 'P191222155535274' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353721'
                WHERE ordernumber = 'P181222155537351' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241062'
                WHERE ordernumber = 'P181222155648408' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298067'
                WHERE ordernumber = 'P181222155744113' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348265'
                WHERE ordernumber = 'P421222155813653' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354251'
                WHERE ordernumber = 'P201222161131202' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252956'
                WHERE ordernumber = 'P201222161346273' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81124'
                WHERE ordernumber = 'P421222161526207' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110617'
                WHERE ordernumber = 'P201222162206251' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354252'
                WHERE ordernumber = 'P181222162253117' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354254'
                WHERE ordernumber = 'P181222162716412' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299523'
                WHERE ordernumber = 'P201222163256840' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354255'
                WHERE ordernumber = 'P191222163258986' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292163'
                WHERE ordernumber = 'P191222163411709' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354256'
                WHERE ordernumber = 'P181222163445138' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P191222163501785' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354257'
                WHERE ordernumber = 'P191222163643196' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315224'
                WHERE ordernumber = 'P181222163648975' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354258'
                WHERE ordernumber = 'P191222163757703' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354100'
                WHERE ordernumber = 'P181222163847878' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354100'
                WHERE ordernumber = 'P181222163917210' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260853'
                WHERE ordernumber = 'P191222163954641' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354260'
                WHERE ordernumber = 'P191222164245605' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354266'
                WHERE ordernumber = 'P181222165611980' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208616'
                WHERE ordernumber = 'P181222165738525' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349093'
                WHERE ordernumber = 'P201222165744249' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215833'
                WHERE ordernumber = 'P181222165937622' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354267'
                WHERE ordernumber = 'P181222170136752' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271611'
                WHERE ordernumber = 'P181222170422421' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283250'
                WHERE ordernumber = 'P181222170719659' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354268'
                WHERE ordernumber = 'P181222170829447' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354269'
                WHERE ordernumber = 'P181222170959282' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318181'
                WHERE ordernumber = 'P181222171052353' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354270'
                WHERE ordernumber = 'P181222171146955' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208597'
                WHERE ordernumber = 'P181222171227692' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354271'
                WHERE ordernumber = 'P181222171322240' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159613'
                WHERE ordernumber = 'P181222171358450' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354273'
                WHERE ordernumber = 'P181222171611409' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240201'
                WHERE ordernumber = 'P201222171623259' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208509'
                WHERE ordernumber = 'P191222172330336' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354275'
                WHERE ordernumber = 'P191222172649800' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P181222172707543' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315096'
                WHERE ordernumber = 'P201222172844939' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354277'
                WHERE ordernumber = 'P201222173243381' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354279'
                WHERE ordernumber = 'P181222173746131' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354280'
                WHERE ordernumber = 'P421222174133219' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252221'
                WHERE ordernumber = 'P201222174205592' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354284'
                WHERE ordernumber = 'P201222174947902' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354285'
                WHERE ordernumber = 'P201222175049128' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98313'
                WHERE ordernumber = 'P201222175220205' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345622'
                WHERE ordernumber = 'P421222175335302' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353638'
                WHERE ordernumber = 'P201222175431897' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350459'
                WHERE ordernumber = 'P191222175802674' 
            
2023-12-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354286'
                WHERE ordernumber = 'P181222180328925' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354286'
                WHERE ordernumber = 'P181222180456551' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302808'
                WHERE ordernumber = 'P181222180642635' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295025'
                WHERE ordernumber = 'P201222180752469' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277785'
                WHERE ordernumber = 'P181222181525434' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354289'
                WHERE ordernumber = 'P201222181959746' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354291'
                WHERE ordernumber = 'P201222182256606' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338789'
                WHERE ordernumber = 'P201222182524678' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354292'
                WHERE ordernumber = 'P191222183035716' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354293'
                WHERE ordernumber = 'P191222183201660' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354294'
                WHERE ordernumber = 'P201222183630252' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331629'
                WHERE ordernumber = 'P191222183830117' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344470'
                WHERE ordernumber = 'P191222183943462' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103860'
                WHERE ordernumber = 'P191222184747124' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354297'
                WHERE ordernumber = 'P191222184930420' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354298'
                WHERE ordernumber = 'P191222185127520' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351695'
                WHERE ordernumber = 'P191222185302956' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354299'
                WHERE ordernumber = 'P191222185358985' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272252'
                WHERE ordernumber = 'P191222185441920' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348962'
                WHERE ordernumber = 'P191222185906563' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354300'
                WHERE ordernumber = 'P421222190252371' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '126883'
                WHERE ordernumber = 'P201222191056829' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254122'
                WHERE ordernumber = 'P191222191253692' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242892'
                WHERE ordernumber = 'P191222192243950' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354303'
                WHERE ordernumber = 'P421222192441565' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270820'
                WHERE ordernumber = 'P201222192602209' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339803'
                WHERE ordernumber = 'P191222193109989' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354306'
                WHERE ordernumber = 'P421222193214366' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337142'
                WHERE ordernumber = 'P201222194203347' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354309'
                WHERE ordernumber = 'P191222194341406' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354311'
                WHERE ordernumber = 'P421222194551973' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354310'
                WHERE ordernumber = 'P191222194556805' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114924'
                WHERE ordernumber = 'P201222194849286' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354313'
                WHERE ordernumber = 'P421222194919797' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302578'
                WHERE ordernumber = 'P421222195126820' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354314'
                WHERE ordernumber = 'P201222195812265' 
            
2023-12-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314992'
                WHERE ordernumber = 'P421222200746962'