2024-07-07 01:00:03 -- 將會員中心id寫入data-lake
2024-07-07 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 '2024-07-06%';
        
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P200706110158515' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254478'
                WHERE ordernumber = 'P180706110225342' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307092'
                WHERE ordernumber = 'P200706110239570' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229003'
                WHERE ordernumber = 'P200706110430630' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399965'
                WHERE ordernumber = 'P180706110624920' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347921'
                WHERE ordernumber = 'P180706110905203' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399969'
                WHERE ordernumber = 'P190706110931226' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66735'
                WHERE ordernumber = 'P180706111117234' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271320'
                WHERE ordernumber = 'P190706111119767' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396249'
                WHERE ordernumber = 'P180706111425645' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104744'
                WHERE ordernumber = 'P200706111426417' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324229'
                WHERE ordernumber = 'P190706111520383' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217347'
                WHERE ordernumber = 'P200706111614213' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84778'
                WHERE ordernumber = 'P180706111843679' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399970'
                WHERE ordernumber = 'P180706111958631' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399971'
                WHERE ordernumber = 'P200706112605462' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390856'
                WHERE ordernumber = 'P420706112724999' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305238'
                WHERE ordernumber = 'P200706112842861' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236474'
                WHERE ordernumber = 'P180706112959239' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399972'
                WHERE ordernumber = 'P200706113127322' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399485'
                WHERE ordernumber = 'P180706113506751' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399973'
                WHERE ordernumber = 'P180706113715712' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399974'
                WHERE ordernumber = 'P420706113723803' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399975'
                WHERE ordernumber = 'P200706113911306' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394499'
                WHERE ordernumber = 'P180706114123509' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146526'
                WHERE ordernumber = 'P190706114201835' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282521'
                WHERE ordernumber = 'P180706114241841' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399976'
                WHERE ordernumber = 'P420706115028311' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399977'
                WHERE ordernumber = 'P200706115429545' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399978'
                WHERE ordernumber = 'P180706115558221' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376279'
                WHERE ordernumber = 'P180706115728512' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399979'
                WHERE ordernumber = 'P420706120207567' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388069'
                WHERE ordernumber = 'P200706120344193' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399980'
                WHERE ordernumber = 'P190706120539603' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399981'
                WHERE ordernumber = 'P420706120630316' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P190706120738175' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386737'
                WHERE ordernumber = 'P420706120926855' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399983'
                WHERE ordernumber = 'P190706121109538' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278843'
                WHERE ordernumber = 'P420706121251951' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399985'
                WHERE ordernumber = 'P180706121319970' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399986'
                WHERE ordernumber = 'P180706121443430' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399987'
                WHERE ordernumber = 'P590706121541326' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162735'
                WHERE ordernumber = 'P180706121827871' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399988'
                WHERE ordernumber = 'P180706121953986' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264305'
                WHERE ordernumber = 'P420706122015329' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398849'
                WHERE ordernumber = 'P180706122055548' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399989'
                WHERE ordernumber = 'P180706122247637' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159463'
                WHERE ordernumber = 'P180706122411989' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285114'
                WHERE ordernumber = 'P200706122612358' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399992'
                WHERE ordernumber = 'P180706123023928' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264113'
                WHERE ordernumber = 'P200706123807933' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399993'
                WHERE ordernumber = 'P180706124409884' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399994'
                WHERE ordernumber = 'P180706124606665' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317443'
                WHERE ordernumber = 'P420706124731944' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399995'
                WHERE ordernumber = 'P630706125032852' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98989'
                WHERE ordernumber = 'P200706125358674' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399996'
                WHERE ordernumber = 'P190706125611720' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399996'
                WHERE ordernumber = 'P190706125721818' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317443'
                WHERE ordernumber = 'P420706125917857' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129083'
                WHERE ordernumber = 'P180706130219383' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352813'
                WHERE ordernumber = 'P180706130542962' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399997'
                WHERE ordernumber = 'P420706130747239' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398584'
                WHERE ordernumber = 'P190706130925426' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391996'
                WHERE ordernumber = 'P200706131202487' 
            
2024-07-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399998'
                WHERE ordernumber = 'P190706131336401' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399999'
                WHERE ordernumber = 'P420706131459599' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399999'
                WHERE ordernumber = 'P420706131608159' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399999'
                WHERE ordernumber = 'P420706131751289' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111574'
                WHERE ordernumber = 'P180706131849437' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400001'
                WHERE ordernumber = 'P200706131946228' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399999'
                WHERE ordernumber = 'P420706132051945' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267164'
                WHERE ordernumber = 'P180706132442356' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400002'
                WHERE ordernumber = 'P420706132457450' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377530'
                WHERE ordernumber = 'P180706132707530' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400003'
                WHERE ordernumber = 'P180706132841834' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400004'
                WHERE ordernumber = 'P630706132943374' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400005'
                WHERE ordernumber = 'P180706133308163' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400006'
                WHERE ordernumber = 'P180706133500702' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400008'
                WHERE ordernumber = 'P180706133833842' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103316'
                WHERE ordernumber = 'P180706134313445' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400009'
                WHERE ordernumber = 'P200706134425127' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400010'
                WHERE ordernumber = 'P200706134740574' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400007'
                WHERE ordernumber = 'P180706134848888' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395193'
                WHERE ordernumber = 'P200706134904330' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400011'
                WHERE ordernumber = 'P180706135031374' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400012'
                WHERE ordernumber = 'P200706135152691' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382182'
                WHERE ordernumber = 'P420706135306552' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396154'
                WHERE ordernumber = 'P200706135416316' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400013'
                WHERE ordernumber = 'P180706135529499' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131785'
                WHERE ordernumber = 'P190706135705239' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227154'
                WHERE ordernumber = 'P190706140009760' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298268'
                WHERE ordernumber = 'P180706140131486' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399904'
                WHERE ordernumber = 'P630706140156203' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400014'
                WHERE ordernumber = 'P200706140339205' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400014'
                WHERE ordernumber = 'P200706140415141' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400015'
                WHERE ordernumber = 'P200706140605715' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285693'
                WHERE ordernumber = 'P190706141159668' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298155'
                WHERE ordernumber = 'P420706141232206' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235882'
                WHERE ordernumber = 'P420706141413950' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400017'
                WHERE ordernumber = 'P190706141815510' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '327536'
                WHERE ordernumber = 'P420706142131155' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400019'
                WHERE ordernumber = 'P420706142501815' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400018'
                WHERE ordernumber = 'P180706142827115' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400020'
                WHERE ordernumber = 'P200706142921850' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400022'
                WHERE ordernumber = 'P180706143230392' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400021'
                WHERE ordernumber = 'P630706143236982' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97793'
                WHERE ordernumber = 'P190706143704575' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267164'
                WHERE ordernumber = 'P190706143817768' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400023'
                WHERE ordernumber = 'P180706143909876' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '37842'
                WHERE ordernumber = 'P180706144000744' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400025'
                WHERE ordernumber = 'P190706144256182' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381805'
                WHERE ordernumber = 'P180706144304272' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400025'
                WHERE ordernumber = 'P190706144334398' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280049'
                WHERE ordernumber = 'P200706144621625' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328007'
                WHERE ordernumber = 'P200706144940886' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400026'
                WHERE ordernumber = 'P180706145220737' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400027'
                WHERE ordernumber = 'P420706145430384' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400028'
                WHERE ordernumber = 'P180706145517922' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400029'
                WHERE ordernumber = 'P200706145701913' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288868'
                WHERE ordernumber = 'P180706150105246' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392195'
                WHERE ordernumber = 'P420706150254282' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400030'
                WHERE ordernumber = 'P180706150407993' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165317'
                WHERE ordernumber = 'P200706150456377' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313693'
                WHERE ordernumber = 'P180706150554227' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400032'
                WHERE ordernumber = 'P180706151113989' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100505'
                WHERE ordernumber = 'P200706151311175' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400033'
                WHERE ordernumber = 'P420706151333878' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256644'
                WHERE ordernumber = 'P200706151614753' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400034'
                WHERE ordernumber = 'P180706152003182' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372465'
                WHERE ordernumber = 'P200706152016966' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400035'
                WHERE ordernumber = 'P200706152254780' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400038'
                WHERE ordernumber = 'P200706152557835' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400037'
                WHERE ordernumber = 'P200706152718643' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400039'
                WHERE ordernumber = 'P180706153004750' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400040'
                WHERE ordernumber = 'P190706153216968' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400041'
                WHERE ordernumber = 'P190706153352925' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400043'
                WHERE ordernumber = 'P180706153411700' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P180706153524266' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400044'
                WHERE ordernumber = 'P190706153528586' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '126504'
                WHERE ordernumber = 'P180706153640353' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400045'
                WHERE ordernumber = 'P420706153742517' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400042'
                WHERE ordernumber = 'P420706153904579' 
            
2024-07-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161128'
                WHERE ordernumber = 'P590706154043923' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '161128'
                WHERE ordernumber = 'P590706154201197' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '306780'
                WHERE ordernumber = 'P180706154338243' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396528'
                WHERE ordernumber = 'P420706154433302' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '126504'
                WHERE ordernumber = 'P180706154526382' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '74761'
                WHERE ordernumber = 'P200706154607516' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400048'
                WHERE ordernumber = 'P200706154856686' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400049'
                WHERE ordernumber = 'P190706155054641' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400047'
                WHERE ordernumber = 'P420706155138985' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400050'
                WHERE ordernumber = 'P420706155254662' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400051'
                WHERE ordernumber = 'P190706155314431' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400050'
                WHERE ordernumber = 'P420706155503254' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400053'
                WHERE ordernumber = 'P190706155557874' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400052'
                WHERE ordernumber = 'P200706155639642' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400054'
                WHERE ordernumber = 'P180706155743711' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '394120'
                WHERE ordernumber = 'P200706155826963' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '395818'
                WHERE ordernumber = 'P180706160119285' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381589'
                WHERE ordernumber = 'P420706160138664' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400056'
                WHERE ordernumber = 'P420706160416986' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400057'
                WHERE ordernumber = 'P420706160525951' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400058'
                WHERE ordernumber = 'P420706160714277' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400059'
                WHERE ordernumber = 'P200706160753538' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '57765'
                WHERE ordernumber = 'P180706161625290' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '103320'
                WHERE ordernumber = 'P180706161912802' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400060'
                WHERE ordernumber = 'P180706162030521' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400061'
                WHERE ordernumber = 'P200706162230613' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400062'
                WHERE ordernumber = 'P420706162352715' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '210801'
                WHERE ordernumber = 'P180706162352742' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '362763'
                WHERE ordernumber = 'P420706162525543' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400063'
                WHERE ordernumber = 'P200706162631313' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '236671'
                WHERE ordernumber = 'P180706162735392' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400066'
                WHERE ordernumber = 'P190706162950461' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400065'
                WHERE ordernumber = 'P180706162952952' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '308789'
                WHERE ordernumber = 'P190706163142218' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400067'
                WHERE ordernumber = 'P420706163203656' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '287906'
                WHERE ordernumber = 'P180706163212482' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397556'
                WHERE ordernumber = 'P190706163256807' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '382920'
                WHERE ordernumber = 'P190706163405243' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400068'
                WHERE ordernumber = 'P180706163545242' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341456'
                WHERE ordernumber = 'P190706163558415' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400069'
                WHERE ordernumber = 'P180706163810162' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '244547'
                WHERE ordernumber = 'P200706163933569' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399255'
                WHERE ordernumber = 'P420706164116310' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346674'
                WHERE ordernumber = 'P590706164146616' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '314428'
                WHERE ordernumber = 'P200706164308685' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '315069'
                WHERE ordernumber = 'P180706164457442' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400070'
                WHERE ordernumber = 'P200706164504981' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400071'
                WHERE ordernumber = 'P180706170154359' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400072'
                WHERE ordernumber = 'P200706170313515' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '395285'
                WHERE ordernumber = 'P180706170542143' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400073'
                WHERE ordernumber = 'P180706170832586' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '342058'
                WHERE ordernumber = 'P200706171150295' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '389481'
                WHERE ordernumber = 'P200706171344921' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400074'
                WHERE ordernumber = 'P420706172119473' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400075'
                WHERE ordernumber = 'P420706172237516' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400076'
                WHERE ordernumber = 'P200706172349329' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400077'
                WHERE ordernumber = 'P180706172512593' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '38051'
                WHERE ordernumber = 'P420706172606147' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '303554'
                WHERE ordernumber = 'P180706172922886' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400078'
                WHERE ordernumber = 'P420706173130323' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400079'
                WHERE ordernumber = 'P420706173404485' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400080'
                WHERE ordernumber = 'P180706173419610' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400081'
                WHERE ordernumber = 'P190706173920190' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400082'
                WHERE ordernumber = 'P200706174039815' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400083'
                WHERE ordernumber = 'P180706174148686' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '264820'
                WHERE ordernumber = 'P420706174221463' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '222552'
                WHERE ordernumber = 'P180706174231176' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400084'
                WHERE ordernumber = 'P420706174617994' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '379950'
                WHERE ordernumber = 'P180706174632539' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '379470'
                WHERE ordernumber = 'P200706174939782' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400085'
                WHERE ordernumber = 'P420706175157841' 
            
2024-07-07 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400086'
                WHERE ordernumber = 'P420706175318203' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '307431'
                WHERE ordernumber = 'P180706175534193' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '217689'
                WHERE ordernumber = 'P190706180054954' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400088'
                WHERE ordernumber = 'P420706180058828' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400090'
                WHERE ordernumber = 'P200706180256426' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400089'
                WHERE ordernumber = 'P190706180358491' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400091'
                WHERE ordernumber = 'P420706180505991' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '300786'
                WHERE ordernumber = 'P420706180600168' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400092'
                WHERE ordernumber = 'P180706180722280' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400093'
                WHERE ordernumber = 'P200706181314656' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '330265'
                WHERE ordernumber = 'P630706181458617' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '307065'
                WHERE ordernumber = 'P180706181610339' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '244313'
                WHERE ordernumber = 'P180706182127236' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '300241'
                WHERE ordernumber = 'P180706182311843' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '345090'
                WHERE ordernumber = 'P200706182537385' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '343891'
                WHERE ordernumber = 'P420706182550136' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400095'
                WHERE ordernumber = 'P420706182708973' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400074'
                WHERE ordernumber = 'P420706182759282' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400096'
                WHERE ordernumber = 'P180706182941503' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399788'
                WHERE ordernumber = 'P420706182953203' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '282921'
                WHERE ordernumber = 'P180706183133307' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400097'
                WHERE ordernumber = 'P420706183203491' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399808'
                WHERE ordernumber = 'P180706183217397' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '298669'
                WHERE ordernumber = 'P200706183507693' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '281001'
                WHERE ordernumber = 'P200706183828245' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400098'
                WHERE ordernumber = 'P200706183925585' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400099'
                WHERE ordernumber = 'P190706184643727' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '363039'
                WHERE ordernumber = 'P190706185202866' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400100'
                WHERE ordernumber = 'P200706190107546' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400101'
                WHERE ordernumber = 'P190706190352696' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400102'
                WHERE ordernumber = 'P190706190530302' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '120896'
                WHERE ordernumber = 'P200706190600679' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400105'
                WHERE ordernumber = 'P190706192326167' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400106'
                WHERE ordernumber = 'P190706192538939' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400107'
                WHERE ordernumber = 'P200706192752598' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400108'
                WHERE ordernumber = 'P190706192808531' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '109545'
                WHERE ordernumber = 'P190706192929583' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '339612'
                WHERE ordernumber = 'P630706193951791' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '284889'
                WHERE ordernumber = 'P200706194606802' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '136646'
                WHERE ordernumber = 'P200706194713514' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400110'
                WHERE ordernumber = 'P190706194747902' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '158677'
                WHERE ordernumber = 'P200706194914533' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '378778'
                WHERE ordernumber = 'P200706195027459' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400111'
                WHERE ordernumber = 'P190706195503872' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400113'
                WHERE ordernumber = 'P200706200017682' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400114'
                WHERE ordernumber = 'P630706201509664' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400115'
                WHERE ordernumber = 'P630706203050623' 
            
2024-07-07 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '386431'
                WHERE ordernumber = 'P630706212107356'