2024-05-16 01:00:01 -- 將會員中心id寫入data-lake
2024-05-16 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-15%';
        
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P420515110325803' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282746'
                WHERE ordernumber = 'P190515110430477' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231270'
                WHERE ordernumber = 'P200515110434804' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101754'
                WHERE ordernumber = 'P190515110559216' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390049'
                WHERE ordernumber = 'P180515110608485' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390050'
                WHERE ordernumber = 'P200515110642909' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390052'
                WHERE ordernumber = 'P180515110834633' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302188'
                WHERE ordernumber = 'P190515110900828' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390049'
                WHERE ordernumber = 'P180515111045715' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211362'
                WHERE ordernumber = 'P190515111559487' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390053'
                WHERE ordernumber = 'P180515111619292' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100896'
                WHERE ordernumber = 'P190515111737458' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245286'
                WHERE ordernumber = 'P200515112235964' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378584'
                WHERE ordernumber = 'P420515112243741' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390055'
                WHERE ordernumber = 'P180515112355212' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200515112408269' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140451'
                WHERE ordernumber = 'P190515112523980' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308934'
                WHERE ordernumber = 'P200515112728281' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289480'
                WHERE ordernumber = 'P190515113042528' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389629'
                WHERE ordernumber = 'P630515113332981' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '20'
                WHERE ordernumber = 'P190515113338760' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390057'
                WHERE ordernumber = 'P190515113744998' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387511'
                WHERE ordernumber = 'P420515114059654' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390055'
                WHERE ordernumber = 'P180515114105393' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390059'
                WHERE ordernumber = 'P190515114443196' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264478'
                WHERE ordernumber = 'P180515114835952' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '117640'
                WHERE ordernumber = 'P180515115653594' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390062'
                WHERE ordernumber = 'P200515115816516' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254447'
                WHERE ordernumber = 'P200515120324627' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374147'
                WHERE ordernumber = 'P180515120739353' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390063'
                WHERE ordernumber = 'P190515120838323' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212306'
                WHERE ordernumber = 'P200515121341322' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390065'
                WHERE ordernumber = 'P180515121349821' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390064'
                WHERE ordernumber = 'P790515121430296' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390066'
                WHERE ordernumber = 'P180515121744330' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390067'
                WHERE ordernumber = 'P200515121758679' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390066'
                WHERE ordernumber = 'P180515121817272' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390068'
                WHERE ordernumber = 'P200515121858526' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384079'
                WHERE ordernumber = 'P200515121933782' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390069'
                WHERE ordernumber = 'P420515122113441' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222670'
                WHERE ordernumber = 'P790515122811246' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390071'
                WHERE ordernumber = 'P420515123029940' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390072'
                WHERE ordernumber = 'P420515123447677' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388221'
                WHERE ordernumber = 'P420515123741866' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200515124225812' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390075'
                WHERE ordernumber = 'P180515124402286' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390076'
                WHERE ordernumber = 'P180515124849640' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390078'
                WHERE ordernumber = 'P200515125103397' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390080'
                WHERE ordernumber = 'P200515125236165' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390074'
                WHERE ordernumber = 'P790515125303618' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385619'
                WHERE ordernumber = 'P420515125352424' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390081'
                WHERE ordernumber = 'P180515125355211' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390082'
                WHERE ordernumber = 'P420515125524275' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214135'
                WHERE ordernumber = 'P630515125531187' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225266'
                WHERE ordernumber = 'P180515125906473' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390083'
                WHERE ordernumber = 'P420515130419549' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128881'
                WHERE ordernumber = 'P180515130725280' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236119'
                WHERE ordernumber = 'P200515130730883' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390086'
                WHERE ordernumber = 'P180515131339299' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300450'
                WHERE ordernumber = 'P200515131348904' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390087'
                WHERE ordernumber = 'P180515131623767' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299112'
                WHERE ordernumber = 'P420515131823758' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99659'
                WHERE ordernumber = 'P180515131917208' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390089'
                WHERE ordernumber = 'P180515132404401' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390090'
                WHERE ordernumber = 'P200515132538787' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390085'
                WHERE ordernumber = 'P180515132603370' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390085'
                WHERE ordernumber = 'P180515132630503' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390091'
                WHERE ordernumber = 'P200515132715654' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '117399'
                WHERE ordernumber = 'P630515132953355' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390093'
                WHERE ordernumber = 'P200515133125729' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373709'
                WHERE ordernumber = 'P200515133225638' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344099'
                WHERE ordernumber = 'P420515133228482' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390094'
                WHERE ordernumber = 'P630515133305464' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '148683'
                WHERE ordernumber = 'P180515133325172' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364639'
                WHERE ordernumber = 'P180515133644871' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180515134048131' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390097'
                WHERE ordernumber = 'P190515134308457' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390099'
                WHERE ordernumber = 'P420515134650603' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143048'
                WHERE ordernumber = 'P200515134725423' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73918'
                WHERE ordernumber = 'P180515134801125' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298177'
                WHERE ordernumber = 'P200515134921464' 
            
2024-05-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282424'
                WHERE ordernumber = 'P420515135331909' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390100'
                WHERE ordernumber = 'P180515135803898' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390101'
                WHERE ordernumber = 'P420515135937744' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358673'
                WHERE ordernumber = 'P190515140252531' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389854'
                WHERE ordernumber = 'P190515140536138' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P420515140705305' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390103'
                WHERE ordernumber = 'P630515140850373' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390105'
                WHERE ordernumber = 'P190515141009931' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390105'
                WHERE ordernumber = 'P190515141207159' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386257'
                WHERE ordernumber = 'P190515141456166' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386257'
                WHERE ordernumber = 'P190515141526217' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262644'
                WHERE ordernumber = 'P420515142840729' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367047'
                WHERE ordernumber = 'P180515142902496' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288089'
                WHERE ordernumber = 'P180515143606504' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390108'
                WHERE ordernumber = 'P630515144139133' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344731'
                WHERE ordernumber = 'P420515144437559' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303217'
                WHERE ordernumber = 'P180515144459350' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344731'
                WHERE ordernumber = 'P420515144823795' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380970'
                WHERE ordernumber = 'P630515144916222' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390109'
                WHERE ordernumber = 'P420515145038761' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390110'
                WHERE ordernumber = 'P180515145050357' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77985'
                WHERE ordernumber = 'P200515145259752' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390111'
                WHERE ordernumber = 'P180515145536747' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390112'
                WHERE ordernumber = 'P180515145716834' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268542'
                WHERE ordernumber = 'P180515145906286' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342736'
                WHERE ordernumber = 'P420515150018282' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390113'
                WHERE ordernumber = 'P180515150032268' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390114'
                WHERE ordernumber = 'P630515150250969' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390115'
                WHERE ordernumber = 'P180515150345145' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313240'
                WHERE ordernumber = 'P190515150939173' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279244'
                WHERE ordernumber = 'P180515151426884' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388807'
                WHERE ordernumber = 'P180515151945226' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384837'
                WHERE ordernumber = 'P420515151955593' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304786'
                WHERE ordernumber = 'P200515152325261' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384890'
                WHERE ordernumber = 'P420515152342262' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390116'
                WHERE ordernumber = 'P200515152632933' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385227'
                WHERE ordernumber = 'P420515152642316' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385218'
                WHERE ordernumber = 'P420515152916284' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359086'
                WHERE ordernumber = 'P190515153220633' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390119'
                WHERE ordernumber = 'P180515153410237' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390120'
                WHERE ordernumber = 'P630515153548127' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P180515153842258' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390121'
                WHERE ordernumber = 'P190515154042221' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390123'
                WHERE ordernumber = 'P180515154446223' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P420515154455430' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390127'
                WHERE ordernumber = 'P180515155544311' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346952'
                WHERE ordernumber = 'P180515155734339' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388988'
                WHERE ordernumber = 'P190515155936968' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390128'
                WHERE ordernumber = 'P180515160029462' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390129'
                WHERE ordernumber = 'P180515160457956' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388988'
                WHERE ordernumber = 'P190515160533831' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390125'
                WHERE ordernumber = 'P200515161039478' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239979'
                WHERE ordernumber = 'P190515161107672' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385800'
                WHERE ordernumber = 'P420515161208298' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390128'
                WHERE ordernumber = 'P180515161300971' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390133'
                WHERE ordernumber = 'P200515161420817' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383672'
                WHERE ordernumber = 'P180515161853891' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206434'
                WHERE ordernumber = 'P180515162029864' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108309'
                WHERE ordernumber = 'P180515162322950' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390134'
                WHERE ordernumber = 'P190515162356413' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390135'
                WHERE ordernumber = 'P200515162529128' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390136'
                WHERE ordernumber = 'P200515162852474' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385825'
                WHERE ordernumber = 'P180515162930352' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388694'
                WHERE ordernumber = 'P420515163026224' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216124'
                WHERE ordernumber = 'P180515163208623' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390137'
                WHERE ordernumber = 'P420515163527171' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390138'
                WHERE ordernumber = 'P180515163652408' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390139'
                WHERE ordernumber = 'P190515163701656' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304574'
                WHERE ordernumber = 'P180515163813313' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377003'
                WHERE ordernumber = 'P630515163815465' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P590515163910403' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299568'
                WHERE ordernumber = 'P420515164326281' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390140'
                WHERE ordernumber = 'P200515165239324' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299744'
                WHERE ordernumber = 'P200515165417956' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P180515165514969' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390141'
                WHERE ordernumber = 'P630515165943388' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390142'
                WHERE ordernumber = 'P420515170123428' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230554'
                WHERE ordernumber = 'P180515170136229' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390144'
                WHERE ordernumber = 'P420515170950143' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390145'
                WHERE ordernumber = 'P180515171050668' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390147'
                WHERE ordernumber = 'P420515172221213' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93434'
                WHERE ordernumber = 'P790515172400298' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390150'
                WHERE ordernumber = 'P180515172823694' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390149'
                WHERE ordernumber = 'P420515172831277' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390151'
                WHERE ordernumber = 'P190515173134343' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100154'
                WHERE ordernumber = 'P630515173154121' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390148'
                WHERE ordernumber = 'P630515173453585' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100154'
                WHERE ordernumber = 'P630515173542638' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390148'
                WHERE ordernumber = 'P630515173835511' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289735'
                WHERE ordernumber = 'P180515173853527' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294717'
                WHERE ordernumber = 'P790515173858684' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390154'
                WHERE ordernumber = 'P200515174221863' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '178469'
                WHERE ordernumber = 'P420515174723427' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390155'
                WHERE ordernumber = 'P180515174822149' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379753'
                WHERE ordernumber = 'P190515175129344' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294984'
                WHERE ordernumber = 'P630515175741995' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364669'
                WHERE ordernumber = 'P420515180222470' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351066'
                WHERE ordernumber = 'P420515180531798' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390158'
                WHERE ordernumber = 'P190515180701882' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390159'
                WHERE ordernumber = 'P190515181012345' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296683'
                WHERE ordernumber = 'P200515181242368' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282267'
                WHERE ordernumber = 'P420515181403662' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281945'
                WHERE ordernumber = 'P200515181707274' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127747'
                WHERE ordernumber = 'P200515181806960' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161984'
                WHERE ordernumber = 'P420515181840289' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390160'
                WHERE ordernumber = 'P190515182441615' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228043'
                WHERE ordernumber = 'P180515182746983' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190515182841493' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390161'
                WHERE ordernumber = 'P180515182945913' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390162'
                WHERE ordernumber = 'P180515183118544' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390163'
                WHERE ordernumber = 'P190515183328405' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390164'
                WHERE ordernumber = 'P420515184015319' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '150183'
                WHERE ordernumber = 'P190515184329238' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239464'
                WHERE ordernumber = 'P200515184338295' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134240'
                WHERE ordernumber = 'P190515184406469' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260572'
                WHERE ordernumber = 'P190515184656354' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390165'
                WHERE ordernumber = 'P630515184701115' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390165'
                WHERE ordernumber = 'P630515184712153' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304245'
                WHERE ordernumber = 'P420515185050872' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390166'
                WHERE ordernumber = 'P420515185644538' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390167'
                WHERE ordernumber = 'P630515185715436' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390169'
                WHERE ordernumber = 'P190515190020780' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390170'
                WHERE ordernumber = 'P190515190220152' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390171'
                WHERE ordernumber = 'P190515190612821' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380474'
                WHERE ordernumber = 'P190515190738823' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165497'
                WHERE ordernumber = 'P190515190856618' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390172'
                WHERE ordernumber = 'P190515191145391' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254281'
                WHERE ordernumber = 'P590515191200180' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390173'
                WHERE ordernumber = 'P630515191217304' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248050'
                WHERE ordernumber = 'P200515191254224' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390174'
                WHERE ordernumber = 'P190515191916190' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200515191927349' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390175'
                WHERE ordernumber = 'P190515192124289' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277089'
                WHERE ordernumber = 'P190515192504981' 
            
2024-05-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390176'
                WHERE ordernumber = 'P630515192545746' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355741'
                WHERE ordernumber = 'P190515192636297' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390177'
                WHERE ordernumber = 'P190515192752171' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390178'
                WHERE ordernumber = 'P420515192756150' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '67428'
                WHERE ordernumber = 'P420515193016834' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256216'
                WHERE ordernumber = 'P190515193025250' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320952'
                WHERE ordernumber = 'P190515193232466' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334644'
                WHERE ordernumber = 'P200515193307806' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390180'
                WHERE ordernumber = 'P190515193545920' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283759'
                WHERE ordernumber = 'P630515193728844' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P200515194418786' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390181'
                WHERE ordernumber = 'P790515195014994' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390183'
                WHERE ordernumber = 'P630515195059796' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390184'
                WHERE ordernumber = 'P420515195502392' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390185'
                WHERE ordernumber = 'P630515195645877' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390187'
                WHERE ordernumber = 'P630515202936545' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '37630'
                WHERE ordernumber = 'P630515204141146' 
            
2024-05-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382646'
                WHERE ordernumber = 'P630515204519929'