2024-05-29 01:00:02 -- 將會員中心id寫入data-lake
2024-05-29 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-05-28%';
        
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392566'
                WHERE ordernumber = 'P630528105548344' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392570'
                WHERE ordernumber = 'P180528110722519' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392567'
                WHERE ordernumber = 'P180528110834263' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389775'
                WHERE ordernumber = 'P180528110919835' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358787'
                WHERE ordernumber = 'P190528111054980' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102068'
                WHERE ordernumber = 'P190528111813545' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P420528111931335' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132946'
                WHERE ordernumber = 'P180528111942515' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111382'
                WHERE ordernumber = 'P200528112034257' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361626'
                WHERE ordernumber = 'P420528112208561' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111382'
                WHERE ordernumber = 'P200528112229143' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340803'
                WHERE ordernumber = 'P190528112934610' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392572'
                WHERE ordernumber = 'P630528113208509' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392573'
                WHERE ordernumber = 'P200528113633397' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305084'
                WHERE ordernumber = 'P420528113805647' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216260'
                WHERE ordernumber = 'P180528114221422' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392574'
                WHERE ordernumber = 'P200528114412122' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380655'
                WHERE ordernumber = 'P180528114829898' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111382'
                WHERE ordernumber = 'P200528114928255' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278656'
                WHERE ordernumber = 'P630528115040637' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358673'
                WHERE ordernumber = 'P180528115144136' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392578'
                WHERE ordernumber = 'P200528120058749' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392579'
                WHERE ordernumber = 'P180528120129424' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392580'
                WHERE ordernumber = 'P200528120332768' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392581'
                WHERE ordernumber = 'P180528121203325' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392575'
                WHERE ordernumber = 'P710528121514958' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392583'
                WHERE ordernumber = 'P420528121736308' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392582'
                WHERE ordernumber = 'P630528121853637' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392584'
                WHERE ordernumber = 'P420528121920838' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '48921'
                WHERE ordernumber = 'P200528122127346' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350446'
                WHERE ordernumber = 'P180528122132596' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392586'
                WHERE ordernumber = 'P630528122533437' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '48921'
                WHERE ordernumber = 'P200528123142114' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384979'
                WHERE ordernumber = 'P200528123757984' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391667'
                WHERE ordernumber = 'P180528124801120' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392592'
                WHERE ordernumber = 'P200528125005393' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '185562'
                WHERE ordernumber = 'P180528125640585' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392594'
                WHERE ordernumber = 'P200528130648413' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392574'
                WHERE ordernumber = 'P200528130729296' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392595'
                WHERE ordernumber = 'P180528130743902' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105116'
                WHERE ordernumber = 'P200528130834931' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257894'
                WHERE ordernumber = 'P180528130924721' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392597'
                WHERE ordernumber = 'P420528131021399' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392598'
                WHERE ordernumber = 'P180528131251448' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391294'
                WHERE ordernumber = 'P180528131459846' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232174'
                WHERE ordernumber = 'P180528131825753' 
            
2024-05-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392599'
                WHERE ordernumber = 'P420528132050988' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392600'
                WHERE ordernumber = 'P200528132230988' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '38288'
                WHERE ordernumber = 'P790528132323999' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392601'
                WHERE ordernumber = 'P190528132341450' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365018'
                WHERE ordernumber = 'P190528132506355' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373869'
                WHERE ordernumber = 'P180528132556643' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104132'
                WHERE ordernumber = 'P420528133035712' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392603'
                WHERE ordernumber = 'P790528133058262' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392605'
                WHERE ordernumber = 'P200528133903887' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392608'
                WHERE ordernumber = 'P420528134024728' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392607'
                WHERE ordernumber = 'P200528134156601' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392349'
                WHERE ordernumber = 'P190528134729147' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247440'
                WHERE ordernumber = 'P190528134838532' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392609'
                WHERE ordernumber = 'P790528134925113' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240986'
                WHERE ordernumber = 'P190528135239420' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93821'
                WHERE ordernumber = 'P190528135338525' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299658'
                WHERE ordernumber = 'P200528135343462' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392613'
                WHERE ordernumber = 'P200528135501558' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392612'
                WHERE ordernumber = 'P200528135610115' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '45270'
                WHERE ordernumber = 'P420528135624681' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82404'
                WHERE ordernumber = 'P190528135917530' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392115'
                WHERE ordernumber = 'P790528140011122' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392615'
                WHERE ordernumber = 'P200528140032204' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392617'
                WHERE ordernumber = 'P180528140214755' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310157'
                WHERE ordernumber = 'P190528140321814' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392574'
                WHERE ordernumber = 'P420528140329873' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217067'
                WHERE ordernumber = 'P180528140535845' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392622'
                WHERE ordernumber = 'P180528141433697' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390727'
                WHERE ordernumber = 'P630528141448153' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392623'
                WHERE ordernumber = 'P190528142103638' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147103'
                WHERE ordernumber = 'P180528142120837' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392624'
                WHERE ordernumber = 'P200528142314223' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392625'
                WHERE ordernumber = 'P190528142410562' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99638'
                WHERE ordernumber = 'P180528142451708' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250130'
                WHERE ordernumber = 'P200528142548139' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392627'
                WHERE ordernumber = 'P180528142902314' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392631'
                WHERE ordernumber = 'P190528142935134' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392629'
                WHERE ordernumber = 'P180528143019618' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392626'
                WHERE ordernumber = 'P710528143122211' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392630'
                WHERE ordernumber = 'P180528143132326' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301150'
                WHERE ordernumber = 'P200528143541532' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392633'
                WHERE ordernumber = 'P180528143541510' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287248'
                WHERE ordernumber = 'P200528144336183' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392634'
                WHERE ordernumber = 'P420528144431845' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392635'
                WHERE ordernumber = 'P190528144609813' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P420528144758540' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319539'
                WHERE ordernumber = 'P190528144825643' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264003'
                WHERE ordernumber = 'P190528144943827' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137433'
                WHERE ordernumber = 'P200528145017708' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392636'
                WHERE ordernumber = 'P420528145019771' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392630'
                WHERE ordernumber = 'P180528145107363' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392637'
                WHERE ordernumber = 'P180528145315615' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392638'
                WHERE ordernumber = 'P190528145318242' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392640'
                WHERE ordernumber = 'P200528145637852' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392641'
                WHERE ordernumber = 'P190528145812253' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347639'
                WHERE ordernumber = 'P420528145849654' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392643'
                WHERE ordernumber = 'P180528150031888' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392644'
                WHERE ordernumber = 'P200528150041305' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160854'
                WHERE ordernumber = 'P200528150443771' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389989'
                WHERE ordernumber = 'P420528150455124' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214083'
                WHERE ordernumber = 'P200528150657605' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392403'
                WHERE ordernumber = 'P180528150918562' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343426'
                WHERE ordernumber = 'P180528151628605' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99616'
                WHERE ordernumber = 'P180528152450515' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392649'
                WHERE ordernumber = 'P420528153119957' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392650'
                WHERE ordernumber = 'P420528154136498' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392651'
                WHERE ordernumber = 'P420528154417444' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392653'
                WHERE ordernumber = 'P180528154721501' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392654'
                WHERE ordernumber = 'P420528154916773' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341905'
                WHERE ordernumber = 'P180528155048459' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392656'
                WHERE ordernumber = 'P200528155128963' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392657'
                WHERE ordernumber = 'P180528155325340' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241465'
                WHERE ordernumber = 'P180528160127461' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392660'
                WHERE ordernumber = 'P190528160318119' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392661'
                WHERE ordernumber = 'P630528160636507' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392662'
                WHERE ordernumber = 'P180528160647500' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346613'
                WHERE ordernumber = 'P420528160809938' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345515'
                WHERE ordernumber = 'P200528160837503' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392663'
                WHERE ordernumber = 'P710528160853332' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392664'
                WHERE ordernumber = 'P180528160952405' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P180528161411947' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314449'
                WHERE ordernumber = 'P200528161417672' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287566'
                WHERE ordernumber = 'P180528161826458' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392666'
                WHERE ordernumber = 'P200528161849143' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352011'
                WHERE ordernumber = 'P190528161944523' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318992'
                WHERE ordernumber = 'P180528162032872' 
            
2024-05-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392411'
                WHERE ordernumber = 'P420528162208774' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392667'
                WHERE ordernumber = 'P420528162655674' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378293'
                WHERE ordernumber = 'P420528162918989' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346749'
                WHERE ordernumber = 'P180528163325883' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392668'
                WHERE ordernumber = 'P180528163537684' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392669'
                WHERE ordernumber = 'P790528164158159' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391000'
                WHERE ordernumber = 'P710528164342570' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392671'
                WHERE ordernumber = 'P710528164501931' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392672'
                WHERE ordernumber = 'P790528165018341' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135579'
                WHERE ordernumber = 'P190528165030356' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392675'
                WHERE ordernumber = 'P420528165155604' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '22622'
                WHERE ordernumber = 'P180528165326414' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392675'
                WHERE ordernumber = 'P420528165629241' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392677'
                WHERE ordernumber = 'P180528170826869' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141949'
                WHERE ordernumber = 'P190528170941263' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392678'
                WHERE ordernumber = 'P420528171539832' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392680'
                WHERE ordernumber = 'P180528172634381' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392681'
                WHERE ordernumber = 'P200528172859970' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317906'
                WHERE ordernumber = 'P180528172957367' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388309'
                WHERE ordernumber = 'P190528173721781' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392682'
                WHERE ordernumber = 'P200528173953894' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392683'
                WHERE ordernumber = 'P180528174155408' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96146'
                WHERE ordernumber = 'P190528174823721' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96146'
                WHERE ordernumber = 'P190528175134263' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212827'
                WHERE ordernumber = 'P180528175220343' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312521'
                WHERE ordernumber = 'P200528175255311' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308785'
                WHERE ordernumber = 'P200528175334137' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325261'
                WHERE ordernumber = 'P420528175417438' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100460'
                WHERE ordernumber = 'P180528175440756' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126094'
                WHERE ordernumber = 'P200528175520459' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392687'
                WHERE ordernumber = 'P420528175726897' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392688'
                WHERE ordernumber = 'P200528180020399' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297844'
                WHERE ordernumber = 'P420528180132187' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392689'
                WHERE ordernumber = 'P420528180250614' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124039'
                WHERE ordernumber = 'P200528180410225' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392690'
                WHERE ordernumber = 'P200528180610950' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392691'
                WHERE ordernumber = 'P420528180617472' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392692'
                WHERE ordernumber = 'P200528180804525' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392693'
                WHERE ordernumber = 'P630528180858498' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221508'
                WHERE ordernumber = 'P190528180930580' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141525'
                WHERE ordernumber = 'P190528181457973' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89779'
                WHERE ordernumber = 'P180528181504807' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89779'
                WHERE ordernumber = 'P180528181531312' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392694'
                WHERE ordernumber = 'P180528182516655' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103028'
                WHERE ordernumber = 'P200528182617267' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392696'
                WHERE ordernumber = 'P180528183117237' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381267'
                WHERE ordernumber = 'P420528183226162' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321217'
                WHERE ordernumber = 'P420528183445720' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289795'
                WHERE ordernumber = 'P200528183556334' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295596'
                WHERE ordernumber = 'P200528183849774' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120331'
                WHERE ordernumber = 'P180528183929282' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367214'
                WHERE ordernumber = 'P200528184059854' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392697'
                WHERE ordernumber = 'P190528184406154' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P180528184713622' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341685'
                WHERE ordernumber = 'P190528184719626' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P180528184821302' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390919'
                WHERE ordernumber = 'P190528185113499' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369507'
                WHERE ordernumber = 'P420528185226831' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392699'
                WHERE ordernumber = 'P630528185421170' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236736'
                WHERE ordernumber = 'P200528185601610' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392700'
                WHERE ordernumber = 'P190528185634860' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392702'
                WHERE ordernumber = 'P630528191154907' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392703'
                WHERE ordernumber = 'P200528191458292' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392704'
                WHERE ordernumber = 'P190528191741610' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392701'
                WHERE ordernumber = 'P190528191930197' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306538'
                WHERE ordernumber = 'P190528192232677' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308192'
                WHERE ordernumber = 'P710528192242840' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306538'
                WHERE ordernumber = 'P190528192427460' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392704'
                WHERE ordernumber = 'P190528192728154' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236736'
                WHERE ordernumber = 'P200528193301938' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392709'
                WHERE ordernumber = 'P200528194732350' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392708'
                WHERE ordernumber = 'P790528194754857' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121795'
                WHERE ordernumber = 'P200528194848988' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392712'
                WHERE ordernumber = 'P200528195030377' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347214'
                WHERE ordernumber = 'P190528195336889' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271182'
                WHERE ordernumber = 'P190528195445269' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206637'
                WHERE ordernumber = 'P190528195545706' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388858'
                WHERE ordernumber = 'P190528195659303' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82016'
                WHERE ordernumber = 'P200528195901423' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173298'
                WHERE ordernumber = 'P710528202853384' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392715'
                WHERE ordernumber = 'P790528203648912' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392716'
                WHERE ordernumber = 'P790528204303881' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233627'
                WHERE ordernumber = 'P630528204523956' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392718'
                WHERE ordernumber = 'P790528210140760' 
            
2024-05-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390981'
                WHERE ordernumber = 'P790528212517453'