2024-10-26 01:00:02 -- 將會員中心id寫入data-lake
2024-10-26 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-10-25%';
        
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235882'
                WHERE ordernumber = 'P631025110053922' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206912'
                WHERE ordernumber = 'P181025110219262' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287636'
                WHERE ordernumber = 'P201025110338977' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284315'
                WHERE ordernumber = 'P201025110801706' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427471'
                WHERE ordernumber = 'P201025111224178' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425874'
                WHERE ordernumber = 'P181025111829706' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427473'
                WHERE ordernumber = 'P181025112345710' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427472'
                WHERE ordernumber = 'P201025112412176' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '202806'
                WHERE ordernumber = 'P181025113335776' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427474'
                WHERE ordernumber = 'P421025113343292' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105788'
                WHERE ordernumber = 'P201025113818298' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354202'
                WHERE ordernumber = 'P201025114345445' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427197'
                WHERE ordernumber = 'P731025114637987' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300227'
                WHERE ordernumber = 'P181025114649762' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427478'
                WHERE ordernumber = 'P181025115236128' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427478'
                WHERE ordernumber = 'P181025115301373' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407012'
                WHERE ordernumber = 'P181025120431875' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427481'
                WHERE ordernumber = 'P181025120908630' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381601'
                WHERE ordernumber = 'P421025121339557' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427482'
                WHERE ordernumber = 'P711025121503492' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427484'
                WHERE ordernumber = 'P181025121617684' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101715'
                WHERE ordernumber = 'P201025121712997' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302977'
                WHERE ordernumber = 'P591025122018903' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427465'
                WHERE ordernumber = 'P181025122130780' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81134'
                WHERE ordernumber = 'P181025122314544' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426115'
                WHERE ordernumber = 'P181025122453333' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352140'
                WHERE ordernumber = 'P421025122719473' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360790'
                WHERE ordernumber = 'P181025122740427' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113784'
                WHERE ordernumber = 'P191025122758390' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427486'
                WHERE ordernumber = 'P731025122826174' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427483'
                WHERE ordernumber = 'P421025122910696' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427487'
                WHERE ordernumber = 'P181025122936569' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289592'
                WHERE ordernumber = 'P731025123204240' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426518'
                WHERE ordernumber = 'P711025123443739' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427488'
                WHERE ordernumber = 'P731025123648916' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427489'
                WHERE ordernumber = 'P201025123723319' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427491'
                WHERE ordernumber = 'P181025124252371' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427492'
                WHERE ordernumber = 'P181025125147392' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99144'
                WHERE ordernumber = 'P201025125223559' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427493'
                WHERE ordernumber = 'P711025125346789' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384882'
                WHERE ordernumber = 'P181025125736767' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353527'
                WHERE ordernumber = 'P201025125842863' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426259'
                WHERE ordernumber = 'P181025130148877' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427494'
                WHERE ordernumber = 'P711025130157639' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426418'
                WHERE ordernumber = 'P201025130243534' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415389'
                WHERE ordernumber = 'P181025130544999' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427497'
                WHERE ordernumber = 'P181025130646408' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324778'
                WHERE ordernumber = 'P421025130702701' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '46166'
                WHERE ordernumber = 'P181025130849759' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427498'
                WHERE ordernumber = 'P181025131104221' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427500'
                WHERE ordernumber = 'P181025131253115' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427499'
                WHERE ordernumber = 'P731025131332134' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201025131411248' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427501'
                WHERE ordernumber = 'P201025131536639' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427502'
                WHERE ordernumber = 'P731025131700686' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427503'
                WHERE ordernumber = 'P731025133244663' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427505'
                WHERE ordernumber = 'P771025133749745' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406903'
                WHERE ordernumber = 'P201025134443706' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251277'
                WHERE ordernumber = 'P181025134803780' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427507'
                WHERE ordernumber = 'P421025134831315' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426279'
                WHERE ordernumber = 'P201025135006452' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116319'
                WHERE ordernumber = 'P181025135224795' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427511'
                WHERE ordernumber = 'P181025135930750' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423802'
                WHERE ordernumber = 'P201025140003292' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427508'
                WHERE ordernumber = 'P181025140033871' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343661'
                WHERE ordernumber = 'P181025140219246' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427513'
                WHERE ordernumber = 'P421025140431683' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216410'
                WHERE ordernumber = 'P201025140538485' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427516'
                WHERE ordernumber = 'P201025141108580' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312031'
                WHERE ordernumber = 'P421025141214284' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427515'
                WHERE ordernumber = 'P631025141229242' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312031'
                WHERE ordernumber = 'P421025141357222' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P421025141840529' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427517'
                WHERE ordernumber = 'P731025141935295' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142945'
                WHERE ordernumber = 'P731025142227734' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219462'
                WHERE ordernumber = 'P201025142302880' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P181025142308997' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274265'
                WHERE ordernumber = 'P201025142553542' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427519'
                WHERE ordernumber = 'P181025142923368' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339198'
                WHERE ordernumber = 'P421025143525577' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427520'
                WHERE ordernumber = 'P201025143536628' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339198'
                WHERE ordernumber = 'P421025143607147' 
            
2024-10-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245131'
                WHERE ordernumber = 'P181025143808518' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93638'
                WHERE ordernumber = 'P631025144141513' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244286'
                WHERE ordernumber = 'P201025144156290' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427521'
                WHERE ordernumber = 'P711025144543488' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416341'
                WHERE ordernumber = 'P421025144809858' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426436'
                WHERE ordernumber = 'P421025145133353' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427523'
                WHERE ordernumber = 'P181025145315928' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427523'
                WHERE ordernumber = 'P181025145343988' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427525'
                WHERE ordernumber = 'P421025145440630' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427522'
                WHERE ordernumber = 'P181025145503286' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427527'
                WHERE ordernumber = 'P731025145940386' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427526'
                WHERE ordernumber = 'P421025150027804' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217197'
                WHERE ordernumber = 'P191025150127299' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114314'
                WHERE ordernumber = 'P181025150311420' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427528'
                WHERE ordernumber = 'P181025150355952' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374290'
                WHERE ordernumber = 'P421025150652457' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171345'
                WHERE ordernumber = 'P771025151120534' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '16470'
                WHERE ordernumber = 'P731025151404327' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425337'
                WHERE ordernumber = 'P421025151536675' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427531'
                WHERE ordernumber = 'P191025152158524' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427530'
                WHERE ordernumber = 'P771025152320238' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427529'
                WHERE ordernumber = 'P191025152734271' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322955'
                WHERE ordernumber = 'P181025153213361' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427533'
                WHERE ordernumber = 'P421025154103336' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427534'
                WHERE ordernumber = 'P421025154151793' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '75928'
                WHERE ordernumber = 'P201025154433832' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427536'
                WHERE ordernumber = 'P591025154633887' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426132'
                WHERE ordernumber = 'P201025154727841' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P631025154820762' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P181025154824748' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427537'
                WHERE ordernumber = 'P201025155044990' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427538'
                WHERE ordernumber = 'P731025155856661' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105829'
                WHERE ordernumber = 'P181025160401163' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400648'
                WHERE ordernumber = 'P421025160521677' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427543'
                WHERE ordernumber = 'P181025160948864' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427541'
                WHERE ordernumber = 'P421025161024227' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423093'
                WHERE ordernumber = 'P191025161248206' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427545'
                WHERE ordernumber = 'P181025161347990' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427504'
                WHERE ordernumber = 'P181025161704257' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282511'
                WHERE ordernumber = 'P181025161739596' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427546'
                WHERE ordernumber = 'P711025162017257' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291688'
                WHERE ordernumber = 'P771025162151836' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427539'
                WHERE ordernumber = 'P181025162157775' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256439'
                WHERE ordernumber = 'P181025162339876' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304694'
                WHERE ordernumber = 'P421025162351126' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427547'
                WHERE ordernumber = 'P181025162514463' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427544'
                WHERE ordernumber = 'P181025162615868' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241095'
                WHERE ordernumber = 'P181025163029486' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337679'
                WHERE ordernumber = 'P711025163128718' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382512'
                WHERE ordernumber = 'P201025163154501' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318917'
                WHERE ordernumber = 'P181025163410863' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427548'
                WHERE ordernumber = 'P181025163748745' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427550'
                WHERE ordernumber = 'P181025163930255' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427551'
                WHERE ordernumber = 'P181025164258299' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427552'
                WHERE ordernumber = 'P421025164611720' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345519'
                WHERE ordernumber = 'P181025164643756' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297409'
                WHERE ordernumber = 'P421025165242901' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427555'
                WHERE ordernumber = 'P201025165806599' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427554'
                WHERE ordernumber = 'P771025165855739' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100949'
                WHERE ordernumber = 'P181025170121209' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269289'
                WHERE ordernumber = 'P771025170626894' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129975'
                WHERE ordernumber = 'P181025171606878' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137176'
                WHERE ordernumber = 'P631025172119583' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102422'
                WHERE ordernumber = 'P201025172149186' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396070'
                WHERE ordernumber = 'P181025172212673' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427560'
                WHERE ordernumber = 'P201025172717420' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314304'
                WHERE ordernumber = 'P421025172828918' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427561'
                WHERE ordernumber = 'P201025173333166' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427562'
                WHERE ordernumber = 'P421025173607877' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427071'
                WHERE ordernumber = 'P201025173626536' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352947'
                WHERE ordernumber = 'P731025173654441' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137433'
                WHERE ordernumber = 'P201025173908346' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427564'
                WHERE ordernumber = 'P201025174000137' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322291'
                WHERE ordernumber = 'P201025174541976' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427563'
                WHERE ordernumber = 'P421025174657655' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128554'
                WHERE ordernumber = 'P201025174714698' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427565'
                WHERE ordernumber = 'P731025174744517' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426068'
                WHERE ordernumber = 'P771025174820966' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427566'
                WHERE ordernumber = 'P201025175101854' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237840'
                WHERE ordernumber = 'P421025175632176' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420658'
                WHERE ordernumber = 'P421025180013192' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427567'
                WHERE ordernumber = 'P731025180102125' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427569'
                WHERE ordernumber = 'P181025180326417' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427568'
                WHERE ordernumber = 'P771025180515414' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407057'
                WHERE ordernumber = 'P201025180541420' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427558'
                WHERE ordernumber = 'P421025180825429' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372783'
                WHERE ordernumber = 'P421025181206710' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427570'
                WHERE ordernumber = 'P181025181939420' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P191025181959996' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427570'
                WHERE ordernumber = 'P181025182055147' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295879'
                WHERE ordernumber = 'P771025182117534' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307707'
                WHERE ordernumber = 'P181025182251786' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427571'
                WHERE ordernumber = 'P181025182512452' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240890'
                WHERE ordernumber = 'P181025183146781' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415427'
                WHERE ordernumber = 'P201025183213485' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427572'
                WHERE ordernumber = 'P181025183336272' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427573'
                WHERE ordernumber = 'P181025183454828' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426977'
                WHERE ordernumber = 'P181025183726562' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391532'
                WHERE ordernumber = 'P201025183748804' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313782'
                WHERE ordernumber = 'P181025183858563' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248311'
                WHERE ordernumber = 'P201025183908252' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373360'
                WHERE ordernumber = 'P421025184314681' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427574'
                WHERE ordernumber = 'P181025184412381' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272470'
                WHERE ordernumber = 'P201025184510179' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374433'
                WHERE ordernumber = 'P421025184510645' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406617'
                WHERE ordernumber = 'P421025184827439' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427576'
                WHERE ordernumber = 'P191025185110283' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427575'
                WHERE ordernumber = 'P191025185409984' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427577'
                WHERE ordernumber = 'P201025185538252' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427575'
                WHERE ordernumber = 'P191025185540450' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338700'
                WHERE ordernumber = 'P421025185910934' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163882'
                WHERE ordernumber = 'P201025190805698' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427578'
                WHERE ordernumber = 'P191025190814892' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131412'
                WHERE ordernumber = 'P711025190826350' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427485'
                WHERE ordernumber = 'P771025191041144' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427579'
                WHERE ordernumber = 'P771025191141810' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427580'
                WHERE ordernumber = 'P771025191435619' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168048'
                WHERE ordernumber = 'P201025191615642' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427575'
                WHERE ordernumber = 'P191025191947599' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427581'
                WHERE ordernumber = 'P201025192742943' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406081'
                WHERE ordernumber = 'P191025192819659' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427582'
                WHERE ordernumber = 'P201025193400874' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427583'
                WHERE ordernumber = 'P201025194052587' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427586'
                WHERE ordernumber = 'P771025195321416' 
            
2024-10-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427587'
                WHERE ordernumber = 'P771025201627967' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427588'
                WHERE ordernumber = 'P771025201745258' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347114'
                WHERE ordernumber = 'P631025201838994' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427589'
                WHERE ordernumber = 'P771025202030202' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '56326'
                WHERE ordernumber = 'P771025202958455' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427590'
                WHERE ordernumber = 'P771025203132352' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '56326'
                WHERE ordernumber = 'P771025203258331' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427592'
                WHERE ordernumber = 'P771025203455750' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427591'
                WHERE ordernumber = 'P771025203705707' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427593'
                WHERE ordernumber = 'P771025203925756' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427596'
                WHERE ordernumber = 'P771025204126126' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427594'
                WHERE ordernumber = 'P771025204244939' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427597'
                WHERE ordernumber = 'P771025204440442' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427599'
                WHERE ordernumber = 'P771025211243454' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123695'
                WHERE ordernumber = 'P771025211414253' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427600'
                WHERE ordernumber = 'P771025212030825' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427601'
                WHERE ordernumber = 'P771025212816734' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296414'
                WHERE ordernumber = 'P771025213009567' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427603'
                WHERE ordernumber = 'P771025213718412' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427604'
                WHERE ordernumber = 'P771025213950313' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427605'
                WHERE ordernumber = 'P771025214212153' 
            
2024-10-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427606'
                WHERE ordernumber = 'P771025214707631'