2024-09-22 01:00:02 -- 將會員中心id寫入data-lake
2024-09-22 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-09-21%';
        
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310799'
                WHERE ordernumber = 'P190921110347629' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240584'
                WHERE ordernumber = 'P200921110359383' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318562'
                WHERE ordernumber = 'P420921110410793' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422065'
                WHERE ordernumber = 'P420921111043923' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422066'
                WHERE ordernumber = 'P200921111508274' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422067'
                WHERE ordernumber = 'P420921111607571' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273382'
                WHERE ordernumber = 'P190921111839507' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '149706'
                WHERE ordernumber = 'P200921111958386' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136521'
                WHERE ordernumber = 'P190921112111822' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422068'
                WHERE ordernumber = 'P200921112212378' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225612'
                WHERE ordernumber = 'P200921112725537' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P200921112829737' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422071'
                WHERE ordernumber = 'P200921112930419' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422072'
                WHERE ordernumber = 'P420921113005214' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422070'
                WHERE ordernumber = 'P730921113114587' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137260'
                WHERE ordernumber = 'P200921113128778' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422073'
                WHERE ordernumber = 'P420921113500205' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422074'
                WHERE ordernumber = 'P420921113724918' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394746'
                WHERE ordernumber = 'P420921113800617' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422075'
                WHERE ordernumber = 'P730921114735382' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422076'
                WHERE ordernumber = 'P420921115007874' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404680'
                WHERE ordernumber = 'P420921120057916' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417590'
                WHERE ordernumber = 'P420921120346197' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '265842'
                WHERE ordernumber = 'P420921120539544' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422078'
                WHERE ordernumber = 'P420921121542343' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346202'
                WHERE ordernumber = 'P420921121719316' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138070'
                WHERE ordernumber = 'P190921121720310' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341132'
                WHERE ordernumber = 'P190921123031867' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422081'
                WHERE ordernumber = 'P420921123111797' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422080'
                WHERE ordernumber = 'P420921123231195' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422083'
                WHERE ordernumber = 'P420921123625235' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348486'
                WHERE ordernumber = 'P200921123958341' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '84724'
                WHERE ordernumber = 'P200921124745972' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422085'
                WHERE ordernumber = 'P710921130038513' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420771'
                WHERE ordernumber = 'P200921130504218' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '7882'
                WHERE ordernumber = 'P200921130558184' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310240'
                WHERE ordernumber = 'P420921130806522' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422087'
                WHERE ordernumber = 'P730921131431680' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240510'
                WHERE ordernumber = 'P180921131536553' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422090'
                WHERE ordernumber = 'P420921131919604' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396508'
                WHERE ordernumber = 'P180921132023913' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422091'
                WHERE ordernumber = 'P420921132329855' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421927'
                WHERE ordernumber = 'P180921132427961' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422092'
                WHERE ordernumber = 'P180921132844529' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304449'
                WHERE ordernumber = 'P180921133315709' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387038'
                WHERE ordernumber = 'P180921133630878' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422093'
                WHERE ordernumber = 'P730921133725149' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422094'
                WHERE ordernumber = 'P730921133913264' 
            
2024-09-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422095'
                WHERE ordernumber = 'P420921134006142' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371669'
                WHERE ordernumber = 'P420921134210112' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422096'
                WHERE ordernumber = 'P710921134255238' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299910'
                WHERE ordernumber = 'P200921134411636' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422098'
                WHERE ordernumber = 'P710921134451521' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283188'
                WHERE ordernumber = 'P180921134516302' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422099'
                WHERE ordernumber = 'P420921134546473' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422100'
                WHERE ordernumber = 'P710921134856825' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422102'
                WHERE ordernumber = 'P420921135019590' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422101'
                WHERE ordernumber = 'P730921135125487' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422103'
                WHERE ordernumber = 'P420921135209187' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422104'
                WHERE ordernumber = 'P710921135702882' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422105'
                WHERE ordernumber = 'P730921140029458' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242845'
                WHERE ordernumber = 'P180921140130388' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422106'
                WHERE ordernumber = 'P730921140346651' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315792'
                WHERE ordernumber = 'P730921140619400' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422107'
                WHERE ordernumber = 'P730921140804261' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422108'
                WHERE ordernumber = 'P420921141341954' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412772'
                WHERE ordernumber = 'P420921141518535' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422112'
                WHERE ordernumber = 'P200921141633161' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422111'
                WHERE ordernumber = 'P710921141825916' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95556'
                WHERE ordernumber = 'P180921142041176' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422113'
                WHERE ordernumber = 'P730921142212963' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422114'
                WHERE ordernumber = 'P200921142232946' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422110'
                WHERE ordernumber = 'P190921142326121' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422115'
                WHERE ordernumber = 'P730921142500422' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95556'
                WHERE ordernumber = 'P190921142554956' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422117'
                WHERE ordernumber = 'P200921142652295' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422116'
                WHERE ordernumber = 'P710921142653707' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422119'
                WHERE ordernumber = 'P420921143041708' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422120'
                WHERE ordernumber = 'P420921143302892' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422121'
                WHERE ordernumber = 'P420921143751427' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302233'
                WHERE ordernumber = 'P420921144733475' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248386'
                WHERE ordernumber = 'P200921145029870' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98533'
                WHERE ordernumber = 'P200921145122878' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422124'
                WHERE ordernumber = 'P420921150250798' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422123'
                WHERE ordernumber = 'P730921150319498' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422125'
                WHERE ordernumber = 'P730921150818594' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310573'
                WHERE ordernumber = 'P190921150837912' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422126'
                WHERE ordernumber = 'P710921150931841' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422127'
                WHERE ordernumber = 'P710921151452579' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111265'
                WHERE ordernumber = 'P200921151510454' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422131'
                WHERE ordernumber = 'P200921151957549' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422129'
                WHERE ordernumber = 'P730921152040325' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421657'
                WHERE ordernumber = 'P180921152040134' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422133'
                WHERE ordernumber = 'P200921152425634' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422132'
                WHERE ordernumber = 'P710921152434171' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422134'
                WHERE ordernumber = 'P420921152822862' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422136'
                WHERE ordernumber = 'P200921153028307' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422135'
                WHERE ordernumber = 'P710921153339964' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422138'
                WHERE ordernumber = 'P710921153510504' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132015'
                WHERE ordernumber = 'P710921153629273' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422140'
                WHERE ordernumber = 'P420921154141489' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422143'
                WHERE ordernumber = 'P200921154557210' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422144'
                WHERE ordernumber = 'P420921154714369' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422144'
                WHERE ordernumber = 'P420921154839650' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125957'
                WHERE ordernumber = 'P200921155141693' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356754'
                WHERE ordernumber = 'P180921155950298' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235736'
                WHERE ordernumber = 'P200921161110350' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348604'
                WHERE ordernumber = 'P200921161204405' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172820'
                WHERE ordernumber = 'P200921161516271' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422147'
                WHERE ordernumber = 'P180921161707837' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422148'
                WHERE ordernumber = 'P180921161808460' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422146'
                WHERE ordernumber = 'P710921161838806' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422150'
                WHERE ordernumber = 'P180921161859509' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422151'
                WHERE ordernumber = 'P180921162118973' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422149'
                WHERE ordernumber = 'P710921162131120' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421834'
                WHERE ordernumber = 'P710921162517707' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422153'
                WHERE ordernumber = 'P710921162855655' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422155'
                WHERE ordernumber = 'P420921163022491' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180921163102575' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422154'
                WHERE ordernumber = 'P710921163303260' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422157'
                WHERE ordernumber = 'P180921163348745' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232318'
                WHERE ordernumber = 'P180921163701139' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304497'
                WHERE ordernumber = 'P180921163753456' 
            
2024-09-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244559'
                WHERE ordernumber = 'P710921164032588' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422158'
                WHERE ordernumber = 'P180921164431677' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271193'
                WHERE ordernumber = 'P180921164604633' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415837'
                WHERE ordernumber = 'P420921164630202' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422159'
                WHERE ordernumber = 'P710921164748560' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422160'
                WHERE ordernumber = 'P180921164852544' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412372'
                WHERE ordernumber = 'P420921164932497' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166984'
                WHERE ordernumber = 'P710921165256420' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422161'
                WHERE ordernumber = 'P420921165342291' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422162'
                WHERE ordernumber = 'P420921165556135' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422164'
                WHERE ordernumber = 'P180921165616273' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422163'
                WHERE ordernumber = 'P180921165820403' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406975'
                WHERE ordernumber = 'P180921165857673' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315781'
                WHERE ordernumber = 'P180921170045379' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422165'
                WHERE ordernumber = 'P710921170240392' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422166'
                WHERE ordernumber = 'P180921170247768' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367902'
                WHERE ordernumber = 'P180921170459228' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422167'
                WHERE ordernumber = 'P180921170803236' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422168'
                WHERE ordernumber = 'P180921171018816' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305469'
                WHERE ordernumber = 'P180921171126321' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381866'
                WHERE ordernumber = 'P180921171410436' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422169'
                WHERE ordernumber = 'P730921171510214' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314233'
                WHERE ordernumber = 'P200921172131611' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333856'
                WHERE ordernumber = 'P200921173544164' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422171'
                WHERE ordernumber = 'P200921173746339' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164311'
                WHERE ordernumber = 'P180921173755876' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422170'
                WHERE ordernumber = 'P730921173806222' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422172'
                WHERE ordernumber = 'P710921173903327' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422173'
                WHERE ordernumber = 'P710921174250452' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422175'
                WHERE ordernumber = 'P420921180109945' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422177'
                WHERE ordernumber = 'P730921180607948' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422176'
                WHERE ordernumber = 'P730921180714955' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422178'
                WHERE ordernumber = 'P710921180740209' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118241'
                WHERE ordernumber = 'P180921180855883' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422179'
                WHERE ordernumber = 'P710921181324720' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422180'
                WHERE ordernumber = 'P180921181527512' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392084'
                WHERE ordernumber = 'P200921181831809' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422181'
                WHERE ordernumber = 'P180921182123492' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392084'
                WHERE ordernumber = 'P200921182158797' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419670'
                WHERE ordernumber = 'P420921183636902' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386871'
                WHERE ordernumber = 'P200921183748509' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422182'
                WHERE ordernumber = 'P710921184151459' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '192708'
                WHERE ordernumber = 'P730921184803496' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422184'
                WHERE ordernumber = 'P420921184856218' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422185'
                WHERE ordernumber = 'P180921184905378' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419860'
                WHERE ordernumber = 'P420921185601780' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422188'
                WHERE ordernumber = 'P730921185753911' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275946'
                WHERE ordernumber = 'P730921190455947' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138882'
                WHERE ordernumber = 'P710921191414978' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134920'
                WHERE ordernumber = 'P710921192339255' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422198'
                WHERE ordernumber = 'P710921201642260' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422199'
                WHERE ordernumber = 'P710921201823937' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422200'
                WHERE ordernumber = 'P710921202045930' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302304'
                WHERE ordernumber = 'P730921202748929' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421601'
                WHERE ordernumber = 'P710921203618150' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376716'
                WHERE ordernumber = 'P710921204816448' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422204'
                WHERE ordernumber = 'P710921205221349' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '29548'
                WHERE ordernumber = 'P710921212631273' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422206'
                WHERE ordernumber = 'P730921212951392' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422208'
                WHERE ordernumber = 'P710921213409832' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422209'
                WHERE ordernumber = 'P710921213901663' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422210'
                WHERE ordernumber = 'P730921214538583' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130625'
                WHERE ordernumber = 'P710921215249589' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95745'
                WHERE ordernumber = 'P730921215347417' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165705'
                WHERE ordernumber = 'P710921215655503' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422211'
                WHERE ordernumber = 'P710921220001958' 
            
2024-09-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422213'
                WHERE ordernumber = 'P710921221051730'