2024-05-04 01:00:01 -- 將會員中心id寫入data-lake
2024-05-04 01:00:01 -- 
            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-03%';
        
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388050'
                WHERE ordernumber = 'P630503103506825' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388051'
                WHERE ordernumber = 'P630503105530539' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112637'
                WHERE ordernumber = 'P180503110059830' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388054'
                WHERE ordernumber = 'P180503110437655' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '83959'
                WHERE ordernumber = 'P190503110442651' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384223'
                WHERE ordernumber = 'P180503110554337' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200503110730316' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278069'
                WHERE ordernumber = 'P200503110947576' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231490'
                WHERE ordernumber = 'P180503110954890' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P200503111449587' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387625'
                WHERE ordernumber = 'P180503111600145' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387602'
                WHERE ordernumber = 'P180503111724445' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235186'
                WHERE ordernumber = 'P630503111808329' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388056'
                WHERE ordernumber = 'P190503111857266' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388055'
                WHERE ordernumber = 'P200503112053943' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222982'
                WHERE ordernumber = 'P420503112103579' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388057'
                WHERE ordernumber = 'P630503112127713' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388058'
                WHERE ordernumber = 'P200503112443909' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388060'
                WHERE ordernumber = 'P420503112743330' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388059'
                WHERE ordernumber = 'P420503112845724' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388062'
                WHERE ordernumber = 'P180503113501516' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388063'
                WHERE ordernumber = 'P180503113832224' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232308'
                WHERE ordernumber = 'P200503114137702' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200503114314610' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '31994'
                WHERE ordernumber = 'P180503114319531' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388064'
                WHERE ordernumber = 'P790503114340987' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '16587'
                WHERE ordernumber = 'P200503114415732' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136216'
                WHERE ordernumber = 'P180503115234144' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341653'
                WHERE ordernumber = 'P200503120151184' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387918'
                WHERE ordernumber = 'P420503120319431' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255480'
                WHERE ordernumber = 'P180503120500937' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350446'
                WHERE ordernumber = 'P180503120639697' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304667'
                WHERE ordernumber = 'P420503120922119' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388069'
                WHERE ordernumber = 'P200503121019223' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388070'
                WHERE ordernumber = 'P180503121027114' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317739'
                WHERE ordernumber = 'P630503121219778' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P180503121258567' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388071'
                WHERE ordernumber = 'P190503121301646' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388072'
                WHERE ordernumber = 'P180503121407271' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358840'
                WHERE ordernumber = 'P200503121904195' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235901'
                WHERE ordernumber = 'P200503122138939' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387984'
                WHERE ordernumber = 'P200503122624744' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369701'
                WHERE ordernumber = 'P200503123022159' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388075'
                WHERE ordernumber = 'P420503123111458' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288433'
                WHERE ordernumber = 'P200503123153571' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378296'
                WHERE ordernumber = 'P180503123217757' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369701'
                WHERE ordernumber = 'P200503123307393' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388076'
                WHERE ordernumber = 'P790503123504495' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388077'
                WHERE ordernumber = 'P420503123649147' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388079'
                WHERE ordernumber = 'P790503124625473' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388080'
                WHERE ordernumber = 'P200503124951969' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374349'
                WHERE ordernumber = 'P420503125252357' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129132'
                WHERE ordernumber = 'P180503130054829' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388082'
                WHERE ordernumber = 'P420503130157849' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388083'
                WHERE ordernumber = 'P180503130539476' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135079'
                WHERE ordernumber = 'P630503130554387' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388084'
                WHERE ordernumber = 'P790503130707850' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385040'
                WHERE ordernumber = 'P420503130857148' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388085'
                WHERE ordernumber = 'P200503131133740' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388086'
                WHERE ordernumber = 'P180503131828615' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388089'
                WHERE ordernumber = 'P190503132142668' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388087'
                WHERE ordernumber = 'P790503132307781' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318790'
                WHERE ordernumber = 'P420503132340677' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388091'
                WHERE ordernumber = 'P790503132650700' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142114'
                WHERE ordernumber = 'P200503133240293' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388095'
                WHERE ordernumber = 'P790503134022912' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304141'
                WHERE ordernumber = 'P200503134051130' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388097'
                WHERE ordernumber = 'P420503134433672' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294776'
                WHERE ordernumber = 'P180503134720225' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232545'
                WHERE ordernumber = 'P200503135504475' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285340'
                WHERE ordernumber = 'P180503135726269' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388099'
                WHERE ordernumber = 'P180503140426924' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '330382'
                WHERE ordernumber = 'P420503140723987' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320661'
                WHERE ordernumber = 'P180503140755753' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268528'
                WHERE ordernumber = 'P420503140956344' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388100'
                WHERE ordernumber = 'P790503141006805' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388101'
                WHERE ordernumber = 'P180503141333292' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293815'
                WHERE ordernumber = 'P180503142151334' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388103'
                WHERE ordernumber = 'P790503142326380' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388104'
                WHERE ordernumber = 'P790503142901183' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339680'
                WHERE ordernumber = 'P420503143105489' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388105'
                WHERE ordernumber = 'P180503143145436' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385059'
                WHERE ordernumber = 'P190503143152446' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305291'
                WHERE ordernumber = 'P180503143448371' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388106'
                WHERE ordernumber = 'P180503143755319' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388107'
                WHERE ordernumber = 'P790503143936403' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250079'
                WHERE ordernumber = 'P200503144251298' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388110'
                WHERE ordernumber = 'P180503144630796' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381403'
                WHERE ordernumber = 'P190503144701136' 
            
2024-05-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388111'
                WHERE ordernumber = 'P790503144745453' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369101'
                WHERE ordernumber = 'P420503144804987' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388088'
                WHERE ordernumber = 'P180503144916679' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332196'
                WHERE ordernumber = 'P420503144927147' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379460'
                WHERE ordernumber = 'P200503145010637' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388113'
                WHERE ordernumber = 'P630503145025504' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388114'
                WHERE ordernumber = 'P420503145105790' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339680'
                WHERE ordernumber = 'P420503145143196' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277459'
                WHERE ordernumber = 'P200503145242425' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378461'
                WHERE ordernumber = 'P200503145539281' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388115'
                WHERE ordernumber = 'P790503145707821' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388116'
                WHERE ordernumber = 'P200503145759238' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388118'
                WHERE ordernumber = 'P180503150101700' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388117'
                WHERE ordernumber = 'P790503150128944' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388119'
                WHERE ordernumber = 'P790503150952945' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371333'
                WHERE ordernumber = 'P790503151216487' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62910'
                WHERE ordernumber = 'P180503151313355' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P420503151340214' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62910'
                WHERE ordernumber = 'P180503151340127' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388120'
                WHERE ordernumber = 'P790503151501429' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388123'
                WHERE ordernumber = 'P190503152453328' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388124'
                WHERE ordernumber = 'P630503152647920' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388125'
                WHERE ordernumber = 'P180503152934528' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388126'
                WHERE ordernumber = 'P420503153537597' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388127'
                WHERE ordernumber = 'P790503153728590' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388090'
                WHERE ordernumber = 'P180503153908674' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388128'
                WHERE ordernumber = 'P180503154049639' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234770'
                WHERE ordernumber = 'P630503155400336' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '174357'
                WHERE ordernumber = 'P180503155702999' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380459'
                WHERE ordernumber = 'P420503160217844' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388130'
                WHERE ordernumber = 'P790503160320394' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180503160429509' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388131'
                WHERE ordernumber = 'P180503161429304' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388133'
                WHERE ordernumber = 'P200503161711658' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239207'
                WHERE ordernumber = 'P200503161749635' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303764'
                WHERE ordernumber = 'P200503161853656' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388137'
                WHERE ordernumber = 'P180503162007511' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388136'
                WHERE ordernumber = 'P790503162124952' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356764'
                WHERE ordernumber = 'P420503162714832' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385398'
                WHERE ordernumber = 'P200503162732682' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341907'
                WHERE ordernumber = 'P180503162847436' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266459'
                WHERE ordernumber = 'P630503162914501' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387231'
                WHERE ordernumber = 'P420503163113836' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283070'
                WHERE ordernumber = 'P180503163302156' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297017'
                WHERE ordernumber = 'P200503163529870' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220125'
                WHERE ordernumber = 'P180503163759987' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279795'
                WHERE ordernumber = 'P180503163904702' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '38671'
                WHERE ordernumber = 'P790503164030634' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388140'
                WHERE ordernumber = 'P200503164207307' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283811'
                WHERE ordernumber = 'P180503164355708' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314080'
                WHERE ordernumber = 'P190503164511335' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388143'
                WHERE ordernumber = 'P180503165058376' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388142'
                WHERE ordernumber = 'P420503165128290' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388141'
                WHERE ordernumber = 'P630503165135274' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388144'
                WHERE ordernumber = 'P180503165306929' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388053'
                WHERE ordernumber = 'P200503165336760' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281716'
                WHERE ordernumber = 'P200503165614362' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388145'
                WHERE ordernumber = 'P630503165711687' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388146'
                WHERE ordernumber = 'P180503170017215' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388147'
                WHERE ordernumber = 'P630503170035941' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149479'
                WHERE ordernumber = 'P630503170304554' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388150'
                WHERE ordernumber = 'P200503170339998' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342880'
                WHERE ordernumber = 'P200503170459456' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P200503170637882' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388151'
                WHERE ordernumber = 'P180503170859175' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388152'
                WHERE ordernumber = 'P420503170947799' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387652'
                WHERE ordernumber = 'P420503171210544' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388148'
                WHERE ordernumber = 'P180503171330568' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279039'
                WHERE ordernumber = 'P200503171625790' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84832'
                WHERE ordernumber = 'P180503171729937' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339894'
                WHERE ordernumber = 'P420503171857729' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134565'
                WHERE ordernumber = 'P200503172156940' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215062'
                WHERE ordernumber = 'P180503172322557' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387491'
                WHERE ordernumber = 'P420503172412127' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388154'
                WHERE ordernumber = 'P180503172506358' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388153'
                WHERE ordernumber = 'P200503172703355' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388155'
                WHERE ordernumber = 'P180503173009293' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388156'
                WHERE ordernumber = 'P790503173841434' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388157'
                WHERE ordernumber = 'P190503173900126' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388158'
                WHERE ordernumber = 'P420503174001808' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388159'
                WHERE ordernumber = 'P630503174112769' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372753'
                WHERE ordernumber = 'P420503174241910' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333855'
                WHERE ordernumber = 'P180503174403547' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388160'
                WHERE ordernumber = 'P180503174806151' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388161'
                WHERE ordernumber = 'P630503174934389' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388053'
                WHERE ordernumber = 'P200503175242158' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388164'
                WHERE ordernumber = 'P200503175930747' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388165'
                WHERE ordernumber = 'P630503180121515' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379392'
                WHERE ordernumber = 'P630503180153247' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119326'
                WHERE ordernumber = 'P180503180244807' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388163'
                WHERE ordernumber = 'P790503180456509' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385557'
                WHERE ordernumber = 'P200503181935374' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220338'
                WHERE ordernumber = 'P180503182025860' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280157'
                WHERE ordernumber = 'P590503182325500' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388167'
                WHERE ordernumber = 'P200503182452393' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312521'
                WHERE ordernumber = 'P200503183026768' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388168'
                WHERE ordernumber = 'P190503183224409' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388171'
                WHERE ordernumber = 'P630503183605879' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '83906'
                WHERE ordernumber = 'P790503184043930' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307262'
                WHERE ordernumber = 'P200503184219739' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386162'
                WHERE ordernumber = 'P190503184932703' 
            
2024-05-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388173'
                WHERE ordernumber = 'P630503184959279' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388174'
                WHERE ordernumber = 'P420503185046711' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388175'
                WHERE ordernumber = 'P190503185349873' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125430'
                WHERE ordernumber = 'P190503185421342' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124014'
                WHERE ordernumber = 'P190503190950662' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388178'
                WHERE ordernumber = 'P200503191345952' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388177'
                WHERE ordernumber = 'P790503191352855' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388179'
                WHERE ordernumber = 'P200503191647691' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273583'
                WHERE ordernumber = 'P200503191745791' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388181'
                WHERE ordernumber = 'P420503192507484' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388182'
                WHERE ordernumber = 'P190503192726572' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388039'
                WHERE ordernumber = 'P420503193239838' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297482'
                WHERE ordernumber = 'P190503193835330' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388183'
                WHERE ordernumber = 'P790503193957875' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388185'
                WHERE ordernumber = 'P190503194126378' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388185'
                WHERE ordernumber = 'P190503194156368' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301080'
                WHERE ordernumber = 'P420503194159304' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '195013'
                WHERE ordernumber = 'P200503194254980' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272456'
                WHERE ordernumber = 'P200503194535216' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301585'
                WHERE ordernumber = 'P190503194634175' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350922'
                WHERE ordernumber = 'P190503195013286' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338505'
                WHERE ordernumber = 'P200503195335262' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388188'
                WHERE ordernumber = 'P630503195922708' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388188'
                WHERE ordernumber = 'P630503195925283' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385765'
                WHERE ordernumber = 'P420503200056675' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388189'
                WHERE ordernumber = 'P420503200255123' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388190'
                WHERE ordernumber = 'P630503200740769' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388193'
                WHERE ordernumber = 'P630503202132820' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388194'
                WHERE ordernumber = 'P630503202421295' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388122'
                WHERE ordernumber = 'P630503203445344' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277235'
                WHERE ordernumber = 'P790503204740684' 
            
2024-05-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388196'
                WHERE ordernumber = 'P790503210906793'