2024-08-03 01:00:03 -- 將會員中心id寫入data-lake
2024-08-03 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-08-02%';
        
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242022'
                WHERE ordernumber = 'P630802101913271' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389388'
                WHERE ordernumber = 'P180802110146804' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397340'
                WHERE ordernumber = 'P200802110240349' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67650'
                WHERE ordernumber = 'P200802110704419' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404714'
                WHERE ordernumber = 'P180802110733826' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404716'
                WHERE ordernumber = 'P180802110936622' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369354'
                WHERE ordernumber = 'P420802111017949' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404722'
                WHERE ordernumber = 'P180802111730249' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404723'
                WHERE ordernumber = 'P180802112018632' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378054'
                WHERE ordernumber = 'P200802112024410' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376634'
                WHERE ordernumber = 'P180802112125783' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404717'
                WHERE ordernumber = 'P180802112730756' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385942'
                WHERE ordernumber = 'P200802112913528' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363894'
                WHERE ordernumber = 'P190802113017533' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305335'
                WHERE ordernumber = 'P180802113040199' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156751'
                WHERE ordernumber = 'P190802113102664' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63274'
                WHERE ordernumber = 'P200802113203117' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375388'
                WHERE ordernumber = 'P200802113239457' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404727'
                WHERE ordernumber = 'P180802113305189' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404729'
                WHERE ordernumber = 'P180802113447325' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227602'
                WHERE ordernumber = 'P190802113709706' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312010'
                WHERE ordernumber = 'P190802113751729' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116232'
                WHERE ordernumber = 'P180802113859572' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404730'
                WHERE ordernumber = 'P420802114047148' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402239'
                WHERE ordernumber = 'P420802114158553' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404732'
                WHERE ordernumber = 'P420802114835615' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404734'
                WHERE ordernumber = 'P180802114939462' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383596'
                WHERE ordernumber = 'P200802115135870' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '50964'
                WHERE ordernumber = 'P180802115301574' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271195'
                WHERE ordernumber = 'P190802115550489' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404737'
                WHERE ordernumber = 'P180802115621467' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41125'
                WHERE ordernumber = 'P180802115913613' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392980'
                WHERE ordernumber = 'P180802120129280' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124724'
                WHERE ordernumber = 'P180802120326523' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420802120531651' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319393'
                WHERE ordernumber = 'P420802120637882' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240419'
                WHERE ordernumber = 'P180802120814182' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289705'
                WHERE ordernumber = 'P180802120856594' 
            
2024-08-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404739'
                WHERE ordernumber = 'P200802121004375' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149383'
                WHERE ordernumber = 'P200802121100461' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102172'
                WHERE ordernumber = 'P180802121233498' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404741'
                WHERE ordernumber = 'P200802121727511' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139543'
                WHERE ordernumber = 'P200802122404557' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404743'
                WHERE ordernumber = 'P420802122623294' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118642'
                WHERE ordernumber = 'P180802122709300' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404746'
                WHERE ordernumber = 'P420802123133725' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404748'
                WHERE ordernumber = 'P180802123547590' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404009'
                WHERE ordernumber = 'P200802123610861' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404749'
                WHERE ordernumber = 'P420802123717990' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404475'
                WHERE ordernumber = 'P200802125717797' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404291'
                WHERE ordernumber = 'P200802130353917' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167164'
                WHERE ordernumber = 'P200802130858474' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301382'
                WHERE ordernumber = 'P180802131010761' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404751'
                WHERE ordernumber = 'P420802131056951' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404752'
                WHERE ordernumber = 'P200802131121801' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404754'
                WHERE ordernumber = 'P180802132513391' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130736'
                WHERE ordernumber = 'P180802132853540' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401632'
                WHERE ordernumber = 'P420802132943924' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404756'
                WHERE ordernumber = 'P420802133400931' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404623'
                WHERE ordernumber = 'P190802134031204' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404758'
                WHERE ordernumber = 'P200802134112802' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404759'
                WHERE ordernumber = 'P190802134156696' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339663'
                WHERE ordernumber = 'P420802134442716' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404760'
                WHERE ordernumber = 'P190802134529908' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404761'
                WHERE ordernumber = 'P200802134605296' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339402'
                WHERE ordernumber = 'P190802135038542' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404766'
                WHERE ordernumber = 'P420802135348484' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312510'
                WHERE ordernumber = 'P630802135550562' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404768'
                WHERE ordernumber = 'P190802135826458' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404772'
                WHERE ordernumber = 'P200802140749434' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390221'
                WHERE ordernumber = 'P200802141009914' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404774'
                WHERE ordernumber = 'P200802141219312' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404775'
                WHERE ordernumber = 'P180802141608462' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355601'
                WHERE ordernumber = 'P180802141652205' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159220'
                WHERE ordernumber = 'P200802141911175' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404777'
                WHERE ordernumber = 'P420802142033391' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243220'
                WHERE ordernumber = 'P180802142623600' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394746'
                WHERE ordernumber = 'P420802142719395' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394746'
                WHERE ordernumber = 'P420802142845458' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404779'
                WHERE ordernumber = 'P420802143108758' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273883'
                WHERE ordernumber = 'P200802143258489' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404780'
                WHERE ordernumber = 'P180802143735200' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241932'
                WHERE ordernumber = 'P200802143809963' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404783'
                WHERE ordernumber = 'P180802144152875' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231698'
                WHERE ordernumber = 'P180802144311524' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272613'
                WHERE ordernumber = 'P420802144802399' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404786'
                WHERE ordernumber = 'P200802145001951' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404788'
                WHERE ordernumber = 'P420802145317438' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404789'
                WHERE ordernumber = 'P420802145441555' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221657'
                WHERE ordernumber = 'P200802150250411' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '196365'
                WHERE ordernumber = 'P180802150506874' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404790'
                WHERE ordernumber = 'P180802150608121' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404791'
                WHERE ordernumber = 'P180802150714457' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404790'
                WHERE ordernumber = 'P180802150755475' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P420802151026497' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214333'
                WHERE ordernumber = 'P190802151447383' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98414'
                WHERE ordernumber = 'P200802151525617' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P420802151708259' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344645'
                WHERE ordernumber = 'P180802152333386' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404798'
                WHERE ordernumber = 'P190802152604770' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404800'
                WHERE ordernumber = 'P420802153103734' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403113'
                WHERE ordernumber = 'P180802153254948' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397025'
                WHERE ordernumber = 'P420802153416218' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P180802153428947' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120930'
                WHERE ordernumber = 'P200802153624817' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404801'
                WHERE ordernumber = 'P200802153749158' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404802'
                WHERE ordernumber = 'P200802153919715' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383099'
                WHERE ordernumber = 'P180802154606902' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352244'
                WHERE ordernumber = 'P420802154659246' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404805'
                WHERE ordernumber = 'P180802154952133' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404807'
                WHERE ordernumber = 'P420802155512175' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299480'
                WHERE ordernumber = 'P180802155827832' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276579'
                WHERE ordernumber = 'P180802155935918' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268582'
                WHERE ordernumber = 'P420802155938812' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403245'
                WHERE ordernumber = 'P200802160011762' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364063'
                WHERE ordernumber = 'P200802160601649' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404811'
                WHERE ordernumber = 'P180802160714836' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342844'
                WHERE ordernumber = 'P420802160748373' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297135'
                WHERE ordernumber = 'P420802161338902' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404816'
                WHERE ordernumber = 'P180802162220220' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404818'
                WHERE ordernumber = 'P200802162743281' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304578'
                WHERE ordernumber = 'P200802163200239' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404316'
                WHERE ordernumber = 'P200802163423124' 
            
2024-08-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404316'
                WHERE ordernumber = 'P200802163509847' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404822'
                WHERE ordernumber = 'P200802163623810' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P180802163807502' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334012'
                WHERE ordernumber = 'P200802163901421' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346610'
                WHERE ordernumber = 'P190802164217959' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404824'
                WHERE ordernumber = 'P200802164426122' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '109535'
                WHERE ordernumber = 'P180802164508759' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '109535'
                WHERE ordernumber = 'P180802164845597' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404826'
                WHERE ordernumber = 'P420802165510881' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404826'
                WHERE ordernumber = 'P420802165722814' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '44959'
                WHERE ordernumber = 'P420802170038329' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401918'
                WHERE ordernumber = 'P420802170704191' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392641'
                WHERE ordernumber = 'P180802170828270' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404829'
                WHERE ordernumber = 'P200802171029287' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404829'
                WHERE ordernumber = 'P200802171043540' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404831'
                WHERE ordernumber = 'P200802171223190' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404832'
                WHERE ordernumber = 'P180802171905910' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368242'
                WHERE ordernumber = 'P200802172327942' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280431'
                WHERE ordernumber = 'P180802172347119' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404834'
                WHERE ordernumber = 'P200802172458588' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404835'
                WHERE ordernumber = 'P200802172548772' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404697'
                WHERE ordernumber = 'P420802173450691' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404837'
                WHERE ordernumber = 'P200802173516828' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404838'
                WHERE ordernumber = 'P200802173835960' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338556'
                WHERE ordernumber = 'P180802173947532' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '250500'
                WHERE ordernumber = 'P200802174133274' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369909'
                WHERE ordernumber = 'P180802174315661' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404839'
                WHERE ordernumber = 'P420802174703597' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404843'
                WHERE ordernumber = 'P420802174811972' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404845'
                WHERE ordernumber = 'P420802175135874' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237030'
                WHERE ordernumber = 'P200802175435915' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404846'
                WHERE ordernumber = 'P200802175656928' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404847'
                WHERE ordernumber = 'P200802180518911' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404848'
                WHERE ordernumber = 'P200802180711693' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404850'
                WHERE ordernumber = 'P200802180951121' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318466'
                WHERE ordernumber = 'P200802181039663' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404851'
                WHERE ordernumber = 'P200802181204418' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404852'
                WHERE ordernumber = 'P180802181225304' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311672'
                WHERE ordernumber = 'P180802181428679' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317103'
                WHERE ordernumber = 'P180802181525269' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404853'
                WHERE ordernumber = 'P180802181708675' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297222'
                WHERE ordernumber = 'P630802181841864' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404855'
                WHERE ordernumber = 'P200802182059602' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404856'
                WHERE ordernumber = 'P200802182350267' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404810'
                WHERE ordernumber = 'P630802182450132' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214505'
                WHERE ordernumber = 'P180802182531422' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350391'
                WHERE ordernumber = 'P200802182545401' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270346'
                WHERE ordernumber = 'P200802182654389' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404857'
                WHERE ordernumber = 'P180802182904712' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404858'
                WHERE ordernumber = 'P420802183008973' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404855'
                WHERE ordernumber = 'P200802183026150' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281658'
                WHERE ordernumber = 'P420802183128222' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404859'
                WHERE ordernumber = 'P180802183139912' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402453'
                WHERE ordernumber = 'P200802183151556' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404860'
                WHERE ordernumber = 'P420802183323899' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228991'
                WHERE ordernumber = 'P180802183550346' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404861'
                WHERE ordernumber = 'P180802183800422' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '177218'
                WHERE ordernumber = 'P420802184026892' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379300'
                WHERE ordernumber = 'P420802184119689' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94993'
                WHERE ordernumber = 'P200802184521424' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285080'
                WHERE ordernumber = 'P200802184622632' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P180802185002403' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404864'
                WHERE ordernumber = 'P420802185041555' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404863'
                WHERE ordernumber = 'P200802185045272' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305029'
                WHERE ordernumber = 'P420802185131556' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '4'
                WHERE ordernumber = 'P180802185335702' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404865'
                WHERE ordernumber = 'P420802185423530' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297950'
                WHERE ordernumber = 'P180802185511771' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390625'
                WHERE ordernumber = 'P420802190058490' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383615'
                WHERE ordernumber = 'P190802190403556' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '138855'
                WHERE ordernumber = 'P200802190515236' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404866'
                WHERE ordernumber = 'P200802191417599' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271033'
                WHERE ordernumber = 'P200802191451217' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102144'
                WHERE ordernumber = 'P200802191557702' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337854'
                WHERE ordernumber = 'P200802191730148' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270523'
                WHERE ordernumber = 'P590802191803130' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311433'
                WHERE ordernumber = 'P200802191902651' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404868'
                WHERE ordernumber = 'P190802192453929' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404869'
                WHERE ordernumber = 'P200802192505704' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340432'
                WHERE ordernumber = 'P200802192701646' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404870'
                WHERE ordernumber = 'P190802192838792' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283015'
                WHERE ordernumber = 'P190802192932389' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283015'
                WHERE ordernumber = 'P190802193024653' 
            
2024-08-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404871'
                WHERE ordernumber = 'P200802193103537' 
            
2024-08-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404872'
                WHERE ordernumber = 'P190802193304182' 
            
2024-08-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '193941'
                WHERE ordernumber = 'P200802193314594' 
            
2024-08-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '385967'
                WHERE ordernumber = 'P630802193429458' 
            
2024-08-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '283015'
                WHERE ordernumber = 'P190802193520491' 
            
2024-08-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404827'
                WHERE ordernumber = 'P190802194802127' 
            
2024-08-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '316629'
                WHERE ordernumber = 'P190802194844641' 
            
2024-08-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '379838'
                WHERE ordernumber = 'P190802195102819' 
            
2024-08-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '296329'
                WHERE ordernumber = 'P190802195241773' 
            
2024-08-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P590802202653951'