2024-09-03 01:00:02 -- 將會員中心id寫入data-lake
2024-09-03 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-09-02%';
        
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P200902110448112' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231680'
                WHERE ordernumber = 'P180902110652112' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P190902110734163' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209723'
                WHERE ordernumber = 'P190902110837238' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417664'
                WHERE ordernumber = 'P420902111020562' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417665'
                WHERE ordernumber = 'P420902111146342' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312940'
                WHERE ordernumber = 'P180902111215243' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103003'
                WHERE ordernumber = 'P200902111226808' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308251'
                WHERE ordernumber = 'P200902111403188' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106177'
                WHERE ordernumber = 'P180902111430231' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414156'
                WHERE ordernumber = 'P190902111548671' 
            
2024-09-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417673'
                WHERE ordernumber = 'P200902111735573' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312940'
                WHERE ordernumber = 'P180902111744760' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417673'
                WHERE ordernumber = 'P200902111825771' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336162'
                WHERE ordernumber = 'P420902111846386' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352001'
                WHERE ordernumber = 'P180902111911891' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300227'
                WHERE ordernumber = 'P190902112027279' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329834'
                WHERE ordernumber = 'P180902112100435' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414156'
                WHERE ordernumber = 'P180902112215717' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417675'
                WHERE ordernumber = 'P420902112223374' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329834'
                WHERE ordernumber = 'P190902112419743' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235451'
                WHERE ordernumber = 'P200902112634631' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235451'
                WHERE ordernumber = 'P200902112738959' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417676'
                WHERE ordernumber = 'P420902112739807' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235451'
                WHERE ordernumber = 'P200902112930870' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224573'
                WHERE ordernumber = 'P590902113020891' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232251'
                WHERE ordernumber = 'P180902113026648' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417607'
                WHERE ordernumber = 'P420902113325959' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403768'
                WHERE ordernumber = 'P200902113412601' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391342'
                WHERE ordernumber = 'P180902113418389' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417678'
                WHERE ordernumber = 'P420902113617788' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417679'
                WHERE ordernumber = 'P180902113720608' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417684'
                WHERE ordernumber = 'P420902114126460' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416664'
                WHERE ordernumber = 'P420902114301811' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88929'
                WHERE ordernumber = 'P180902114321812' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417686'
                WHERE ordernumber = 'P180902114515808' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417689'
                WHERE ordernumber = 'P200902114638544' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333351'
                WHERE ordernumber = 'P200902114825374' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410659'
                WHERE ordernumber = 'P190902115258274' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288025'
                WHERE ordernumber = 'P200902115417365' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129092'
                WHERE ordernumber = 'P180902115639650' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200902121304434' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417708'
                WHERE ordernumber = 'P420902121355542' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339295'
                WHERE ordernumber = 'P180902121819232' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219143'
                WHERE ordernumber = 'P180902121954685' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417720'
                WHERE ordernumber = 'P200902122552774' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416046'
                WHERE ordernumber = 'P180902122755717' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180902122828217' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P200902123236236' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158809'
                WHERE ordernumber = 'P180902123309657' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417724'
                WHERE ordernumber = 'P180902123555445' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102087'
                WHERE ordernumber = 'P180902123721887' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417735'
                WHERE ordernumber = 'P200902124127911' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118908'
                WHERE ordernumber = 'P180902124243962' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414551'
                WHERE ordernumber = 'P420902124557999' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109191'
                WHERE ordernumber = 'P200902125115472' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417700'
                WHERE ordernumber = 'P180902125200919' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417742'
                WHERE ordernumber = 'P420902125337857' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417744'
                WHERE ordernumber = 'P200902125354118' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417745'
                WHERE ordernumber = 'P180902125430894' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417748'
                WHERE ordernumber = 'P180902130217638' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350995'
                WHERE ordernumber = 'P200902130956516' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390391'
                WHERE ordernumber = 'P630902131156805' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338036'
                WHERE ordernumber = 'P180902131245765' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417755'
                WHERE ordernumber = 'P200902131246770' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417756'
                WHERE ordernumber = 'P420902131337904' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417755'
                WHERE ordernumber = 'P200902131346625' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319846'
                WHERE ordernumber = 'P180902131601912' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113510'
                WHERE ordernumber = 'P180902132446834' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284434'
                WHERE ordernumber = 'P180902133355914' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417772'
                WHERE ordernumber = 'P420902133916818' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417759'
                WHERE ordernumber = 'P200902134007865' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417775'
                WHERE ordernumber = 'P420902134107919' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338056'
                WHERE ordernumber = 'P180902134127526' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417776'
                WHERE ordernumber = 'P200902134234344' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417778'
                WHERE ordernumber = 'P180902134435435' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346885'
                WHERE ordernumber = 'P420902134721195' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412205'
                WHERE ordernumber = 'P180902135300733' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411095'
                WHERE ordernumber = 'P180902135551915' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124677'
                WHERE ordernumber = 'P200902135615455' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319846'
                WHERE ordernumber = 'P180902135633225' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417786'
                WHERE ordernumber = 'P180902140017705' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406359'
                WHERE ordernumber = 'P420902140020286' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415633'
                WHERE ordernumber = 'P420902140815627' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256840'
                WHERE ordernumber = 'P180902140950219' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126104'
                WHERE ordernumber = 'P180902141117275' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332698'
                WHERE ordernumber = 'P180902141335912' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238986'
                WHERE ordernumber = 'P180902141846902' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147635'
                WHERE ordernumber = 'P180902142151993' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337409'
                WHERE ordernumber = 'P180902142648761' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96535'
                WHERE ordernumber = 'P180902142918158' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311238'
                WHERE ordernumber = 'P180902143216856' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224573'
                WHERE ordernumber = 'P590902143251752' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239380'
                WHERE ordernumber = 'P180902143418788' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160964'
                WHERE ordernumber = 'P180902143541368' 
            
2024-09-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417811'
                WHERE ordernumber = 'P420902143635884' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294019'
                WHERE ordernumber = 'P420902143746756' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330176'
                WHERE ordernumber = 'P200902143813346' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330176'
                WHERE ordernumber = 'P200902143945911' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374480'
                WHERE ordernumber = 'P420902144027734' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378193'
                WHERE ordernumber = 'P180902144110694' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251464'
                WHERE ordernumber = 'P420902144141168' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237811'
                WHERE ordernumber = 'P180902144218532' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415280'
                WHERE ordernumber = 'P180902144326354' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415280'
                WHERE ordernumber = 'P180902144350482' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381834'
                WHERE ordernumber = 'P180902144509812' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411007'
                WHERE ordernumber = 'P420902144633773' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411007'
                WHERE ordernumber = 'P420902144722364' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241783'
                WHERE ordernumber = 'P180902144833634' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281350'
                WHERE ordernumber = 'P190902144923834' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417818'
                WHERE ordernumber = 'P420902145116700' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356340'
                WHERE ordernumber = 'P200902145141649' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318845'
                WHERE ordernumber = 'P180902145223639' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417820'
                WHERE ordernumber = 'P420902145248988' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415280'
                WHERE ordernumber = 'P180902145402766' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417825'
                WHERE ordernumber = 'P420902150027330' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416993'
                WHERE ordernumber = 'P180902150109639' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260405'
                WHERE ordernumber = 'P200902150228510' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232930'
                WHERE ordernumber = 'P180902150255189' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218565'
                WHERE ordernumber = 'P420902150411141' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263776'
                WHERE ordernumber = 'P180902151506236' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396041'
                WHERE ordernumber = 'P180902151652401' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396041'
                WHERE ordernumber = 'P180902151802524' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139258'
                WHERE ordernumber = 'P420902152234610' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209723'
                WHERE ordernumber = 'P180902152246977' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417837'
                WHERE ordernumber = 'P420902152423218' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417839'
                WHERE ordernumber = 'P200902152519793' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294478'
                WHERE ordernumber = 'P180902152626359' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413685'
                WHERE ordernumber = 'P200902152655902' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417841'
                WHERE ordernumber = 'P200902153133328' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224253'
                WHERE ordernumber = 'P200902154209774' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417850'
                WHERE ordernumber = 'P200902154658365' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417853'
                WHERE ordernumber = 'P420902154924726' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415068'
                WHERE ordernumber = 'P630902155245942' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417856'
                WHERE ordernumber = 'P180902155425978' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417857'
                WHERE ordernumber = 'P200902155502361' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416026'
                WHERE ordernumber = 'P180902155629573' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417860'
                WHERE ordernumber = 'P420902155723891' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417861'
                WHERE ordernumber = 'P200902155754245' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234582'
                WHERE ordernumber = 'P420902155821261' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240819'
                WHERE ordernumber = 'P200902155833624' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417863'
                WHERE ordernumber = 'P420902155937895' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367176'
                WHERE ordernumber = 'P180902160201930' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '57490'
                WHERE ordernumber = 'P180902160359694' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407094'
                WHERE ordernumber = 'P420902160700901' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417867'
                WHERE ordernumber = 'P420902160936181' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292881'
                WHERE ordernumber = 'P420902161052738' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261976'
                WHERE ordernumber = 'P180902161246135' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417868'
                WHERE ordernumber = 'P420902161248878' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261976'
                WHERE ordernumber = 'P180902161325734' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135376'
                WHERE ordernumber = 'P180902161448217' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417871'
                WHERE ordernumber = 'P420902161555884' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '75286'
                WHERE ordernumber = 'P420902161704850' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247064'
                WHERE ordernumber = 'P200902161821196' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414983'
                WHERE ordernumber = 'P180902161821908' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417873'
                WHERE ordernumber = 'P420902161836536' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417826'
                WHERE ordernumber = 'P200902162553797' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333379'
                WHERE ordernumber = 'P180902162715168' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417645'
                WHERE ordernumber = 'P180902162808961' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417881'
                WHERE ordernumber = 'P420902163029582' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396931'
                WHERE ordernumber = 'P200902163136670' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417881'
                WHERE ordernumber = 'P420902163311949' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396931'
                WHERE ordernumber = 'P200902163319705' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396931'
                WHERE ordernumber = 'P200902163333588' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404161'
                WHERE ordernumber = 'P420902163400942' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318676'
                WHERE ordernumber = 'P200902163448435' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221061'
                WHERE ordernumber = 'P180902163511827' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315674'
                WHERE ordernumber = 'P180902163653455' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315674'
                WHERE ordernumber = 'P180902163729286' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137430'
                WHERE ordernumber = 'P200902163846202' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137430'
                WHERE ordernumber = 'P200902163918877' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348617'
                WHERE ordernumber = 'P180902164008270' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415660'
                WHERE ordernumber = 'P200902164109527' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417892'
                WHERE ordernumber = 'P420902164628766' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417897'
                WHERE ordernumber = 'P200902165156490' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417900'
                WHERE ordernumber = 'P200902165532331' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219143'
                WHERE ordernumber = 'P180902165856718' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232257'
                WHERE ordernumber = 'P200902170025451' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417890'
                WHERE ordernumber = 'P420902170459595' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417890'
                WHERE ordernumber = 'P420902170601558' 
            
2024-09-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337926'
                WHERE ordernumber = 'P200902170616538' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228866'
                WHERE ordernumber = 'P200902170718926' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387981'
                WHERE ordernumber = 'P420902170853254' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417645'
                WHERE ordernumber = 'P180902170955391' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384526'
                WHERE ordernumber = 'P200902171217238' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409984'
                WHERE ordernumber = 'P180902171255132' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281512'
                WHERE ordernumber = 'P180902171725979' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416467'
                WHERE ordernumber = 'P180902171847167' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416467'
                WHERE ordernumber = 'P180902171940911' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417918'
                WHERE ordernumber = 'P180902172149825' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291977'
                WHERE ordernumber = 'P420902172315799' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417922'
                WHERE ordernumber = 'P180902172511345' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417921'
                WHERE ordernumber = 'P180902172805312' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417928'
                WHERE ordernumber = 'P200902172843997' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417921'
                WHERE ordernumber = 'P180902172918534' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410433'
                WHERE ordernumber = 'P420902173012555' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417920'
                WHERE ordernumber = 'P180902173042542' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417920'
                WHERE ordernumber = 'P180902173209242' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414826'
                WHERE ordernumber = 'P200902173252856' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417924'
                WHERE ordernumber = 'P180902173303317' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417936'
                WHERE ordernumber = 'P420902173735622' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417937'
                WHERE ordernumber = 'P180902173850536' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365178'
                WHERE ordernumber = 'P180902174005869' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284163'
                WHERE ordernumber = 'P200902174136221' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331317'
                WHERE ordernumber = 'P420902174154161' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406296'
                WHERE ordernumber = 'P200902174544762' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417940'
                WHERE ordernumber = 'P180902174531729' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118209'
                WHERE ordernumber = 'P180902174716689' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98694'
                WHERE ordernumber = 'P200902174908504' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306476'
                WHERE ordernumber = 'P180902175044497' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '67684'
                WHERE ordernumber = 'P200902175518523' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417601'
                WHERE ordernumber = 'P420902175527903' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238530'
                WHERE ordernumber = 'P200902180027772' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417947'
                WHERE ordernumber = 'P420902180056186' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415717'
                WHERE ordernumber = 'P420902180401895' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417950'
                WHERE ordernumber = 'P420902180510312' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414185'
                WHERE ordernumber = 'P420902180544726' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417953'
                WHERE ordernumber = 'P420902180912953' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137725'
                WHERE ordernumber = 'P200902181109677' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P180902181433546' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99941'
                WHERE ordernumber = 'P180902181658631' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415960'
                WHERE ordernumber = 'P200902181715118' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417957'
                WHERE ordernumber = 'P420902181954551' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105913'
                WHERE ordernumber = 'P200902182047865' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345803'
                WHERE ordernumber = 'P180902182059160' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105913'
                WHERE ordernumber = 'P200902182139320' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417958'
                WHERE ordernumber = 'P420902182148544' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102335'
                WHERE ordernumber = 'P200902182301520' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403465'
                WHERE ordernumber = 'P200902182908422' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383764'
                WHERE ordernumber = 'P420902182943772' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415819'
                WHERE ordernumber = 'P420902183044878' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97763'
                WHERE ordernumber = 'P180902183420876' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374860'
                WHERE ordernumber = 'P180902183721951' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86442'
                WHERE ordernumber = 'P180902183924602' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417962'
                WHERE ordernumber = 'P420902184210133' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81124'
                WHERE ordernumber = 'P420902184259859' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417965'
                WHERE ordernumber = 'P420902184939707' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315507'
                WHERE ordernumber = 'P200902185718424' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420902190204935' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413273'
                WHERE ordernumber = 'P180902190534179' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388950'
                WHERE ordernumber = 'P180902190856931' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396437'
                WHERE ordernumber = 'P200902191307382' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393492'
                WHERE ordernumber = 'P200902193231433' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372068'
                WHERE ordernumber = 'P200902193443446' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211065'
                WHERE ordernumber = 'P200902193609586' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417991'
                WHERE ordernumber = 'P180902193810492' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417988'
                WHERE ordernumber = 'P200902194113371' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354864'
                WHERE ordernumber = 'P180902194329767' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417993'
                WHERE ordernumber = 'P180902194432896' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417995'
                WHERE ordernumber = 'P200902194854184' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417725'
                WHERE ordernumber = 'P200902195053438' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417725'
                WHERE ordernumber = 'P200902195143595' 
            
2024-09-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131589'
                WHERE ordernumber = 'P180902200104171'