2024-06-29 01:00:02 -- 將會員中心id寫入data-lake
2024-06-29 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-06-28%';
        
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398569'
                WHERE ordernumber = 'P630628101336791' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398575'
                WHERE ordernumber = 'P630628105848235' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282031'
                WHERE ordernumber = 'P180628110241350' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '146510'
                WHERE ordernumber = 'P180628110404235' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378953'
                WHERE ordernumber = 'P190628110511520' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200628110517553' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398577'
                WHERE ordernumber = 'P200628110656975' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398576'
                WHERE ordernumber = 'P420628110808356' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398570'
                WHERE ordernumber = 'P180628110841380' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398578'
                WHERE ordernumber = 'P200628110844721' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398570'
                WHERE ordernumber = 'P180628110912331' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398576'
                WHERE ordernumber = 'P420628110923442' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331003'
                WHERE ordernumber = 'P190628110941561' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116811'
                WHERE ordernumber = 'P180628111032766' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398579'
                WHERE ordernumber = 'P630628111042926' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287381'
                WHERE ordernumber = 'P200628111106550' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398580'
                WHERE ordernumber = 'P180628111150448' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398581'
                WHERE ordernumber = 'P180628111318560' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271058'
                WHERE ordernumber = 'P200628111433882' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398582'
                WHERE ordernumber = 'P190628111515257' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310011'
                WHERE ordernumber = 'P200628111703842' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398583'
                WHERE ordernumber = 'P180628111812971' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232119'
                WHERE ordernumber = 'P190628111930598' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289030'
                WHERE ordernumber = 'P200628112050996' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398585'
                WHERE ordernumber = 'P180628112059129' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398586'
                WHERE ordernumber = 'P180628112306912' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237775'
                WHERE ordernumber = 'P200628112515308' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312829'
                WHERE ordernumber = 'P180628112630807' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309861'
                WHERE ordernumber = 'P190628112800566' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287066'
                WHERE ordernumber = 'P180628112905864' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312829'
                WHERE ordernumber = 'P180628112956513' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396884'
                WHERE ordernumber = 'P180628113036249' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398587'
                WHERE ordernumber = 'P200628113136905' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393246'
                WHERE ordernumber = 'P420628113211118' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398588'
                WHERE ordernumber = 'P630628113336236' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398589'
                WHERE ordernumber = 'P180628113412192' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398591'
                WHERE ordernumber = 'P180628113519258' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398346'
                WHERE ordernumber = 'P200628113715332' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287508'
                WHERE ordernumber = 'P180628113902140' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398593'
                WHERE ordernumber = 'P420628114029165' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398594'
                WHERE ordernumber = 'P180628114045253' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398595'
                WHERE ordernumber = 'P630628114156282' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396154'
                WHERE ordernumber = 'P200628114326908' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398593'
                WHERE ordernumber = 'P420628114328179' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358055'
                WHERE ordernumber = 'P180628114622748' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168750'
                WHERE ordernumber = 'P200628114706532' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398596'
                WHERE ordernumber = 'P180628114801982' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349629'
                WHERE ordernumber = 'P200628114929837' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396061'
                WHERE ordernumber = 'P200628115049308' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398597'
                WHERE ordernumber = 'P180628115120132' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P190628115120762' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398598'
                WHERE ordernumber = 'P630628115157520' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398599'
                WHERE ordernumber = 'P630628115545709' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219667'
                WHERE ordernumber = 'P200628115649546' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398600'
                WHERE ordernumber = 'P180628115803473' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398601'
                WHERE ordernumber = 'P630628120039961' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320976'
                WHERE ordernumber = 'P190628120124373' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398603'
                WHERE ordernumber = 'P180628120947408' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339666'
                WHERE ordernumber = 'P420628121039388' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366205'
                WHERE ordernumber = 'P630628121136641' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398604'
                WHERE ordernumber = 'P420628121210888' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398605'
                WHERE ordernumber = 'P200628121511621' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398606'
                WHERE ordernumber = 'P630628121549276' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398606'
                WHERE ordernumber = 'P630628121624660' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278383'
                WHERE ordernumber = 'P200628121826990' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398607'
                WHERE ordernumber = 'P180628121855626' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398608'
                WHERE ordernumber = 'P420628122018318' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396885'
                WHERE ordernumber = 'P200628122545806' 
            
2024-06-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254450'
                WHERE ordernumber = 'P200628122817785' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367940'
                WHERE ordernumber = 'P200628122914558' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251986'
                WHERE ordernumber = 'P200628123039988' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398610'
                WHERE ordernumber = 'P200628123156966' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316477'
                WHERE ordernumber = 'P180628123212598' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265965'
                WHERE ordernumber = 'P630628123549685' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340773'
                WHERE ordernumber = 'P180628124108119' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398612'
                WHERE ordernumber = 'P200628124244658' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398611'
                WHERE ordernumber = 'P630628124306413' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397870'
                WHERE ordernumber = 'P180628124334646' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381645'
                WHERE ordernumber = 'P180628124447134' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398614'
                WHERE ordernumber = 'P180628124706811' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398615'
                WHERE ordernumber = 'P200628124751652' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223457'
                WHERE ordernumber = 'P180628124901212' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398616'
                WHERE ordernumber = 'P420628124915966' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101291'
                WHERE ordernumber = 'P420628125123646' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398619'
                WHERE ordernumber = 'P630628125336366' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398618'
                WHERE ordernumber = 'P200628125408969' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398620'
                WHERE ordernumber = 'P420628125641401' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P180628125800808' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398621'
                WHERE ordernumber = 'P630628130241396' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346908'
                WHERE ordernumber = 'P180628130623641' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135457'
                WHERE ordernumber = 'P630628130914639' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398623'
                WHERE ordernumber = 'P180628131245616' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297228'
                WHERE ordernumber = 'P420628131302195' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295406'
                WHERE ordernumber = 'P630628131331903' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P180628131344584' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160876'
                WHERE ordernumber = 'P200628131433673' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398625'
                WHERE ordernumber = 'P420628131844795' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299779'
                WHERE ordernumber = 'P420628131929885' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398627'
                WHERE ordernumber = 'P200628132040326' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398626'
                WHERE ordernumber = 'P180628132111350' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380358'
                WHERE ordernumber = 'P180628132229791' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398629'
                WHERE ordernumber = 'P190628132231852' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141370'
                WHERE ordernumber = 'P190628132528846' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398630'
                WHERE ordernumber = 'P190628132744322' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398631'
                WHERE ordernumber = 'P630628133015579' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104444'
                WHERE ordernumber = 'P180628133021570' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398632'
                WHERE ordernumber = 'P630628133250790' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372811'
                WHERE ordernumber = 'P180628133635858' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398633'
                WHERE ordernumber = 'P630628134220482' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381542'
                WHERE ordernumber = 'P180628134558291' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218548'
                WHERE ordernumber = 'P200628135157893' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398634'
                WHERE ordernumber = 'P180628135228792' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282810'
                WHERE ordernumber = 'P200628135643593' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141909'
                WHERE ordernumber = 'P180628140517481' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398636'
                WHERE ordernumber = 'P420628140601790' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398637'
                WHERE ordernumber = 'P200628140701578' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398638'
                WHERE ordernumber = 'P180628140934521' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398639'
                WHERE ordernumber = 'P180628141416806' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398561'
                WHERE ordernumber = 'P200628141511492' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398641'
                WHERE ordernumber = 'P630628142157386' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353333'
                WHERE ordernumber = 'P180628142255738' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158169'
                WHERE ordernumber = 'P420628142608249' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396740'
                WHERE ordernumber = 'P180628143031567' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238261'
                WHERE ordernumber = 'P780628143111791' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398622'
                WHERE ordernumber = 'P180628143237530' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220004'
                WHERE ordernumber = 'P200628143325752' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137581'
                WHERE ordernumber = 'P180628143358113' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390192'
                WHERE ordernumber = 'P200628143443787' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394501'
                WHERE ordernumber = 'P420628143529112' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122412'
                WHERE ordernumber = 'P180628143826183' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398517'
                WHERE ordernumber = 'P180628143845216' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398643'
                WHERE ordernumber = 'P200628143958273' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398644'
                WHERE ordernumber = 'P780628144223863' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398645'
                WHERE ordernumber = 'P180628144244514' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375866'
                WHERE ordernumber = 'P190628144253267' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326325'
                WHERE ordernumber = 'P180628144338578' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398646'
                WHERE ordernumber = 'P420628144358602' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398647'
                WHERE ordernumber = 'P420628144917931' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97872'
                WHERE ordernumber = 'P200628144931318' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258867'
                WHERE ordernumber = 'P200628145040334' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296784'
                WHERE ordernumber = 'P420628145120357' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130996'
                WHERE ordernumber = 'P180628145214546' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398648'
                WHERE ordernumber = 'P630628145318767' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387524'
                WHERE ordernumber = 'P180628145832142' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339666'
                WHERE ordernumber = 'P420628145911303' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264756'
                WHERE ordernumber = 'P630628150029378' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397342'
                WHERE ordernumber = 'P180628150317822' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379602'
                WHERE ordernumber = 'P590628150650324' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398650'
                WHERE ordernumber = 'P630628150851391' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398651'
                WHERE ordernumber = 'P180628150936844' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278615'
                WHERE ordernumber = 'P180628151030638' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398653'
                WHERE ordernumber = 'P420628151041387' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398652'
                WHERE ordernumber = 'P630628151124803' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398654'
                WHERE ordernumber = 'P190628151210678' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398654'
                WHERE ordernumber = 'P190628151234806' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148024'
                WHERE ordernumber = 'P180628151311785' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396641'
                WHERE ordernumber = 'P190628151449706' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398655'
                WHERE ordernumber = 'P180628151732264' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388900'
                WHERE ordernumber = 'P190628151947888' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160612'
                WHERE ordernumber = 'P200628152048633' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296858'
                WHERE ordernumber = 'P420628152203870' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398656'
                WHERE ordernumber = 'P180628152853873' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235665'
                WHERE ordernumber = 'P200628153408345' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398640'
                WHERE ordernumber = 'P630628153437571' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269556'
                WHERE ordernumber = 'P200628153537222' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290454'
                WHERE ordernumber = 'P180628153814882' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398657'
                WHERE ordernumber = 'P200628153859885' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398658'
                WHERE ordernumber = 'P630628153904161' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398659'
                WHERE ordernumber = 'P180628153922112' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392447'
                WHERE ordernumber = 'P420628153922969' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394071'
                WHERE ordernumber = 'P180628154052615' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242157'
                WHERE ordernumber = 'P180628154319391' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346065'
                WHERE ordernumber = 'P200628154336922' 
            
2024-06-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327705'
                WHERE ordernumber = 'P180628155051461' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290592'
                WHERE ordernumber = 'P200628155907866' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258762'
                WHERE ordernumber = 'P190628155943227' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398662'
                WHERE ordernumber = 'P180628160106165' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398663'
                WHERE ordernumber = 'P190628160223231' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398664'
                WHERE ordernumber = 'P420628160839578' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398665'
                WHERE ordernumber = 'P180628161206411' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398666'
                WHERE ordernumber = 'P200628161459218' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217109'
                WHERE ordernumber = 'P180628161547770' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398667'
                WHERE ordernumber = 'P200628161642577' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398668'
                WHERE ordernumber = 'P630628161758391' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398669'
                WHERE ordernumber = 'P200628161915399' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236243'
                WHERE ordernumber = 'P200628162034437' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398670'
                WHERE ordernumber = 'P630628162224662' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103389'
                WHERE ordernumber = 'P180628162350223' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398671'
                WHERE ordernumber = 'P180628162539677' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398672'
                WHERE ordernumber = 'P630628163337626' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398673'
                WHERE ordernumber = 'P180628163348634' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398674'
                WHERE ordernumber = 'P180628163935849' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109223'
                WHERE ordernumber = 'P180628164234892' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101144'
                WHERE ordernumber = 'P200628164409458' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340342'
                WHERE ordernumber = 'P180628164436241' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '191005'
                WHERE ordernumber = 'P180628164533863' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395522'
                WHERE ordernumber = 'P200628164634560' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398678'
                WHERE ordernumber = 'P630628164935989' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398677'
                WHERE ordernumber = 'P200628164949559' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398679'
                WHERE ordernumber = 'P420628165237663' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146262'
                WHERE ordernumber = 'P180628165239341' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281090'
                WHERE ordernumber = 'P180628165317434' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398680'
                WHERE ordernumber = 'P780628165343624' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398681'
                WHERE ordernumber = 'P200628165644113' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398682'
                WHERE ordernumber = 'P630628165721886' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262644'
                WHERE ordernumber = 'P420628165753296' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221674'
                WHERE ordernumber = 'P180628165930858' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129895'
                WHERE ordernumber = 'P180628170125804' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246883'
                WHERE ordernumber = 'P200628170345933' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360233'
                WHERE ordernumber = 'P200628170458186' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139603'
                WHERE ordernumber = 'P180628170544271' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398683'
                WHERE ordernumber = 'P630628170556778' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398684'
                WHERE ordernumber = 'P200628170607981' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398660'
                WHERE ordernumber = 'P420628170630390' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398685'
                WHERE ordernumber = 'P420628170802164' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252707'
                WHERE ordernumber = 'P200628172609580' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283996'
                WHERE ordernumber = 'P180628172623888' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258005'
                WHERE ordernumber = 'P180628173246276' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312952'
                WHERE ordernumber = 'P180628173343987' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395851'
                WHERE ordernumber = 'P180628173719416' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206879'
                WHERE ordernumber = 'P180628174001220' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332017'
                WHERE ordernumber = 'P590628174349850' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356435'
                WHERE ordernumber = 'P200628174502410' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359391'
                WHERE ordernumber = 'P200628174700855' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398689'
                WHERE ordernumber = 'P180628174706312' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398692'
                WHERE ordernumber = 'P420628175216927' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293093'
                WHERE ordernumber = 'P180628175405730' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398688'
                WHERE ordernumber = 'P420628175547405' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105423'
                WHERE ordernumber = 'P190628175722393' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249880'
                WHERE ordernumber = 'P180628180155576' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398694'
                WHERE ordernumber = 'P200628180237135' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333946'
                WHERE ordernumber = 'P420628180856544' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319538'
                WHERE ordernumber = 'P180628181127363' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95013'
                WHERE ordernumber = 'P190628181155169' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398695'
                WHERE ordernumber = 'P630628181227900' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398696'
                WHERE ordernumber = 'P200628181311936' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324531'
                WHERE ordernumber = 'P180628181322475' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398697'
                WHERE ordernumber = 'P420628181330784' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129091'
                WHERE ordernumber = 'P180628181446969' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289545'
                WHERE ordernumber = 'P200628181522142' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398698'
                WHERE ordernumber = 'P180628181556607' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398699'
                WHERE ordernumber = 'P630628181623656' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398700'
                WHERE ordernumber = 'P180628181709495' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398701'
                WHERE ordernumber = 'P630628182017186' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398702'
                WHERE ordernumber = 'P180628182026206' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315557'
                WHERE ordernumber = 'P180628182135255' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385355'
                WHERE ordernumber = 'P200628182209397' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380851'
                WHERE ordernumber = 'P190628182350981' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380851'
                WHERE ordernumber = 'P190628182415501' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114753'
                WHERE ordernumber = 'P200628182455546' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398704'
                WHERE ordernumber = 'P630628182601973' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398705'
                WHERE ordernumber = 'P180628182606733' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398706'
                WHERE ordernumber = 'P190628182734111' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237129'
                WHERE ordernumber = 'P200628182759226' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104875'
                WHERE ordernumber = 'P180628183051210' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387800'
                WHERE ordernumber = 'P420628183636397' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398708'
                WHERE ordernumber = 'P630628183638546' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397621'
                WHERE ordernumber = 'P180628183947999' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398709'
                WHERE ordernumber = 'P200628184210914' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180628184317685' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398710'
                WHERE ordernumber = 'P190628184446179' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398711'
                WHERE ordernumber = 'P420628184516764' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398712'
                WHERE ordernumber = 'P630628184827823' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231324'
                WHERE ordernumber = 'P180628184912126' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373116'
                WHERE ordernumber = 'P420628184935425' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '50791'
                WHERE ordernumber = 'P200628185031847' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278643'
                WHERE ordernumber = 'P190628185037769' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '53396'
                WHERE ordernumber = 'P200628185115127' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398713'
                WHERE ordernumber = 'P630628185240340' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398227'
                WHERE ordernumber = 'P200628185304114' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398714'
                WHERE ordernumber = 'P180628185345995' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '204611'
                WHERE ordernumber = 'P200628185428863' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398715'
                WHERE ordernumber = 'P630628185537307' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398716'
                WHERE ordernumber = 'P180628185616596' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168743'
                WHERE ordernumber = 'P190628190046979' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304242'
                WHERE ordernumber = 'P420628190400718' 
            
2024-06-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398717'
                WHERE ordernumber = 'P630628190510669' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398718'
                WHERE ordernumber = 'P630628190736542' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398719'
                WHERE ordernumber = 'P190628190944268' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398720'
                WHERE ordernumber = 'P630628191048986' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396503'
                WHERE ordernumber = 'P190628191252805' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398721'
                WHERE ordernumber = 'P630628191550648' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398722'
                WHERE ordernumber = 'P190628191601756' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264209'
                WHERE ordernumber = 'P200628191851171' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342695'
                WHERE ordernumber = 'P190628192331590' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390047'
                WHERE ordernumber = 'P200628192352705' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398723'
                WHERE ordernumber = 'P630628192404408' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P190628192411204' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248077'
                WHERE ordernumber = 'P190628192536562' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398724'
                WHERE ordernumber = 'P630628192921486' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398725'
                WHERE ordernumber = 'P630628193220756' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398726'
                WHERE ordernumber = 'P200628193758399' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '243723'
                WHERE ordernumber = 'P200628194527549' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102271'
                WHERE ordernumber = 'P200628194926316' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241387'
                WHERE ordernumber = 'P190628195055826' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398727'
                WHERE ordernumber = 'P200628195851521' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398728'
                WHERE ordernumber = 'P190628195937665' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113002'
                WHERE ordernumber = 'P190628200002893' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398729'
                WHERE ordernumber = 'P590628200524195' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398730'
                WHERE ordernumber = 'P590628201809341' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398731'
                WHERE ordernumber = 'P590628202009371' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398732'
                WHERE ordernumber = 'P630628202203599' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325794'
                WHERE ordernumber = 'P780628203613427' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306778'
                WHERE ordernumber = 'P630628204236410' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398735'
                WHERE ordernumber = 'P630628204325251' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385340'
                WHERE ordernumber = 'P630628210229368' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398737'
                WHERE ordernumber = 'P630628211146295' 
            
2024-06-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346893'
                WHERE ordernumber = 'P630628211639150'