2024-07-16 01:00:03 -- 將會員中心id寫入data-lake
2024-07-16 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-07-15%';
        
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401386'
                WHERE ordernumber = 'P190715110202319' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200715110341726' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401387'
                WHERE ordernumber = 'P200715110542190' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236193'
                WHERE ordernumber = 'P180715110825200' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399133'
                WHERE ordernumber = 'P420715111149609' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401390'
                WHERE ordernumber = 'P180715111323450' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322722'
                WHERE ordernumber = 'P200715111520975' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401391'
                WHERE ordernumber = 'P420715111537309' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '65879'
                WHERE ordernumber = 'P180715111545558' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384016'
                WHERE ordernumber = 'P630715111637391' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401392'
                WHERE ordernumber = 'P180715111740605' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82923'
                WHERE ordernumber = 'P190715111938690' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401393'
                WHERE ordernumber = 'P180715111941856' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284067'
                WHERE ordernumber = 'P180715112159632' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397148'
                WHERE ordernumber = 'P180715112438151' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180715112542166' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233964'
                WHERE ordernumber = 'P200715113143581' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401398'
                WHERE ordernumber = 'P180715114233220' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401400'
                WHERE ordernumber = 'P200715114400405' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378832'
                WHERE ordernumber = 'P200715114854740' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298474'
                WHERE ordernumber = 'P420715114955714' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401401'
                WHERE ordernumber = 'P200715115112152' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401402'
                WHERE ordernumber = 'P180715115144270' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401403'
                WHERE ordernumber = 'P180715115512731' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142572'
                WHERE ordernumber = 'P180715120220713' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382088'
                WHERE ordernumber = 'P180715120403293' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124039'
                WHERE ordernumber = 'P200715120440928' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119949'
                WHERE ordernumber = 'P180715120456707' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119949'
                WHERE ordernumber = 'P180715120527549' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266358'
                WHERE ordernumber = 'P180715120656551' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401404'
                WHERE ordernumber = 'P200715121235163' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94071'
                WHERE ordernumber = 'P180715121331819' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243902'
                WHERE ordernumber = 'P200715121340123' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162580'
                WHERE ordernumber = 'P190715121344312' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266358'
                WHERE ordernumber = 'P190715121447155' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P590715121714354' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274867'
                WHERE ordernumber = 'P200715122005343' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227276'
                WHERE ordernumber = 'P200715122501396' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400870'
                WHERE ordernumber = 'P420715123135775' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273154'
                WHERE ordernumber = 'P180715123503453' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396453'
                WHERE ordernumber = 'P180715123548336' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401406'
                WHERE ordernumber = 'P180715123743780' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260148'
                WHERE ordernumber = 'P420715123913486' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319029'
                WHERE ordernumber = 'P180715124222865' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342496'
                WHERE ordernumber = 'P420715124330509' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359260'
                WHERE ordernumber = 'P180715124936890' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90577'
                WHERE ordernumber = 'P590715125345886' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401410'
                WHERE ordernumber = 'P200715125712313' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P200715125909570' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324640'
                WHERE ordernumber = 'P180715130443865' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305697'
                WHERE ordernumber = 'P180715130811174' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400768'
                WHERE ordernumber = 'P200715131230189' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401413'
                WHERE ordernumber = 'P180715131500700' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398005'
                WHERE ordernumber = 'P420715131838571' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379221'
                WHERE ordernumber = 'P200715132349790' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137367'
                WHERE ordernumber = 'P180715132438974' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136082'
                WHERE ordernumber = 'P200715132617576' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385067'
                WHERE ordernumber = 'P180715134204417' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384839'
                WHERE ordernumber = 'P180715134310663' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401418'
                WHERE ordernumber = 'P180715134431757' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299658'
                WHERE ordernumber = 'P200715134435437' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400939'
                WHERE ordernumber = 'P180715134629459' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120896'
                WHERE ordernumber = 'P200715134939588' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401420'
                WHERE ordernumber = 'P200715135230963' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P180715135649985' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401422'
                WHERE ordernumber = 'P420715135745487' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401426'
                WHERE ordernumber = 'P200715141047268' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401427'
                WHERE ordernumber = 'P180715141052309' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401429'
                WHERE ordernumber = 'P200715141509475' 
            
2024-07-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384839'
                WHERE ordernumber = 'P180715142020631' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P200715142420917' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137905'
                WHERE ordernumber = 'P200715142629593' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401431'
                WHERE ordernumber = 'P420715142705424' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396609'
                WHERE ordernumber = 'P180715142733430' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P180715143011299' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401432'
                WHERE ordernumber = 'P180715143600280' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400840'
                WHERE ordernumber = 'P200715144247601' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128430'
                WHERE ordernumber = 'P180715144350836' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401436'
                WHERE ordernumber = 'P180715145720949' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401437'
                WHERE ordernumber = 'P420715145813123' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P180715150244838' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401438'
                WHERE ordernumber = 'P180715151046491' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127795'
                WHERE ordernumber = 'P180715151332647' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401440'
                WHERE ordernumber = 'P180715151455863' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401441'
                WHERE ordernumber = 'P180715151552363' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401442'
                WHERE ordernumber = 'P180715151645730' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401443'
                WHERE ordernumber = 'P180715151740705' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247991'
                WHERE ordernumber = 'P180715151818611' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401444'
                WHERE ordernumber = 'P180715152626336' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '370761'
                WHERE ordernumber = 'P180715153630315' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401446'
                WHERE ordernumber = 'P200715154154256' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401448'
                WHERE ordernumber = 'P180715154740346' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287203'
                WHERE ordernumber = 'P200715155047967' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401452'
                WHERE ordernumber = 'P200715155824127' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307282'
                WHERE ordernumber = 'P180715155911906' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401453'
                WHERE ordernumber = 'P180715160230542' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367207'
                WHERE ordernumber = 'P180715160421471' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113502'
                WHERE ordernumber = 'P190715160509434' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401454'
                WHERE ordernumber = 'P420715160907774' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169018'
                WHERE ordernumber = 'P190715161057528' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377733'
                WHERE ordernumber = 'P420715161459941' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254016'
                WHERE ordernumber = 'P200715161753442' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318474'
                WHERE ordernumber = 'P180715162026877' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398583'
                WHERE ordernumber = 'P180715162131975' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P200715162235624' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401456'
                WHERE ordernumber = 'P180715162323126' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401455'
                WHERE ordernumber = 'P190715162343367' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401457'
                WHERE ordernumber = 'P200715162356495' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400503'
                WHERE ordernumber = 'P420715163123366' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '162606'
                WHERE ordernumber = 'P180715163926732' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '162606'
                WHERE ordernumber = 'P180715164005766' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401459'
                WHERE ordernumber = 'P180715164135822' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369838'
                WHERE ordernumber = 'P200715164236662' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '182709'
                WHERE ordernumber = 'P420715164407319' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400773'
                WHERE ordernumber = 'P180715164653480' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229255'
                WHERE ordernumber = 'P190715165109440' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396769'
                WHERE ordernumber = 'P200715165427974' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285084'
                WHERE ordernumber = 'P190715165618847' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324033'
                WHERE ordernumber = 'P180715170230962' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401460'
                WHERE ordernumber = 'P190715170256285' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401461'
                WHERE ordernumber = 'P180715170342171' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397025'
                WHERE ordernumber = 'P420715171107513' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401462'
                WHERE ordernumber = 'P200715171702955' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401463'
                WHERE ordernumber = 'P180715171718499' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401464'
                WHERE ordernumber = 'P420715171756360' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401465'
                WHERE ordernumber = 'P180715171824632' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P630715172021194' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401466'
                WHERE ordernumber = 'P200715172319967' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360375'
                WHERE ordernumber = 'P420715172426977' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331990'
                WHERE ordernumber = 'P420715173016240' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401467'
                WHERE ordernumber = 'P180715173135585' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377755'
                WHERE ordernumber = 'P180715173214148' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401468'
                WHERE ordernumber = 'P190715173259820' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '120335'
                WHERE ordernumber = 'P180715173331636' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349590'
                WHERE ordernumber = 'P180715173439648' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346050'
                WHERE ordernumber = 'P200715174512601' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401472'
                WHERE ordernumber = 'P180715174753188' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P180715175501626' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '363339'
                WHERE ordernumber = 'P200715175558936' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329340'
                WHERE ordernumber = 'P200715175848518' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401476'
                WHERE ordernumber = 'P420715180024419' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396711'
                WHERE ordernumber = 'P180715180242297' 
            
2024-07-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '252901'
                WHERE ordernumber = 'P200715180434847' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401477'
                WHERE ordernumber = 'P180715180620733' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401478'
                WHERE ordernumber = 'P180715180829775' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401480'
                WHERE ordernumber = 'P180715181602593' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '115636'
                WHERE ordernumber = 'P180715181712804' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '164997'
                WHERE ordernumber = 'P200715181931338' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '6411'
                WHERE ordernumber = 'P180715181946592' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '267869'
                WHERE ordernumber = 'P200715182646917' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401481'
                WHERE ordernumber = 'P180715182920602' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '208371'
                WHERE ordernumber = 'P180715183647911' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401482'
                WHERE ordernumber = 'P420715184002886' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401483'
                WHERE ordernumber = 'P180715184438457' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346050'
                WHERE ordernumber = 'P590715184600795' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401485'
                WHERE ordernumber = 'P190715185659336' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '287188'
                WHERE ordernumber = 'P190715190213780' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '102353'
                WHERE ordernumber = 'P200715190509285' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '272144'
                WHERE ordernumber = 'P190715190550479' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '272144'
                WHERE ordernumber = 'P190715190637231' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386595'
                WHERE ordernumber = 'P200715190932196' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '216159'
                WHERE ordernumber = 'P200715191046617' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401486'
                WHERE ordernumber = 'P200715191137237' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '240937'
                WHERE ordernumber = 'P190715191159619' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '104188'
                WHERE ordernumber = 'P190715191259638' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401487'
                WHERE ordernumber = 'P190715191412751' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '390006'
                WHERE ordernumber = 'P190715192651816' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '354370'
                WHERE ordernumber = 'P630715192748682' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '278362'
                WHERE ordernumber = 'P190715192903728' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '311660'
                WHERE ordernumber = 'P190715193034636' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401489'
                WHERE ordernumber = 'P190715193312369' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401488'
                WHERE ordernumber = 'P200715193312640' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '212833'
                WHERE ordernumber = 'P200715194832247' 
            
2024-07-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '385853'
                WHERE ordernumber = 'P190715195831938'