2024-08-20 01:00:02 -- 將會員中心id寫入data-lake
2024-08-20 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-08-19%';
        
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410422'
                WHERE ordernumber = 'P180819110149456' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410426'
                WHERE ordernumber = 'P180819110509800' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410427'
                WHERE ordernumber = 'P200819110556994' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394714'
                WHERE ordernumber = 'P180819110615649' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P190819110653835' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410428'
                WHERE ordernumber = 'P420819110942607' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410429'
                WHERE ordernumber = 'P420819111119670' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410430'
                WHERE ordernumber = 'P420819111216689' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240481'
                WHERE ordernumber = 'P180819111223546' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218966'
                WHERE ordernumber = 'P190819111254185' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410431'
                WHERE ordernumber = 'P420819111323635' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410427'
                WHERE ordernumber = 'P200819111327649' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410433'
                WHERE ordernumber = 'P420819111414459' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410435'
                WHERE ordernumber = 'P180819111603516' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410434'
                WHERE ordernumber = 'P200819111605853' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410436'
                WHERE ordernumber = 'P200819111741210' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410439'
                WHERE ordernumber = 'P180819111814891' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410440'
                WHERE ordernumber = 'P190819111852633' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408784'
                WHERE ordernumber = 'P200819112029881' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410442'
                WHERE ordernumber = 'P420819112126946' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410443'
                WHERE ordernumber = 'P180819112139938' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98396'
                WHERE ordernumber = 'P200819112313401' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365258'
                WHERE ordernumber = 'P420819112417433' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410448'
                WHERE ordernumber = 'P180819112548174' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410449'
                WHERE ordernumber = 'P190819112551767' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383419'
                WHERE ordernumber = 'P200819112831632' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410452'
                WHERE ordernumber = 'P420819112852658' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410453'
                WHERE ordernumber = 'P180819112910475' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410455'
                WHERE ordernumber = 'P420819113004572' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409580'
                WHERE ordernumber = 'P420819113249111' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281350'
                WHERE ordernumber = 'P190819113338503' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '260427'
                WHERE ordernumber = 'P200819114200689' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410465'
                WHERE ordernumber = 'P200819114721879' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406903'
                WHERE ordernumber = 'P420819115054884' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232145'
                WHERE ordernumber = 'P200819115203850' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232474'
                WHERE ordernumber = 'P180819115237345' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410472'
                WHERE ordernumber = 'P180819115447198' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245917'
                WHERE ordernumber = 'P190819115528677' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P180819115833319' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P180819120142165' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410475'
                WHERE ordernumber = 'P190819120243132' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410480'
                WHERE ordernumber = 'P180819120408989' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123595'
                WHERE ordernumber = 'P200819120533411' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276457'
                WHERE ordernumber = 'P180819121328587' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410483'
                WHERE ordernumber = 'P420819121525235' 
            
2024-08-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410484'
                WHERE ordernumber = 'P200819121539338' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410486'
                WHERE ordernumber = 'P180819121904727' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410489'
                WHERE ordernumber = 'P180819122025728' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410488'
                WHERE ordernumber = 'P190819122039899' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267799'
                WHERE ordernumber = 'P420819122058210' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380011'
                WHERE ordernumber = 'P180819122145656' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P420819122222737' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384251'
                WHERE ordernumber = 'P180819122339124' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410491'
                WHERE ordernumber = 'P180819122713322' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410495'
                WHERE ordernumber = 'P420819123133863' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410497'
                WHERE ordernumber = 'P190819123432289' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410498'
                WHERE ordernumber = 'P420819123506240' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410500'
                WHERE ordernumber = 'P200819123944223' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382707'
                WHERE ordernumber = 'P420819124146998' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396615'
                WHERE ordernumber = 'P180819124758375' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369193'
                WHERE ordernumber = 'P200819124819637' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39674'
                WHERE ordernumber = 'P630819125303957' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337408'
                WHERE ordernumber = 'P420819125421519' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410508'
                WHERE ordernumber = 'P420819125538262' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396952'
                WHERE ordernumber = 'P200819125604713' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122253'
                WHERE ordernumber = 'P180819125644797' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337408'
                WHERE ordernumber = 'P420819125857990' 
            
2024-08-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408340'
                WHERE ordernumber = 'P420819130044122' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410510'
                WHERE ordernumber = 'P200819130433588' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410511'
                WHERE ordernumber = 'P180819130508138' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100968'
                WHERE ordernumber = 'P200819130834645' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394396'
                WHERE ordernumber = 'P180819131629618' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410519'
                WHERE ordernumber = 'P200819132135991' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '52930'
                WHERE ordernumber = 'P200819132423185' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136082'
                WHERE ordernumber = 'P200819132519346' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339659'
                WHERE ordernumber = 'P200819132625535' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304667'
                WHERE ordernumber = 'P420819132722153' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410526'
                WHERE ordernumber = 'P180819133016894' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410529'
                WHERE ordernumber = 'P420819133145131' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285170'
                WHERE ordernumber = 'P180819133429339' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362641'
                WHERE ordernumber = 'P420819133908531' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410533'
                WHERE ordernumber = 'P420819134219635' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410534'
                WHERE ordernumber = 'P420819134901662' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218710'
                WHERE ordernumber = 'P200819135209597' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410536'
                WHERE ordernumber = 'P180819135329551' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410537'
                WHERE ordernumber = 'P420819135631992' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410542'
                WHERE ordernumber = 'P200819135834960' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312129'
                WHERE ordernumber = 'P420819135919260' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296543'
                WHERE ordernumber = 'P180819140013810' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410546'
                WHERE ordernumber = 'P420819140854967' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311532'
                WHERE ordernumber = 'P180819140911910' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410547'
                WHERE ordernumber = 'P200819141233220' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P200819141348690' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410551'
                WHERE ordernumber = 'P180819141643227' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P200819141722515' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '38925'
                WHERE ordernumber = 'P180819141905697' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410561'
                WHERE ordernumber = 'P180819143143875' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407521'
                WHERE ordernumber = 'P180819144028273' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '52612'
                WHERE ordernumber = 'P420819144139315' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218542'
                WHERE ordernumber = 'P190819144655730' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297738'
                WHERE ordernumber = 'P420819144917969' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389657'
                WHERE ordernumber = 'P180819144925643' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410569'
                WHERE ordernumber = 'P180819145048946' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128903'
                WHERE ordernumber = 'P180819145456400' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '21694'
                WHERE ordernumber = 'P420819145736991' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410572'
                WHERE ordernumber = 'P420819145943128' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410577'
                WHERE ordernumber = 'P420819150520496' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124083'
                WHERE ordernumber = 'P180819150804952' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P180819150849979' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410581'
                WHERE ordernumber = 'P180819151338663' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220067'
                WHERE ordernumber = 'P180819151549458' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287906'
                WHERE ordernumber = 'P180819151647361' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410586'
                WHERE ordernumber = 'P180819151905201' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410588'
                WHERE ordernumber = 'P200819152035958' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396673'
                WHERE ordernumber = 'P180819152351960' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319423'
                WHERE ordernumber = 'P200819152731692' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286322'
                WHERE ordernumber = 'P190819152954145' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410598'
                WHERE ordernumber = 'P180819153045220' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410596'
                WHERE ordernumber = 'P180819153252189' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410596'
                WHERE ordernumber = 'P180819153311220' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410386'
                WHERE ordernumber = 'P420819153348931' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410600'
                WHERE ordernumber = 'P180819153457492' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283096'
                WHERE ordernumber = 'P200819153736453' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410603'
                WHERE ordernumber = 'P180819153741603' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409345'
                WHERE ordernumber = 'P200819153834262' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410606'
                WHERE ordernumber = 'P200819154141970' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410607'
                WHERE ordernumber = 'P200819154231239' 
            
2024-08-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410609'
                WHERE ordernumber = 'P180819154420200' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410608'
                WHERE ordernumber = 'P420819154442560' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104125'
                WHERE ordernumber = 'P180819154818206' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352640'
                WHERE ordernumber = 'P420819155148434' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410613'
                WHERE ordernumber = 'P420819155436310' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410614'
                WHERE ordernumber = 'P180819155508770' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297325'
                WHERE ordernumber = 'P420819155535917' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410615'
                WHERE ordernumber = 'P180819155729229' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410616'
                WHERE ordernumber = 'P180819155845281' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280605'
                WHERE ordernumber = 'P180819160359425' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410620'
                WHERE ordernumber = 'P190819160720245' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410624'
                WHERE ordernumber = 'P180819160759917' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410422'
                WHERE ordernumber = 'P180819160851678' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410627'
                WHERE ordernumber = 'P200819161028791' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410628'
                WHERE ordernumber = 'P180819161140262' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410630'
                WHERE ordernumber = 'P420819161507752' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410633'
                WHERE ordernumber = 'P180819162045357' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410310'
                WHERE ordernumber = 'P180819162214186' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410631'
                WHERE ordernumber = 'P180819162337478' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '316793'
                WHERE ordernumber = 'P200819162851400' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313567'
                WHERE ordernumber = 'P180819163116143' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114042'
                WHERE ordernumber = 'P180819163508976' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410639'
                WHERE ordernumber = 'P180819163703337' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410646'
                WHERE ordernumber = 'P180819163906927' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324842'
                WHERE ordernumber = 'P420819164926597' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410655'
                WHERE ordernumber = 'P180819165310646' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276742'
                WHERE ordernumber = 'P180819170928144' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379765'
                WHERE ordernumber = 'P200819171045379' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344864'
                WHERE ordernumber = 'P180819171138892' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409490'
                WHERE ordernumber = 'P200819171230722' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326366'
                WHERE ordernumber = 'P420819171618113' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382135'
                WHERE ordernumber = 'P420819172051900' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410665'
                WHERE ordernumber = 'P180819172118331' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342097'
                WHERE ordernumber = 'P190819172132391' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410666'
                WHERE ordernumber = 'P180819172241559' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410669'
                WHERE ordernumber = 'P200819172811963' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382135'
                WHERE ordernumber = 'P420819172959769' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410670'
                WHERE ordernumber = 'P420819173106475' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '142114'
                WHERE ordernumber = 'P200819173718454' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398016'
                WHERE ordernumber = 'P200819173759216' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398016'
                WHERE ordernumber = 'P200819173903410' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173816'
                WHERE ordernumber = 'P200819173945141' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173816'
                WHERE ordernumber = 'P200819174028757' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410673'
                WHERE ordernumber = 'P180819174415120' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345359'
                WHERE ordernumber = 'P200819174508202' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388070'
                WHERE ordernumber = 'P180819174901252' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410677'
                WHERE ordernumber = 'P200819175257511' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410612'
                WHERE ordernumber = 'P200819175358395' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410678'
                WHERE ordernumber = 'P420819175403358' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410680'
                WHERE ordernumber = 'P200819175503168' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212722'
                WHERE ordernumber = 'P180819180309786' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297582'
                WHERE ordernumber = 'P420819180637165' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410686'
                WHERE ordernumber = 'P420819180914225' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401807'
                WHERE ordernumber = 'P180819180950522' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401807'
                WHERE ordernumber = 'P180819181146561' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405373'
                WHERE ordernumber = 'P420819181612842' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409969'
                WHERE ordernumber = 'P180819182636479' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '154622'
                WHERE ordernumber = 'P200819183713238' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410696'
                WHERE ordernumber = 'P180819183752910' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390214'
                WHERE ordernumber = 'P190819184437244' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410688'
                WHERE ordernumber = 'P180819184536980' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376504'
                WHERE ordernumber = 'P420819184651775' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372870'
                WHERE ordernumber = 'P180819185325962' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410705'
                WHERE ordernumber = 'P200819185845115' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410706'
                WHERE ordernumber = 'P190819185916459' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410707'
                WHERE ordernumber = 'P200819190200401' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410708'
                WHERE ordernumber = 'P190819190523581' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '147323'
                WHERE ordernumber = 'P200819190529443' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410709'
                WHERE ordernumber = 'P190819190636677' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277070'
                WHERE ordernumber = 'P190819190722987' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409645'
                WHERE ordernumber = 'P190819190807810' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410711'
                WHERE ordernumber = 'P190819191258715' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215040'
                WHERE ordernumber = 'P200819191311565' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282639'
                WHERE ordernumber = 'P200819191623176' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410713'
                WHERE ordernumber = 'P190819191655584' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410713'
                WHERE ordernumber = 'P190819191720150' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410717'
                WHERE ordernumber = 'P190819192021532' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96181'
                WHERE ordernumber = 'P190819192311575' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410719'
                WHERE ordernumber = 'P200819192356513' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410720'
                WHERE ordernumber = 'P190819192537993' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410726'
                WHERE ordernumber = 'P190819193144751' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351835'
                WHERE ordernumber = 'P190819193411989' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299012'
                WHERE ordernumber = 'P190819193734953' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410727'
                WHERE ordernumber = 'P190819193843446' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255995'
                WHERE ordernumber = 'P190819193940147' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338981'
                WHERE ordernumber = 'P190819194116946' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255995'
                WHERE ordernumber = 'P190819194156256' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410730'
                WHERE ordernumber = 'P200819194308498' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303533'
                WHERE ordernumber = 'P190819194454766' 
            
2024-08-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377794'
                WHERE ordernumber = 'P190819195109485' 
            
2024-08-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '379639'
                WHERE ordernumber = 'P200819195743335' 
            
2024-08-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405871'
                WHERE ordernumber = 'P630819211003522'