2023-12-08 01:00:03 -- 將會員中心id寫入data-lake
2023-12-08 01:00:03 -- 
            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-07%';
        
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351122'
                WHERE ordernumber = 'P201207110136631' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280802'
                WHERE ordernumber = 'P421207110215527' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '72395'
                WHERE ordernumber = 'P191207110238647' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118593'
                WHERE ordernumber = 'P191207110341197' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351123'
                WHERE ordernumber = 'P191207110733940' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246491'
                WHERE ordernumber = 'P181207110909526' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158673'
                WHERE ordernumber = 'P191207110927264' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350229'
                WHERE ordernumber = 'P191207111321596' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351123'
                WHERE ordernumber = 'P191207111437490' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324193'
                WHERE ordernumber = 'P181207111438397' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244003'
                WHERE ordernumber = 'P191207111512872' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231068'
                WHERE ordernumber = 'P201207112331343' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351125'
                WHERE ordernumber = 'P191207112539458' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242291'
                WHERE ordernumber = 'P201207112558179' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351126'
                WHERE ordernumber = 'P181207112806527' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345035'
                WHERE ordernumber = 'P181207112852559' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118205'
                WHERE ordernumber = 'P201207112911151' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113772'
                WHERE ordernumber = 'P191207113622254' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313349'
                WHERE ordernumber = 'P191207114240267' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351130'
                WHERE ordernumber = 'P421207114422901' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136409'
                WHERE ordernumber = 'P201207114441594' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171932'
                WHERE ordernumber = 'P191207114745500' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343882'
                WHERE ordernumber = 'P191207114907203' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351131'
                WHERE ordernumber = 'P191207115059706' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114186'
                WHERE ordernumber = 'P201207115450506' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127884'
                WHERE ordernumber = 'P191207115508469' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127884'
                WHERE ordernumber = 'P191207115630807' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287122'
                WHERE ordernumber = 'P191207120006865' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351134'
                WHERE ordernumber = 'P201207120340811' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160799'
                WHERE ordernumber = 'P201207121015337' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347175'
                WHERE ordernumber = 'P181207121054891' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347837'
                WHERE ordernumber = 'P181207121239334' 
            
2023-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142108'
                WHERE ordernumber = 'P181207121405185' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351138'
                WHERE ordernumber = 'P181207121850268' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351139'
                WHERE ordernumber = 'P181207122056115' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351140'
                WHERE ordernumber = 'P191207122635331' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275207'
                WHERE ordernumber = 'P201207122955342' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351142'
                WHERE ordernumber = 'P181207123452952' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132946'
                WHERE ordernumber = 'P191207123820822' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351144'
                WHERE ordernumber = 'P201207124042981' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351145'
                WHERE ordernumber = 'P181207124051386' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231416'
                WHERE ordernumber = 'P201207124140417' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181207124223452' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95062'
                WHERE ordernumber = 'P181207124316635' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296795'
                WHERE ordernumber = 'P201207125340901' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312991'
                WHERE ordernumber = 'P421207125531928' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351147'
                WHERE ordernumber = 'P201207125609558' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351148'
                WHERE ordernumber = 'P191207125639915' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140210'
                WHERE ordernumber = 'P421207125641807' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351149'
                WHERE ordernumber = 'P201207125653981' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344719'
                WHERE ordernumber = 'P181207125920572' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351150'
                WHERE ordernumber = 'P421207130016376' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220124'
                WHERE ordernumber = 'P201207130415495' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298474'
                WHERE ordernumber = 'P421207130522791' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351152'
                WHERE ordernumber = 'P191207131052986' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267445'
                WHERE ordernumber = 'P191207131957787' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351153'
                WHERE ordernumber = 'P191207132156276' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351154'
                WHERE ordernumber = 'P201207132436581' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P191207133128359' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351155'
                WHERE ordernumber = 'P421207133303252' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288946'
                WHERE ordernumber = 'P201207133402740' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351156'
                WHERE ordernumber = 'P201207133808661' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328850'
                WHERE ordernumber = 'P421207133851603' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351157'
                WHERE ordernumber = 'P201207134615145' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244119'
                WHERE ordernumber = 'P201207135244619' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136409'
                WHERE ordernumber = 'P201207135519330' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226512'
                WHERE ordernumber = 'P201207140228873' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351158'
                WHERE ordernumber = 'P201207140757501' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351159'
                WHERE ordernumber = 'P421207141352114' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351160'
                WHERE ordernumber = 'P191207141733871' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351161'
                WHERE ordernumber = 'P201207142521922' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325279'
                WHERE ordernumber = 'P421207142812725' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288989'
                WHERE ordernumber = 'P201207143118121' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351162'
                WHERE ordernumber = 'P201207143327172' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224778'
                WHERE ordernumber = 'P191207143805430' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351164'
                WHERE ordernumber = 'P201207143912575' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208276'
                WHERE ordernumber = 'P191207144120695' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252699'
                WHERE ordernumber = 'P191207144420201' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167252'
                WHERE ordernumber = 'P191207144546476' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351166'
                WHERE ordernumber = 'P191207144701694' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351168'
                WHERE ordernumber = 'P201207144819166' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132149'
                WHERE ordernumber = 'P191207144842929' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351167'
                WHERE ordernumber = 'P421207144911946' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342193'
                WHERE ordernumber = 'P201207145029293' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351169'
                WHERE ordernumber = 'P201207145448921' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351170'
                WHERE ordernumber = 'P421207145513495' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114594'
                WHERE ordernumber = 'P191207145757775' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351171'
                WHERE ordernumber = 'P201207145914504' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216143'
                WHERE ordernumber = 'P191207150029585' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161113'
                WHERE ordernumber = 'P201207150104781' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P201207150338346' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351172'
                WHERE ordernumber = 'P201207150513701' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351174'
                WHERE ordernumber = 'P191207151034956' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351175'
                WHERE ordernumber = 'P191207151340536' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258453'
                WHERE ordernumber = 'P201207151411259' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81382'
                WHERE ordernumber = 'P201207152129835' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '14587'
                WHERE ordernumber = 'P201207152315206' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316376'
                WHERE ordernumber = 'P201207152536617' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316403'
                WHERE ordernumber = 'P201207152608170' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351177'
                WHERE ordernumber = 'P201207153016883' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '63318'
                WHERE ordernumber = 'P201207153333401' 
            
2023-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351178'
                WHERE ordernumber = 'P191207153709910' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349884'
                WHERE ordernumber = 'P421207153900905' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351180'
                WHERE ordernumber = 'P201207153947821' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351108'
                WHERE ordernumber = 'P201207154637683' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351182'
                WHERE ordernumber = 'P201207154844263' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351184'
                WHERE ordernumber = 'P181207155130771' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329313'
                WHERE ordernumber = 'P191207155418467' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329313'
                WHERE ordernumber = 'P191207155447361' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351187'
                WHERE ordernumber = 'P191207160210443' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166284'
                WHERE ordernumber = 'P181207160238356' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351190'
                WHERE ordernumber = 'P181207161100899' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103389'
                WHERE ordernumber = 'P191207162133967' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '140858'
                WHERE ordernumber = 'P181207162244731' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351191'
                WHERE ordernumber = 'P421207162306610' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102826'
                WHERE ordernumber = 'P191207162320411' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351192'
                WHERE ordernumber = 'P181207162916200' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351194'
                WHERE ordernumber = 'P181207163344586' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351195'
                WHERE ordernumber = 'P201207163404828' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351194'
                WHERE ordernumber = 'P181207163424247' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351194'
                WHERE ordernumber = 'P181207163455845' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P191207163533161' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209175'
                WHERE ordernumber = 'P181207164031377' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209175'
                WHERE ordernumber = 'P181207164106359' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351196'
                WHERE ordernumber = 'P201207164232741' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351197'
                WHERE ordernumber = 'P181207164254187' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351198'
                WHERE ordernumber = 'P201207164545802' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237295'
                WHERE ordernumber = 'P181207164736213' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251491'
                WHERE ordernumber = 'P181207165005944' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351200'
                WHERE ordernumber = 'P421207165307363' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270346'
                WHERE ordernumber = 'P201207165359845' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351201'
                WHERE ordernumber = 'P181207165450621' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351203'
                WHERE ordernumber = 'P181207165550272' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324238'
                WHERE ordernumber = 'P181207170411205' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351204'
                WHERE ordernumber = 'P201207170540282' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P201207170723172' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351206'
                WHERE ordernumber = 'P421207171339703' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '87785'
                WHERE ordernumber = 'P201207172247713' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247917'
                WHERE ordernumber = 'P201207172401778' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271724'
                WHERE ordernumber = 'P201207172929269' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351208'
                WHERE ordernumber = 'P421207173156990' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276579'
                WHERE ordernumber = 'P181207173306332' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351209'
                WHERE ordernumber = 'P421207173341634' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314528'
                WHERE ordernumber = 'P181207174212198' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343970'
                WHERE ordernumber = 'P181207174943197' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113879'
                WHERE ordernumber = 'P181207175043115' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351211'
                WHERE ordernumber = 'P181207175143843' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159463'
                WHERE ordernumber = 'P421207175428426' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351212'
                WHERE ordernumber = 'P181207175836474' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351214'
                WHERE ordernumber = 'P181207180146317' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351215'
                WHERE ordernumber = 'P191207180306469' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351214'
                WHERE ordernumber = 'P181207180352728' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351216'
                WHERE ordernumber = 'P201207180548748' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351219'
                WHERE ordernumber = 'P201207180647161' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351220'
                WHERE ordernumber = 'P201207180756319' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351222'
                WHERE ordernumber = 'P181207181049534' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351131'
                WHERE ordernumber = 'P181207181614948' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234392'
                WHERE ordernumber = 'P201207182355442' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350331'
                WHERE ordernumber = 'P201207182449461' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351224'
                WHERE ordernumber = 'P201207182720293' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351225'
                WHERE ordernumber = 'P201207182817529' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351226'
                WHERE ordernumber = 'P181207182824599' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350646'
                WHERE ordernumber = 'P181207183145520' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351227'
                WHERE ordernumber = 'P181207183533523' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '327970'
                WHERE ordernumber = 'P181207183719283' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348807'
                WHERE ordernumber = 'P201207183741129' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351229'
                WHERE ordernumber = 'P181207184211178' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351230'
                WHERE ordernumber = 'P201207184309644' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263411'
                WHERE ordernumber = 'P191207184423162' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351228'
                WHERE ordernumber = 'P181207184523733' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '260675'
                WHERE ordernumber = 'P201207184540398' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351231'
                WHERE ordernumber = 'P191207185104186' 
            
2023-12-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302050'
                WHERE ordernumber = 'P421207185117444' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351232'
                WHERE ordernumber = 'P191207185251403' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '299619'
                WHERE ordernumber = 'P421207185434231' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '229332'
                WHERE ordernumber = 'P201207185437338' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351233'
                WHERE ordernumber = 'P191207185531692' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '299619'
                WHERE ordernumber = 'P421207185622596' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351234'
                WHERE ordernumber = 'P191207185919242' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '104833'
                WHERE ordernumber = 'P191207190018755' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350506'
                WHERE ordernumber = 'P191207190135891' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351235'
                WHERE ordernumber = 'P421207190246879' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '308997'
                WHERE ordernumber = 'P201207190326666' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '124068'
                WHERE ordernumber = 'P191207190447787' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '236923'
                WHERE ordernumber = 'P191207190647602' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '261156'
                WHERE ordernumber = 'P191207191542987' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '313451'
                WHERE ordernumber = 'P421207192352351' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '276983'
                WHERE ordernumber = 'P201207192539735' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '286003'
                WHERE ordernumber = 'P201207193306507' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '229446'
                WHERE ordernumber = 'P201207193448922' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '212619'
                WHERE ordernumber = 'P191207193706987' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351240'
                WHERE ordernumber = 'P201207193936280' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351242'
                WHERE ordernumber = 'P201207194243392' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '162273'
                WHERE ordernumber = 'P201207194737242' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351244'
                WHERE ordernumber = 'P201207195324275' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351244'
                WHERE ordernumber = 'P201207195443405' 
            
2023-12-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351245'
                WHERE ordernumber = 'P201207200501332'