2024-05-28 01:00:01 -- 將會員中心id寫入data-lake
2024-05-28 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-27%';
        
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392363'
                WHERE ordernumber = 'P200527110337857' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392364'
                WHERE ordernumber = 'P180527110633332' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392365'
                WHERE ordernumber = 'P200527110806984' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261769'
                WHERE ordernumber = 'P180527111031448' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P190527111128674' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392366'
                WHERE ordernumber = 'P180527111149901' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115173'
                WHERE ordernumber = 'P180527111253924' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392367'
                WHERE ordernumber = 'P190527111326585' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392362'
                WHERE ordernumber = 'P180527111345324' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392362'
                WHERE ordernumber = 'P180527111428551' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237374'
                WHERE ordernumber = 'P180527111952263' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392369'
                WHERE ordernumber = 'P190527112034942' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237374'
                WHERE ordernumber = 'P180527112036199' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237374'
                WHERE ordernumber = 'P180527112113568' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392368'
                WHERE ordernumber = 'P190527112125956' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392368'
                WHERE ordernumber = 'P190527112207214' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180527112400799' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392371'
                WHERE ordernumber = 'P190527112419737' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392373'
                WHERE ordernumber = 'P180527112603586' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392374'
                WHERE ordernumber = 'P200527113205737' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87269'
                WHERE ordernumber = 'P200527113426341' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261117'
                WHERE ordernumber = 'P200527113949422' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '52904'
                WHERE ordernumber = 'P180527113959702' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392375'
                WHERE ordernumber = 'P190527114023924' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123302'
                WHERE ordernumber = 'P200527114048600' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392376'
                WHERE ordernumber = 'P790527114139909' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200527114234216' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392375'
                WHERE ordernumber = 'P190527114313580' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318220'
                WHERE ordernumber = 'P180527114410213' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88518'
                WHERE ordernumber = 'P710527115708246' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365149'
                WHERE ordernumber = 'P180527115752524' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97662'
                WHERE ordernumber = 'P200527115950439' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392379'
                WHERE ordernumber = 'P420527120539855' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392380'
                WHERE ordernumber = 'P420527120941414' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392381'
                WHERE ordernumber = 'P420527121425258' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373451'
                WHERE ordernumber = 'P420527122232346' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630527122443853' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243405'
                WHERE ordernumber = 'P200527123009241' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392387'
                WHERE ordernumber = 'P790527123115410' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266014'
                WHERE ordernumber = 'P180527123835956' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167899'
                WHERE ordernumber = 'P420527124608358' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P420527124906895' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392391'
                WHERE ordernumber = 'P420527125310292' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392393'
                WHERE ordernumber = 'P200527125455874' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392395'
                WHERE ordernumber = 'P180527125638601' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392394'
                WHERE ordernumber = 'P420527125639760' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387761'
                WHERE ordernumber = 'P420527125750530' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392396'
                WHERE ordernumber = 'P200527125801877' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304703'
                WHERE ordernumber = 'P180527125920287' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '150084'
                WHERE ordernumber = 'P630527125943993' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392397'
                WHERE ordernumber = 'P200527130025885' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113763'
                WHERE ordernumber = 'P190527130026669' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231406'
                WHERE ordernumber = 'P180527130034198' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380082'
                WHERE ordernumber = 'P420527130321216' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99037'
                WHERE ordernumber = 'P180527130348620' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180527130649815' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '89018'
                WHERE ordernumber = 'P180527131055971' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392398'
                WHERE ordernumber = 'P710527131639368' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392402'
                WHERE ordernumber = 'P180527132607693' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279525'
                WHERE ordernumber = 'P180527133049795' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '265983'
                WHERE ordernumber = 'P180527133849643' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392406'
                WHERE ordernumber = 'P180527134347621' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352936'
                WHERE ordernumber = 'P420527134403815' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392409'
                WHERE ordernumber = 'P790527135226571' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250618'
                WHERE ordernumber = 'P200527135252582' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106032'
                WHERE ordernumber = 'P180527135554664' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392413'
                WHERE ordernumber = 'P180527140050960' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392414'
                WHERE ordernumber = 'P420527140244149' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246439'
                WHERE ordernumber = 'P420527140413489' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392414'
                WHERE ordernumber = 'P420527140536325' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392409'
                WHERE ordernumber = 'P790527140547297' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392415'
                WHERE ordernumber = 'P790527140735169' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390068'
                WHERE ordernumber = 'P200527140830462' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392417'
                WHERE ordernumber = 'P790527141108638' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382976'
                WHERE ordernumber = 'P420527141626519' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392419'
                WHERE ordernumber = 'P180527141801348' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324692'
                WHERE ordernumber = 'P180527142537820' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300802'
                WHERE ordernumber = 'P200527142607299' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277515'
                WHERE ordernumber = 'P180527142857280' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392424'
                WHERE ordernumber = 'P180527143150346' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180527143635526' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392428'
                WHERE ordernumber = 'P630527144024128' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389151'
                WHERE ordernumber = 'P420527144327214' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304047'
                WHERE ordernumber = 'P200527144412945' 
            
2024-05-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388897'
                WHERE ordernumber = 'P190527144459776' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123988'
                WHERE ordernumber = 'P180527144547639' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392427'
                WHERE ordernumber = 'P710527145112721' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143144'
                WHERE ordernumber = 'P200527145204742' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392431'
                WHERE ordernumber = 'P790527145635417' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104582'
                WHERE ordernumber = 'P200527145725708' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392431'
                WHERE ordernumber = 'P790527145815331' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301943'
                WHERE ordernumber = 'P630527150147232' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392433'
                WHERE ordernumber = 'P200527150154373' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392434'
                WHERE ordernumber = 'P180527150528321' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392435'
                WHERE ordernumber = 'P180527150732296' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86775'
                WHERE ordernumber = 'P190527150759289' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P180527151041250' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '150210'
                WHERE ordernumber = 'P710527151154307' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390524'
                WHERE ordernumber = 'P420527151243808' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392410'
                WHERE ordernumber = 'P420527151901837' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281421'
                WHERE ordernumber = 'P200527152051342' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310062'
                WHERE ordernumber = 'P180527152517870' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380173'
                WHERE ordernumber = 'P420527153257525' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350304'
                WHERE ordernumber = 'P200527153337780' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228035'
                WHERE ordernumber = 'P180527153506391' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391875'
                WHERE ordernumber = 'P190527153608515' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392441'
                WHERE ordernumber = 'P710527154321799' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389801'
                WHERE ordernumber = 'P200527154328636' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392443'
                WHERE ordernumber = 'P710527154624236' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392445'
                WHERE ordernumber = 'P180527154739848' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392447'
                WHERE ordernumber = 'P420527154828338' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392444'
                WHERE ordernumber = 'P200527154939537' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392450'
                WHERE ordernumber = 'P200527155200504' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392451'
                WHERE ordernumber = 'P180527155240177' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392452'
                WHERE ordernumber = 'P200527155346493' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239799'
                WHERE ordernumber = 'P180527155559423' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159656'
                WHERE ordernumber = 'P630527155652755' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89059'
                WHERE ordernumber = 'P200527155740221' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392454'
                WHERE ordernumber = 'P190527160324325' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111127'
                WHERE ordernumber = 'P180527160453239' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326714'
                WHERE ordernumber = 'P180527160646245' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392456'
                WHERE ordernumber = 'P190527160812833' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335266'
                WHERE ordernumber = 'P190527161100975' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392457'
                WHERE ordernumber = 'P200527161244909' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392458'
                WHERE ordernumber = 'P180527161410708' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392460'
                WHERE ordernumber = 'P200527161729692' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P180527162610786' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390553'
                WHERE ordernumber = 'P420527162728169' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392462'
                WHERE ordernumber = 'P200527162903847' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383322'
                WHERE ordernumber = 'P180527162918641' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392463'
                WHERE ordernumber = 'P710527163133645' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392464'
                WHERE ordernumber = 'P180527163151376' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392465'
                WHERE ordernumber = 'P420527163534386' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392466'
                WHERE ordernumber = 'P200527163558985' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99632'
                WHERE ordernumber = 'P180527163707557' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392469'
                WHERE ordernumber = 'P180527165014519' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374891'
                WHERE ordernumber = 'P420527165032122' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392470'
                WHERE ordernumber = 'P790527165239622' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392471'
                WHERE ordernumber = 'P180527165543166' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327888'
                WHERE ordernumber = 'P190527165633741' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392423'
                WHERE ordernumber = 'P180527165643768' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307900'
                WHERE ordernumber = 'P180527165928573' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286168'
                WHERE ordernumber = 'P200527170106574' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387499'
                WHERE ordernumber = 'P180527170249703' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279648'
                WHERE ordernumber = 'P180527170418980' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392474'
                WHERE ordernumber = 'P190527170932255' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391990'
                WHERE ordernumber = 'P180527171443868' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392476'
                WHERE ordernumber = 'P190527171750769' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392478'
                WHERE ordernumber = 'P180527171925839' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341905'
                WHERE ordernumber = 'P190527171934233' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P180527172135752' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392479'
                WHERE ordernumber = 'P200527172335939' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392480'
                WHERE ordernumber = 'P180527172901837' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252616'
                WHERE ordernumber = 'P420527172936334' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392482'
                WHERE ordernumber = 'P200527173610971' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392481'
                WHERE ordernumber = 'P180527173612498' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392483'
                WHERE ordernumber = 'P790527173631299' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392484'
                WHERE ordernumber = 'P200527173831260' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92952'
                WHERE ordernumber = 'P790527173926200' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392486'
                WHERE ordernumber = 'P180527174118470' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392487'
                WHERE ordernumber = 'P200527174148225' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387149'
                WHERE ordernumber = 'P180527174413201' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138998'
                WHERE ordernumber = 'P200527174437847' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247834'
                WHERE ordernumber = 'P180527174825125' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392488'
                WHERE ordernumber = 'P200527175131518' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392489'
                WHERE ordernumber = 'P200527175242612' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377560'
                WHERE ordernumber = 'P710527175710499' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217542'
                WHERE ordernumber = 'P420527175925959' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315530'
                WHERE ordernumber = 'P200527175953731' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392491'
                WHERE ordernumber = 'P200527180512409' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109901'
                WHERE ordernumber = 'P190527180517139' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392493'
                WHERE ordernumber = 'P180527181006355' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276738'
                WHERE ordernumber = 'P180527181346149' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392494'
                WHERE ordernumber = 'P790527181508347' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392495'
                WHERE ordernumber = 'P790527181827135' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392496'
                WHERE ordernumber = 'P790527182034517' 
            
2024-05-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319534'
                WHERE ordernumber = 'P420527182046658' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392497'
                WHERE ordernumber = 'P180527182152255' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391164'
                WHERE ordernumber = 'P190527182305245' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392498'
                WHERE ordernumber = 'P200527182334190' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169065'
                WHERE ordernumber = 'P180527182641450' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126094'
                WHERE ordernumber = 'P420527182911526' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126094'
                WHERE ordernumber = 'P420527182945818' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392399'
                WHERE ordernumber = 'P180527182953727' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392499'
                WHERE ordernumber = 'P710527183349999' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260961'
                WHERE ordernumber = 'P200527183812311' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392500'
                WHERE ordernumber = 'P200527184140806' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392501'
                WHERE ordernumber = 'P200527184309642' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310242'
                WHERE ordernumber = 'P200527184349994' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392502'
                WHERE ordernumber = 'P200527184738520' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392504'
                WHERE ordernumber = 'P200527184850435' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335266'
                WHERE ordernumber = 'P190527184940176' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93434'
                WHERE ordernumber = 'P790527185131511' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236370'
                WHERE ordernumber = 'P190527185309819' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392505'
                WHERE ordernumber = 'P200527190312683' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392436'
                WHERE ordernumber = 'P190527190325498' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392506'
                WHERE ordernumber = 'P190527190811386' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392507'
                WHERE ordernumber = 'P630527191121299' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236736'
                WHERE ordernumber = 'P200527191126222' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350224'
                WHERE ordernumber = 'P190527191556735' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '35479'
                WHERE ordernumber = 'P630527191759634' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355384'
                WHERE ordernumber = 'P200527192108491' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156496'
                WHERE ordernumber = 'P200527192157325' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355384'
                WHERE ordernumber = 'P200527192456968' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392510'
                WHERE ordernumber = 'P200527192852671' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392511'
                WHERE ordernumber = 'P200527193200424' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392313'
                WHERE ordernumber = 'P190527193308281' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200527193336473' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392313'
                WHERE ordernumber = 'P190527193527879' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304451'
                WHERE ordernumber = 'P420527193843304' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372068'
                WHERE ordernumber = 'P200527194015941' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392514'
                WHERE ordernumber = 'P200527194225402' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392514'
                WHERE ordernumber = 'P200527194413213' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392515'
                WHERE ordernumber = 'P200527194508293' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240060'
                WHERE ordernumber = 'P710527195049691' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392519'
                WHERE ordernumber = 'P710527195419883' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392524'
                WHERE ordernumber = 'P710527201551203' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337679'
                WHERE ordernumber = 'P710527203437223' 
            
2024-05-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392533'
                WHERE ordernumber = 'P710527214634833'