2024-07-08 01:00:03 -- 將會員中心id寫入data-lake
2024-07-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 '2024-07-07%';
        
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351075'
                WHERE ordernumber = 'P630707105909991' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400137'
                WHERE ordernumber = 'P180707110410716' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378836'
                WHERE ordernumber = 'P200707110625169' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291320'
                WHERE ordernumber = 'P180707110700630' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397626'
                WHERE ordernumber = 'P200707110911481' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142127'
                WHERE ordernumber = 'P180707111111279' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400138'
                WHERE ordernumber = 'P180707111316576' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288892'
                WHERE ordernumber = 'P200707111536458' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317574'
                WHERE ordernumber = 'P180707112004870' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317574'
                WHERE ordernumber = 'P190707112308744' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224051'
                WHERE ordernumber = 'P200707112309331' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400139'
                WHERE ordernumber = 'P180707112310244' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344885'
                WHERE ordernumber = 'P420707112455134' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400140'
                WHERE ordernumber = 'P200707112511572' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400141'
                WHERE ordernumber = 'P180707112554955' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115794'
                WHERE ordernumber = 'P190707112627729' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400142'
                WHERE ordernumber = 'P180707112732984' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400144'
                WHERE ordernumber = 'P180707113250684' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400143'
                WHERE ordernumber = 'P420707113354781' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383359'
                WHERE ordernumber = 'P420707113813744' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307340'
                WHERE ordernumber = 'P200707114142617' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400146'
                WHERE ordernumber = 'P190707114236629' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400147'
                WHERE ordernumber = 'P200707114308514' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244192'
                WHERE ordernumber = 'P180707114533135' 
            
2024-07-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133830'
                WHERE ordernumber = 'P180707114752436' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288486'
                WHERE ordernumber = 'P200707114755184' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400149'
                WHERE ordernumber = 'P180707115252843' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400147'
                WHERE ordernumber = 'P200707115348787' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273432'
                WHERE ordernumber = 'P200707115634187' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400150'
                WHERE ordernumber = 'P190707120001954' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267722'
                WHERE ordernumber = 'P200707120103435' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400151'
                WHERE ordernumber = 'P200707120426323' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400152'
                WHERE ordernumber = 'P180707120542812' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400153'
                WHERE ordernumber = 'P190707120750828' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81346'
                WHERE ordernumber = 'P200707120801315' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400154'
                WHERE ordernumber = 'P180707121423535' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '145854'
                WHERE ordernumber = 'P200707121602352' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400156'
                WHERE ordernumber = 'P200707121843526' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99007'
                WHERE ordernumber = 'P190707122613446' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400158'
                WHERE ordernumber = 'P190707123022248' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400159'
                WHERE ordernumber = 'P180707123227839' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400155'
                WHERE ordernumber = 'P200707123337443' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305458'
                WHERE ordernumber = 'P190707123411460' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400160'
                WHERE ordernumber = 'P420707123652434' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287777'
                WHERE ordernumber = 'P190707123738133' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400161'
                WHERE ordernumber = 'P180707124047852' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P190707124119684' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400162'
                WHERE ordernumber = 'P180707124209812' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400163'
                WHERE ordernumber = 'P190707124757293' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P190707125031481' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400164'
                WHERE ordernumber = 'P200707125319682' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400165'
                WHERE ordernumber = 'P180707125757265' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337116'
                WHERE ordernumber = 'P200707131052309' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264848'
                WHERE ordernumber = 'P180707131120712' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345197'
                WHERE ordernumber = 'P180707131320513' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281682'
                WHERE ordernumber = 'P180707131456607' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241316'
                WHERE ordernumber = 'P200707131551608' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '65626'
                WHERE ordernumber = 'P180707131750115' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299286'
                WHERE ordernumber = 'P630707132551353' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388152'
                WHERE ordernumber = 'P180707132850634' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P200707133034371' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398584'
                WHERE ordernumber = 'P180707133135383' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397418'
                WHERE ordernumber = 'P630707133250119' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400167'
                WHERE ordernumber = 'P180707133356653' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400168'
                WHERE ordernumber = 'P630707133446682' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124377'
                WHERE ordernumber = 'P180707133557432' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99659'
                WHERE ordernumber = 'P180707134549846' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400170'
                WHERE ordernumber = 'P420707134954531' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400172'
                WHERE ordernumber = 'P200707135147379' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400173'
                WHERE ordernumber = 'P180707135724555' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400175'
                WHERE ordernumber = 'P180707135922347' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384966'
                WHERE ordernumber = 'P590707135924150' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400176'
                WHERE ordernumber = 'P200707135940391' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400177'
                WHERE ordernumber = 'P420707140431521' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P180707140832720' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290206'
                WHERE ordernumber = 'P200707141508719' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400181'
                WHERE ordernumber = 'P180707141610300' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400182'
                WHERE ordernumber = 'P630707141656558' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400180'
                WHERE ordernumber = 'P180707141704658' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400183'
                WHERE ordernumber = 'P630707141908334' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112395'
                WHERE ordernumber = 'P200707141942411' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400184'
                WHERE ordernumber = 'P630707141957245' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400185'
                WHERE ordernumber = 'P420707142841137' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400186'
                WHERE ordernumber = 'P180707143042890' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400187'
                WHERE ordernumber = 'P180707143159624' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400188'
                WHERE ordernumber = 'P420707143538588' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400189'
                WHERE ordernumber = 'P180707143559737' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378584'
                WHERE ordernumber = 'P630707143758445' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400190'
                WHERE ordernumber = 'P180707143817503' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400191'
                WHERE ordernumber = 'P200707143843288' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400192'
                WHERE ordernumber = 'P630707144122792' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400194'
                WHERE ordernumber = 'P180707144329612' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400193'
                WHERE ordernumber = 'P630707144331281' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400195'
                WHERE ordernumber = 'P630707144604499' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369186'
                WHERE ordernumber = 'P420707144716913' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336777'
                WHERE ordernumber = 'P200707144731951' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400196'
                WHERE ordernumber = 'P190707144809941' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400197'
                WHERE ordernumber = 'P200707145053315' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400198'
                WHERE ordernumber = 'P180707145227510' 
            
2024-07-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400199'
                WHERE ordernumber = 'P200707145400819' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380529'
                WHERE ordernumber = 'P180707145558912' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239593'
                WHERE ordernumber = 'P190707145559495' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242590'
                WHERE ordernumber = 'P200707145616677' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395824'
                WHERE ordernumber = 'P420707145657733' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105615'
                WHERE ordernumber = 'P190707145732402' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400200'
                WHERE ordernumber = 'P180707145903708' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397378'
                WHERE ordernumber = 'P630707150043194' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220776'
                WHERE ordernumber = 'P180707150233151' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400202'
                WHERE ordernumber = 'P200707150449849' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399509'
                WHERE ordernumber = 'P190707150617652' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400203'
                WHERE ordernumber = 'P420707150735202' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180707151236976' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287880'
                WHERE ordernumber = 'P180707151355877' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400206'
                WHERE ordernumber = 'P190707151554528' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400207'
                WHERE ordernumber = 'P180707151630592' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '3159'
                WHERE ordernumber = 'P180707152256457' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358014'
                WHERE ordernumber = 'P200707152511450' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '3159'
                WHERE ordernumber = 'P180707152516862' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400208'
                WHERE ordernumber = 'P200707152815151' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400210'
                WHERE ordernumber = 'P420707153039532' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400211'
                WHERE ordernumber = 'P180707153653624' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '51896'
                WHERE ordernumber = 'P200707153712339' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400212'
                WHERE ordernumber = 'P200707153922623' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399329'
                WHERE ordernumber = 'P190707154105494' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235014'
                WHERE ordernumber = 'P200707154116877' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283028'
                WHERE ordernumber = 'P420707154134416' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399329'
                WHERE ordernumber = 'P190707154154910' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400213'
                WHERE ordernumber = 'P200707154230157' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319774'
                WHERE ordernumber = 'P200707154506253' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386856'
                WHERE ordernumber = 'P180707154555168' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400214'
                WHERE ordernumber = 'P200707154703426' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298208'
                WHERE ordernumber = 'P200707154816555' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400215'
                WHERE ordernumber = 'P200707155149436' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400216'
                WHERE ordernumber = 'P180707155304505' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400217'
                WHERE ordernumber = 'P180707155538627' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400218'
                WHERE ordernumber = 'P180707155842343' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400220'
                WHERE ordernumber = 'P190707160042754' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400221'
                WHERE ordernumber = 'P420707160535433' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400222'
                WHERE ordernumber = 'P180707160747357' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400224'
                WHERE ordernumber = 'P420707161120540' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397989'
                WHERE ordernumber = 'P190707161324766' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400223'
                WHERE ordernumber = 'P420707161347929' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337262'
                WHERE ordernumber = 'P420707161640999' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '63455'
                WHERE ordernumber = 'P420707161847266' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400227'
                WHERE ordernumber = 'P420707162113133' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276877'
                WHERE ordernumber = 'P200707162305136' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400228'
                WHERE ordernumber = 'P630707162319789' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400229'
                WHERE ordernumber = 'P630707162416332' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394434'
                WHERE ordernumber = 'P190707162728480' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400230'
                WHERE ordernumber = 'P630707162747516' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400231'
                WHERE ordernumber = 'P420707162841418' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217347'
                WHERE ordernumber = 'P200707162906285' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392015'
                WHERE ordernumber = 'P180707163312188' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400132'
                WHERE ordernumber = 'P200707163321635' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400233'
                WHERE ordernumber = 'P180707163758122' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400234'
                WHERE ordernumber = 'P200707163953784' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400046'
                WHERE ordernumber = 'P180707164329454' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400235'
                WHERE ordernumber = 'P180707164433869' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400236'
                WHERE ordernumber = 'P180707164629257' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400235'
                WHERE ordernumber = 'P180707164736897' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391931'
                WHERE ordernumber = 'P420707164838835' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400238'
                WHERE ordernumber = 'P420707165320839' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382734'
                WHERE ordernumber = 'P180707165451556' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279239'
                WHERE ordernumber = 'P200707165505480' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173794'
                WHERE ordernumber = 'P180707165721802' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397765'
                WHERE ordernumber = 'P590707165959568' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400239'
                WHERE ordernumber = 'P200707170109601' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '124984'
                WHERE ordernumber = 'P190707170145406' 
            
2024-07-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400240'
                WHERE ordernumber = 'P420707170226713' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400241'
                WHERE ordernumber = 'P420707170658298' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396633'
                WHERE ordernumber = 'P180707170922276' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400242'
                WHERE ordernumber = 'P420707171140481' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400243'
                WHERE ordernumber = 'P420707171227542' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400244'
                WHERE ordernumber = 'P630707171427374' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '255608'
                WHERE ordernumber = 'P420707171645117' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400136'
                WHERE ordernumber = 'P180707171652460' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400245'
                WHERE ordernumber = 'P590707171726977' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400247'
                WHERE ordernumber = 'P420707171744305' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400246'
                WHERE ordernumber = 'P630707171753758' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400147'
                WHERE ordernumber = 'P200707171824560' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400248'
                WHERE ordernumber = 'P180707171959430' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400249'
                WHERE ordernumber = 'P420707172117415' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400250'
                WHERE ordernumber = 'P420707172259200' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400251'
                WHERE ordernumber = 'P200707172308125' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400252'
                WHERE ordernumber = 'P420707172647755' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400253'
                WHERE ordernumber = 'P200707172751147' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '152524'
                WHERE ordernumber = 'P180707172826133' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400254'
                WHERE ordernumber = 'P420707172906667' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400255'
                WHERE ordernumber = 'P200707173122659' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '109305'
                WHERE ordernumber = 'P590707173204779' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '221930'
                WHERE ordernumber = 'P190707173319170' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400256'
                WHERE ordernumber = 'P200707173343317' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400257'
                WHERE ordernumber = 'P420707173346826' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400258'
                WHERE ordernumber = 'P200707173459901' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '167240'
                WHERE ordernumber = 'P180707173621801' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400259'
                WHERE ordernumber = 'P200707173751507' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '142209'
                WHERE ordernumber = 'P200707173834172' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '354533'
                WHERE ordernumber = 'P180707173935885' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400260'
                WHERE ordernumber = 'P180707174202706' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '252261'
                WHERE ordernumber = 'P190707174235289' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400261'
                WHERE ordernumber = 'P200707174529195' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400262'
                WHERE ordernumber = 'P190707174623871' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '296785'
                WHERE ordernumber = 'P630707175005177' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '214021'
                WHERE ordernumber = 'P190707175233591' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400264'
                WHERE ordernumber = 'P180707175755253' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400265'
                WHERE ordernumber = 'P420707175827772' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '389057'
                WHERE ordernumber = 'P630707180244894' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400267'
                WHERE ordernumber = 'P180707180355290' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '359049'
                WHERE ordernumber = 'P180707180526729' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400268'
                WHERE ordernumber = 'P200707180938980' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400269'
                WHERE ordernumber = 'P180707181059456' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400270'
                WHERE ordernumber = 'P200707181259191' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400271'
                WHERE ordernumber = 'P420707181321700' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400270'
                WHERE ordernumber = 'P200707181346421' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P200707181554351' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400272'
                WHERE ordernumber = 'P200707181647113' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P200707181841719' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P200707181916194' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P200707182013568' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400273'
                WHERE ordernumber = 'P630707182302968' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400274'
                WHERE ordernumber = 'P200707182953799' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400275'
                WHERE ordernumber = 'P200707183456772' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400276'
                WHERE ordernumber = 'P420707183504531' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '207472'
                WHERE ordernumber = 'P180707184100486' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400277'
                WHERE ordernumber = 'P190707184134227' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386484'
                WHERE ordernumber = 'P180707184420535' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400278'
                WHERE ordernumber = 'P630707184527580' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '306027'
                WHERE ordernumber = 'P190707184646592' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350895'
                WHERE ordernumber = 'P420707184906242' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '317103'
                WHERE ordernumber = 'P180707185203605' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351917'
                WHERE ordernumber = 'P200707185354311' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351917'
                WHERE ordernumber = 'P200707185418684' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400280'
                WHERE ordernumber = 'P190707185430461' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400279'
                WHERE ordernumber = 'P630707185540288' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '168425'
                WHERE ordernumber = 'P420707185756926' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400281'
                WHERE ordernumber = 'P190707190053665' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400282'
                WHERE ordernumber = 'P420707190156813' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400282'
                WHERE ordernumber = 'P420707190403982' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '375005'
                WHERE ordernumber = 'P190707190441413' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '83639'
                WHERE ordernumber = 'P420707190530651' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400283'
                WHERE ordernumber = 'P630707190704632' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400284'
                WHERE ordernumber = 'P590707191333229' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400285'
                WHERE ordernumber = 'P190707191401987' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '336498'
                WHERE ordernumber = 'P630707191524308' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '301281'
                WHERE ordernumber = 'P200707191757428' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400286'
                WHERE ordernumber = 'P630707191856902' 
            
2024-07-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400287'
                WHERE ordernumber = 'P630707191958996' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '311238'
                WHERE ordernumber = 'P190707192533566' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400288'
                WHERE ordernumber = 'P200707192549194' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400289'
                WHERE ordernumber = 'P200707192724984' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400290'
                WHERE ordernumber = 'P630707192743568' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '391928'
                WHERE ordernumber = 'P190707193201825' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '392714'
                WHERE ordernumber = 'P200707193335959' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '398736'
                WHERE ordernumber = 'P200707193416652' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '396733'
                WHERE ordernumber = 'P200707193542682' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400291'
                WHERE ordernumber = 'P630707193907738' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372907'
                WHERE ordernumber = 'P630707194207748' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400292'
                WHERE ordernumber = 'P190707194508431' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '69273'
                WHERE ordernumber = 'P190707194833771' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400293'
                WHERE ordernumber = 'P200707195108702' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P200707195241570' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400294'
                WHERE ordernumber = 'P630707195313762' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400295'
                WHERE ordernumber = 'P630707195922777' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '398735'
                WHERE ordernumber = 'P630707200942598' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '272159'
                WHERE ordernumber = 'P590707201622235' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400297'
                WHERE ordernumber = 'P630707202750307' 
            
2024-07-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400298'
                WHERE ordernumber = 'P590707202840230'