2024-06-26 01:00:03 -- 將會員中心id寫入data-lake
2024-06-26 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-06-25%';
        
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397954'
                WHERE ordernumber = 'P630625103844715' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228920'
                WHERE ordernumber = 'P420625110147148' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397958'
                WHERE ordernumber = 'P200625110152417' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49345'
                WHERE ordernumber = 'P200625110247794' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397960'
                WHERE ordernumber = 'P200625110459663' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277935'
                WHERE ordernumber = 'P420625110511606' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393057'
                WHERE ordernumber = 'P200625110551410' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397961'
                WHERE ordernumber = 'P190625110605954' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214660'
                WHERE ordernumber = 'P180625110809694' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397962'
                WHERE ordernumber = 'P190625110821942' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367851'
                WHERE ordernumber = 'P180625110940470' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397963'
                WHERE ordernumber = 'P420625110944132' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300645'
                WHERE ordernumber = 'P420625111105508' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397964'
                WHERE ordernumber = 'P180625111123302' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387701'
                WHERE ordernumber = 'P200625111154185' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397965'
                WHERE ordernumber = 'P190625111627424' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218749'
                WHERE ordernumber = 'P190625111736535' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397966'
                WHERE ordernumber = 'P420625111756248' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389016'
                WHERE ordernumber = 'P200625112452602' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288562'
                WHERE ordernumber = 'P200625112541795' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62458'
                WHERE ordernumber = 'P200625112655359' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218728'
                WHERE ordernumber = 'P200625112836966' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230111'
                WHERE ordernumber = 'P190625112955695' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397967'
                WHERE ordernumber = 'P180625113129764' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217809'
                WHERE ordernumber = 'P200625113246558' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217941'
                WHERE ordernumber = 'P180625114121837' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397968'
                WHERE ordernumber = 'P180625114412490' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397969'
                WHERE ordernumber = 'P200625114449527' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397970'
                WHERE ordernumber = 'P420625115310563' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '42491'
                WHERE ordernumber = 'P780625115402576' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285872'
                WHERE ordernumber = 'P200625115510673' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311997'
                WHERE ordernumber = 'P180625115911345' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247344'
                WHERE ordernumber = 'P200625120311310' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P200625120407628' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397971'
                WHERE ordernumber = 'P420625120454408' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397973'
                WHERE ordernumber = 'P180625120931585' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381089'
                WHERE ordernumber = 'P420625121034397' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397976'
                WHERE ordernumber = 'P200625121338725' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269426'
                WHERE ordernumber = 'P180625121743208' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397977'
                WHERE ordernumber = 'P630625121836541' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397978'
                WHERE ordernumber = 'P200625121919303' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388775'
                WHERE ordernumber = 'P200625122359574' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397741'
                WHERE ordernumber = 'P420625122521431' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P420625123016538' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397979'
                WHERE ordernumber = 'P590625123037146' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228365'
                WHERE ordernumber = 'P180625123205300' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397980'
                WHERE ordernumber = 'P420625123244459' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384050'
                WHERE ordernumber = 'P200625123257493' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132247'
                WHERE ordernumber = 'P180625123408268' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397982'
                WHERE ordernumber = 'P180625123745426' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397983'
                WHERE ordernumber = 'P420625123837955' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397984'
                WHERE ordernumber = 'P420625124054116' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397985'
                WHERE ordernumber = 'P420625124300391' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225631'
                WHERE ordernumber = 'P420625124439414' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226376'
                WHERE ordernumber = 'P420625124544685' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397986'
                WHERE ordernumber = 'P200625124648172' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141131'
                WHERE ordernumber = 'P200625124742328' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313065'
                WHERE ordernumber = 'P180625125016422' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210362'
                WHERE ordernumber = 'P200625125357280' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397987'
                WHERE ordernumber = 'P200625125551992' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388814'
                WHERE ordernumber = 'P420625125921331' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397988'
                WHERE ordernumber = 'P180625125938207' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397990'
                WHERE ordernumber = 'P180625130602708' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319392'
                WHERE ordernumber = 'P180625130741413' 
            
2024-06-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397991'
                WHERE ordernumber = 'P200625130800144' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253543'
                WHERE ordernumber = 'P180625130957290' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396528'
                WHERE ordernumber = 'P420625131334713' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397993'
                WHERE ordernumber = 'P630625131605700' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190625131801566' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397994'
                WHERE ordernumber = 'P200625131838827' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130570'
                WHERE ordernumber = 'P200625131918731' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396528'
                WHERE ordernumber = 'P420625132050740' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383057'
                WHERE ordernumber = 'P180625132059371' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327308'
                WHERE ordernumber = 'P200625132109293' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263388'
                WHERE ordernumber = 'P200625132159464' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397927'
                WHERE ordernumber = 'P420625132323511' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397927'
                WHERE ordernumber = 'P420625132537747' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397995'
                WHERE ordernumber = 'P180625132546222' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397996'
                WHERE ordernumber = 'P200625132605718' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386860'
                WHERE ordernumber = 'P420625132658469' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386969'
                WHERE ordernumber = 'P190625133003635' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397997'
                WHERE ordernumber = 'P180625133247147' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244678'
                WHERE ordernumber = 'P200625133417759' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397998'
                WHERE ordernumber = 'P590625133722552' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397999'
                WHERE ordernumber = 'P200625134122978' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398000'
                WHERE ordernumber = 'P180625134217305' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398001'
                WHERE ordernumber = 'P180625134512856' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398001'
                WHERE ordernumber = 'P180625134554597' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363403'
                WHERE ordernumber = 'P180625134945911' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398003'
                WHERE ordernumber = 'P630625135234731' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P180625135414315' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143087'
                WHERE ordernumber = 'P200625135635684' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P180625135643357' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305149'
                WHERE ordernumber = 'P200625140034819' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398004'
                WHERE ordernumber = 'P180625140100543' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309849'
                WHERE ordernumber = 'P190625140213396' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398005'
                WHERE ordernumber = 'P630625140555197' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398006'
                WHERE ordernumber = 'P180625140626503' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398007'
                WHERE ordernumber = 'P190625140736863' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384449'
                WHERE ordernumber = 'P180625140957958' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206620'
                WHERE ordernumber = 'P180625141227990' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398009'
                WHERE ordernumber = 'P180625141707753' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398008'
                WHERE ordernumber = 'P630625141719129' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398010'
                WHERE ordernumber = 'P190625141823791' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388940'
                WHERE ordernumber = 'P420625142235597' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383634'
                WHERE ordernumber = 'P420625142459558' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398012'
                WHERE ordernumber = 'P200625142604221' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398004'
                WHERE ordernumber = 'P180625142729390' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398013'
                WHERE ordernumber = 'P180625143000350' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398012'
                WHERE ordernumber = 'P200625143024608' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398014'
                WHERE ordernumber = 'P420625143318148' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398015'
                WHERE ordernumber = 'P180625143412113' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398016'
                WHERE ordernumber = 'P200625143417980' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398017'
                WHERE ordernumber = 'P190625143513483' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384329'
                WHERE ordernumber = 'P180625143523688' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398018'
                WHERE ordernumber = 'P180625143731745' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398019'
                WHERE ordernumber = 'P420625144005419' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398020'
                WHERE ordernumber = 'P180625144042292' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398022'
                WHERE ordernumber = 'P180625144316554' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398023'
                WHERE ordernumber = 'P180625144453851' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398021'
                WHERE ordernumber = 'P190625144506395' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308062'
                WHERE ordernumber = 'P630625144646589' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277459'
                WHERE ordernumber = 'P200625145224622' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286885'
                WHERE ordernumber = 'P180625145356870' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389066'
                WHERE ordernumber = 'P420625145402579' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '28051'
                WHERE ordernumber = 'P780625145658202' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386359'
                WHERE ordernumber = 'P630625145823679' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283036'
                WHERE ordernumber = 'P180625150103334' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398025'
                WHERE ordernumber = 'P420625150211974' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398026'
                WHERE ordernumber = 'P190625150251714' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392841'
                WHERE ordernumber = 'P590625150452747' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270938'
                WHERE ordernumber = 'P200625150609958' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358902'
                WHERE ordernumber = 'P630625150617810' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398028'
                WHERE ordernumber = 'P630625150951955' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297083'
                WHERE ordernumber = 'P630625151103463' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279256'
                WHERE ordernumber = 'P630625151155752' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398030'
                WHERE ordernumber = 'P190625151445318' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398029'
                WHERE ordernumber = 'P420625151456764' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297775'
                WHERE ordernumber = 'P190625151624918' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396803'
                WHERE ordernumber = 'P190625152036555' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398031'
                WHERE ordernumber = 'P630625152147157' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398032'
                WHERE ordernumber = 'P630625152233758' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398033'
                WHERE ordernumber = 'P190625152712840' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398037'
                WHERE ordernumber = 'P180625152903986' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398035'
                WHERE ordernumber = 'P200625152916158' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398036'
                WHERE ordernumber = 'P190625152930199' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353481'
                WHERE ordernumber = 'P420625153535305' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118590'
                WHERE ordernumber = 'P180625153645831' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398038'
                WHERE ordernumber = 'P630625153820674' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297104'
                WHERE ordernumber = 'P420625153825357' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312687'
                WHERE ordernumber = 'P780625153942584' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398039'
                WHERE ordernumber = 'P200625154216625' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387838'
                WHERE ordernumber = 'P200625154323434' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218542'
                WHERE ordernumber = 'P180625154728923' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398040'
                WHERE ordernumber = 'P200625154813566' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398042'
                WHERE ordernumber = 'P190625155138987' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398043'
                WHERE ordernumber = 'P180625155355862' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396127'
                WHERE ordernumber = 'P180625155813137' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397051'
                WHERE ordernumber = 'P180625160121476' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311361'
                WHERE ordernumber = 'P180625160348958' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398047'
                WHERE ordernumber = 'P180625161012858' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398048'
                WHERE ordernumber = 'P180625161238116' 
            
2024-06-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333406'
                WHERE ordernumber = 'P180625161343505' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102047'
                WHERE ordernumber = 'P200625161631488' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394207'
                WHERE ordernumber = 'P180625161942807' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366208'
                WHERE ordernumber = 'P420625162153244' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326304'
                WHERE ordernumber = 'P180625162356447' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384456'
                WHERE ordernumber = 'P180625162847907' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334889'
                WHERE ordernumber = 'P180625163200849' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398052'
                WHERE ordernumber = 'P420625163413208' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364418'
                WHERE ordernumber = 'P180625163451722' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336368'
                WHERE ordernumber = 'P420625163503126' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398053'
                WHERE ordernumber = 'P780625163536847' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398054'
                WHERE ordernumber = 'P180625163632985' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395978'
                WHERE ordernumber = 'P200625164110297' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398055'
                WHERE ordernumber = 'P200625164231283' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '87593'
                WHERE ordernumber = 'P180625164613494' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398056'
                WHERE ordernumber = 'P590625164734603' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398059'
                WHERE ordernumber = 'P630625165128823' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398058'
                WHERE ordernumber = 'P180625165138783' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398060'
                WHERE ordernumber = 'P190625165203321' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398061'
                WHERE ordernumber = 'P190625165520420' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393290'
                WHERE ordernumber = 'P420625165957665' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '3159'
                WHERE ordernumber = 'P190625170340112' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398063'
                WHERE ordernumber = 'P190625170615511' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398064'
                WHERE ordernumber = 'P420625170950400' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286027'
                WHERE ordernumber = 'P200625171240856' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238134'
                WHERE ordernumber = 'P200625171310446' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258005'
                WHERE ordernumber = 'P180625171455434' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398065'
                WHERE ordernumber = 'P200625171618941' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116809'
                WHERE ordernumber = 'P190625171822906' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105630'
                WHERE ordernumber = 'P200625172145155' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379518'
                WHERE ordernumber = 'P180625172250636' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348261'
                WHERE ordernumber = 'P180625172451239' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328345'
                WHERE ordernumber = 'P180625172638757' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395660'
                WHERE ordernumber = 'P180625172929340' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398066'
                WHERE ordernumber = 'P180625173525542' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398067'
                WHERE ordernumber = 'P630625173900752' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398068'
                WHERE ordernumber = 'P190625174019111' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '126645'
                WHERE ordernumber = 'P420625174033745' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385831'
                WHERE ordernumber = 'P190625174117116' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398069'
                WHERE ordernumber = 'P200625174249884' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398070'
                WHERE ordernumber = 'P200625174505987' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398072'
                WHERE ordernumber = 'P180625175213552' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398074'
                WHERE ordernumber = 'P630625175630171' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385796'
                WHERE ordernumber = 'P180625175827500' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398075'
                WHERE ordernumber = 'P630625175936958' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398076'
                WHERE ordernumber = 'P420625180002634' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398077'
                WHERE ordernumber = 'P630625180257266' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '741'
                WHERE ordernumber = 'P180625180629402' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398079'
                WHERE ordernumber = 'P630625180730202' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398080'
                WHERE ordernumber = 'P630625181443286' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292079'
                WHERE ordernumber = 'P420625181512364' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381358'
                WHERE ordernumber = 'P200625181525565' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398081'
                WHERE ordernumber = 'P200625181757631' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '196988'
                WHERE ordernumber = 'P200625182031199' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398082'
                WHERE ordernumber = 'P780625182235358' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '199954'
                WHERE ordernumber = 'P200625182248679' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352951'
                WHERE ordernumber = 'P180625182415423' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398084'
                WHERE ordernumber = 'P630625182937874' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398085'
                WHERE ordernumber = 'P190625183053727' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398083'
                WHERE ordernumber = 'P180625183239376' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242582'
                WHERE ordernumber = 'P190625183346234' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398086'
                WHERE ordernumber = 'P190625183518219' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389634'
                WHERE ordernumber = 'P190625183645380' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254652'
                WHERE ordernumber = 'P180625183957136' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238944'
                WHERE ordernumber = 'P200625184131515' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287062'
                WHERE ordernumber = 'P200625184549872' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398087'
                WHERE ordernumber = 'P180625184915548' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137176'
                WHERE ordernumber = 'P630625185303562' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398088'
                WHERE ordernumber = 'P630625185433354' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364705'
                WHERE ordernumber = 'P200625185906701' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P190625190043733' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P190625190152295' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398090'
                WHERE ordernumber = 'P190625190411641' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398091'
                WHERE ordernumber = 'P630625190514172' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398092'
                WHERE ordernumber = 'P190625190528899' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398093'
                WHERE ordernumber = 'P190625190706852' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398094'
                WHERE ordernumber = 'P630625190830699' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308402'
                WHERE ordernumber = 'P200625190850257' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337524'
                WHERE ordernumber = 'P190625190906454' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217259'
                WHERE ordernumber = 'P630625190924758' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398095'
                WHERE ordernumber = 'P630625191039552' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398098'
                WHERE ordernumber = 'P630625191731297' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '138016'
                WHERE ordernumber = 'P630625191843437' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398097'
                WHERE ordernumber = 'P630625191854312' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '75881'
                WHERE ordernumber = 'P190625192447210' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98198'
                WHERE ordernumber = 'P200625192639244' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398099'
                WHERE ordernumber = 'P630625192719231' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398100'
                WHERE ordernumber = 'P200625192828996' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347522'
                WHERE ordernumber = 'P200625192922537' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345628'
                WHERE ordernumber = 'P200625193029252' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218516'
                WHERE ordernumber = 'P190625193141488' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398101'
                WHERE ordernumber = 'P630625193154907' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398102'
                WHERE ordernumber = 'P200625193154680' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378295'
                WHERE ordernumber = 'P190625193404884' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398103'
                WHERE ordernumber = 'P630625193433617' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236236'
                WHERE ordernumber = 'P200625193702541' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398105'
                WHERE ordernumber = 'P630625194116255' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398107'
                WHERE ordernumber = 'P630625195649242' 
            
2024-06-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '138293'
                WHERE ordernumber = 'P190625195928878' 
            
2024-06-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341869'
                WHERE ordernumber = 'P630625200532391' 
            
2024-06-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '398108'
                WHERE ordernumber = 'P630625200729736' 
            
2024-06-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '391975'
                WHERE ordernumber = 'P630625204045555' 
            
2024-06-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '398109'
                WHERE ordernumber = 'P630625210519870' 
            
2024-06-26 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '398110'
                WHERE ordernumber = 'P630625211157721'