2023-11-25 01:00:01 -- 將會員中心id寫入data-lake
2023-11-25 01:00:01 -- 
            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 '2023-11-24%';
        
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94231'
                WHERE ordernumber = 'P201124110052894' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279537'
                WHERE ordernumber = 'P181124110056857' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81652'
                WHERE ordernumber = 'P421124110239498' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344433'
                WHERE ordernumber = 'P201124110248553' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349008'
                WHERE ordernumber = 'P201124110526835' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276492'
                WHERE ordernumber = 'P201124110609430' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232992'
                WHERE ordernumber = 'P201124110737434' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349010'
                WHERE ordernumber = 'P181124110917583' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349009'
                WHERE ordernumber = 'P201124110933703' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239457'
                WHERE ordernumber = 'P181124111328387' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339366'
                WHERE ordernumber = 'P181124111445576' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214266'
                WHERE ordernumber = 'P181124112326496' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341991'
                WHERE ordernumber = 'P191124112342318' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349013'
                WHERE ordernumber = 'P191124112452649' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214266'
                WHERE ordernumber = 'P181124112625112' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349014'
                WHERE ordernumber = 'P191124112625637' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235347'
                WHERE ordernumber = 'P421124113441834' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318961'
                WHERE ordernumber = 'P191124113442920' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349015'
                WHERE ordernumber = 'P201124113457558' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P181124113458235' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303002'
                WHERE ordernumber = 'P201124113715165' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166561'
                WHERE ordernumber = 'P201124114205313' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347184'
                WHERE ordernumber = 'P201124114432165' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '61566'
                WHERE ordernumber = 'P181124114535855' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349017'
                WHERE ordernumber = 'P181124114842389' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349017'
                WHERE ordernumber = 'P181124114946307' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349019'
                WHERE ordernumber = 'P421124115146667' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291891'
                WHERE ordernumber = 'P181124115550403' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349021'
                WHERE ordernumber = 'P181124120531801' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281224'
                WHERE ordernumber = 'P201124121121233' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349023'
                WHERE ordernumber = 'P191124121239425' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349024'
                WHERE ordernumber = 'P201124121512433' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P181124121729689' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349026'
                WHERE ordernumber = 'P421124121738526' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349027'
                WHERE ordernumber = 'P201124121755993' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '36029'
                WHERE ordernumber = 'P421124121838676' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214136'
                WHERE ordernumber = 'P191124121858404' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349028'
                WHERE ordernumber = 'P201124122132295' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349029'
                WHERE ordernumber = 'P201124122312371' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349030'
                WHERE ordernumber = 'P201124122724561' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349032'
                WHERE ordernumber = 'P181124123049232' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349031'
                WHERE ordernumber = 'P191124123130128' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349033'
                WHERE ordernumber = 'P181124123428690' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349034'
                WHERE ordernumber = 'P201124123518648' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349036'
                WHERE ordernumber = 'P201124123941156' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349037'
                WHERE ordernumber = 'P201124124228463' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341732'
                WHERE ordernumber = 'P191124124705119' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '325357'
                WHERE ordernumber = 'P181124124708178' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341405'
                WHERE ordernumber = 'P181124124913588' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241711'
                WHERE ordernumber = 'P191124125027575' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '157216'
                WHERE ordernumber = 'P181124125341743' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346672'
                WHERE ordernumber = 'P421124125356652' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340530'
                WHERE ordernumber = 'P201124125722465' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348531'
                WHERE ordernumber = 'P421124125936746' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349040'
                WHERE ordernumber = 'P421124130136323' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349041'
                WHERE ordernumber = 'P181124130248684' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278088'
                WHERE ordernumber = 'P421124130518351' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349042'
                WHERE ordernumber = 'P421124130559860' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329610'
                WHERE ordernumber = 'P421124130844888' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320288'
                WHERE ordernumber = 'P201124130909587' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349044'
                WHERE ordernumber = 'P201124132102203' 
            
2023-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349045'
                WHERE ordernumber = 'P201124132551547' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349046'
                WHERE ordernumber = 'P421124132647758' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330690'
                WHERE ordernumber = 'P181124133014452' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309204'
                WHERE ordernumber = 'P201124133115253' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327413'
                WHERE ordernumber = 'P201124133514899' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349049'
                WHERE ordernumber = 'P201124133820909' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349051'
                WHERE ordernumber = 'P201124134000760' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349052'
                WHERE ordernumber = 'P201124134131206' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116006'
                WHERE ordernumber = 'P201124134229933' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231119'
                WHERE ordernumber = 'P421124134403841' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291416'
                WHERE ordernumber = 'P181124134906729' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230632'
                WHERE ordernumber = 'P181124135017830' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232499'
                WHERE ordernumber = 'P181124135544555' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346551'
                WHERE ordernumber = 'P181124135822144' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141373'
                WHERE ordernumber = 'P191124140203397' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94939'
                WHERE ordernumber = 'P191124140542888' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338259'
                WHERE ordernumber = 'P191124140751627' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286959'
                WHERE ordernumber = 'P191124140852804' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107267'
                WHERE ordernumber = 'P191124140951263' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329183'
                WHERE ordernumber = 'P201124141208463' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347630'
                WHERE ordernumber = 'P421124141319586' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259359'
                WHERE ordernumber = 'P191124141355400' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349056'
                WHERE ordernumber = 'P191124141748278' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269457'
                WHERE ordernumber = 'P181124141833404' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349058'
                WHERE ordernumber = 'P191124141932670' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349059'
                WHERE ordernumber = 'P191124142140887' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349060'
                WHERE ordernumber = 'P181124142356608' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335405'
                WHERE ordernumber = 'P181124142615660' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106028'
                WHERE ordernumber = 'P201124143041644' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346469'
                WHERE ordernumber = 'P201124143130920' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298474'
                WHERE ordernumber = 'P421124143221319' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349064'
                WHERE ordernumber = 'P201124144503464' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348631'
                WHERE ordernumber = 'P201124144601543' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349065'
                WHERE ordernumber = 'P201124144759555' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96384'
                WHERE ordernumber = 'P201124144916936' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349067'
                WHERE ordernumber = 'P421124145348279' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335323'
                WHERE ordernumber = 'P201124145613212' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347871'
                WHERE ordernumber = 'P181124145910903' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118394'
                WHERE ordernumber = 'P201124145959329' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P181124150009491' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349070'
                WHERE ordernumber = 'P201124150825800' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349068'
                WHERE ordernumber = 'P421124150829446' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346613'
                WHERE ordernumber = 'P421124151234329' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P181124151552503' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349073'
                WHERE ordernumber = 'P191124151700191' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241068'
                WHERE ordernumber = 'P201124151717500' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349074'
                WHERE ordernumber = 'P181124151933933' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349075'
                WHERE ordernumber = 'P201124152512536' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349076'
                WHERE ordernumber = 'P201124152552703' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227288'
                WHERE ordernumber = 'P191124152750818' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349077'
                WHERE ordernumber = 'P181124152955264' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349079'
                WHERE ordernumber = 'P191124153248426' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349080'
                WHERE ordernumber = 'P181124153308895' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349081'
                WHERE ordernumber = 'P181124153421672' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349079'
                WHERE ordernumber = 'P191124153638357' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169341'
                WHERE ordernumber = 'P181124153808368' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349082'
                WHERE ordernumber = 'P191124153816799' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349083'
                WHERE ordernumber = 'P181124154215206' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331242'
                WHERE ordernumber = 'P181124154820194' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81328'
                WHERE ordernumber = 'P181124154927447' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349085'
                WHERE ordernumber = 'P181124155147914' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122740'
                WHERE ordernumber = 'P421124155148994' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307917'
                WHERE ordernumber = 'P181124155248289' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307917'
                WHERE ordernumber = 'P181124155335260' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349086'
                WHERE ordernumber = 'P201124155357994' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313559'
                WHERE ordernumber = 'P181124155500140' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204639'
                WHERE ordernumber = 'P181124155710393' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247230'
                WHERE ordernumber = 'P181124155818212' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344306'
                WHERE ordernumber = 'P201124155832990' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274646'
                WHERE ordernumber = 'P181124155913384' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231898'
                WHERE ordernumber = 'P201124155950568' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349087'
                WHERE ordernumber = 'P181124160215131' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P181124160309291' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209628'
                WHERE ordernumber = 'P181124160620601' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97768'
                WHERE ordernumber = 'P181124161016533' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98272'
                WHERE ordernumber = 'P181124161619464' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123682'
                WHERE ordernumber = 'P181124162153778' 
            
2023-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340788'
                WHERE ordernumber = 'P201124162415766' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81992'
                WHERE ordernumber = 'P181124162458367' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P191124162626128' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348896'
                WHERE ordernumber = 'P201124162846398' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99659'
                WHERE ordernumber = 'P191124163139269' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346716'
                WHERE ordernumber = 'P181124163503805' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P201124163751523' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349092'
                WHERE ordernumber = 'P421124163759833' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349093'
                WHERE ordernumber = 'P201124163946312' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275242'
                WHERE ordernumber = 'P201124164444639' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293946'
                WHERE ordernumber = 'P181124165435909' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340551'
                WHERE ordernumber = 'P421124165759193' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349094'
                WHERE ordernumber = 'P181124165935833' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349095'
                WHERE ordernumber = 'P191124170236824' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337153'
                WHERE ordernumber = 'P191124170547933' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221989'
                WHERE ordernumber = 'P201124170959811' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349098'
                WHERE ordernumber = 'P421124171004761' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349020'
                WHERE ordernumber = 'P191124171047757' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349020'
                WHERE ordernumber = 'P191124171129788' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349097'
                WHERE ordernumber = 'P191124171252186' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329044'
                WHERE ordernumber = 'P181124171551329' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343045'
                WHERE ordernumber = 'P181124171843401' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106059'
                WHERE ordernumber = 'P181124172035946' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218966'
                WHERE ordernumber = 'P181124172415115' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349101'
                WHERE ordernumber = 'P201124172526891' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237371'
                WHERE ordernumber = 'P201124172605763' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118593'
                WHERE ordernumber = 'P191124172621273' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118593'
                WHERE ordernumber = 'P191124173141567' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349103'
                WHERE ordernumber = 'P201124173229141' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349104'
                WHERE ordernumber = 'P421124173358455' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307329'
                WHERE ordernumber = 'P181124173419288' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295622'
                WHERE ordernumber = 'P201124173508179' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166843'
                WHERE ordernumber = 'P201124173633214' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347698'
                WHERE ordernumber = 'P421124173710247' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97763'
                WHERE ordernumber = 'P181124173753188' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97763'
                WHERE ordernumber = 'P181124173848870' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349105'
                WHERE ordernumber = 'P201124174123409' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349106'
                WHERE ordernumber = 'P181124174220531' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349107'
                WHERE ordernumber = 'P421124174813621' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108019'
                WHERE ordernumber = 'P201124175144203' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135579'
                WHERE ordernumber = 'P191124175335558' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135579'
                WHERE ordernumber = 'P191124175412961' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349108'
                WHERE ordernumber = 'P181124175423880' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349109'
                WHERE ordernumber = 'P201124175427643' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290489'
                WHERE ordernumber = 'P181124175700746' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349110'
                WHERE ordernumber = 'P191124180316864' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341678'
                WHERE ordernumber = 'P421124180641949' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349112'
                WHERE ordernumber = 'P421124180902667' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349113'
                WHERE ordernumber = 'P181124180924493' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168082'
                WHERE ordernumber = 'P421124181250251' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329191'
                WHERE ordernumber = 'P181124181454821' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238078'
                WHERE ordernumber = 'P191124181649288' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349114'
                WHERE ordernumber = 'P201124181802833' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349115'
                WHERE ordernumber = 'P421124181948228' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349116'
                WHERE ordernumber = 'P191124182030503' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342473'
                WHERE ordernumber = 'P201124182115348' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117532'
                WHERE ordernumber = 'P181124182318406' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349118'
                WHERE ordernumber = 'P181124182459391' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349119'
                WHERE ordernumber = 'P421124182714278' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349120'
                WHERE ordernumber = 'P201124182723146' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349121'
                WHERE ordernumber = 'P201124182825141' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '200403'
                WHERE ordernumber = 'P181124182939415' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347910'
                WHERE ordernumber = 'P421124183157938' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238489'
                WHERE ordernumber = 'P201124183334866' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113784'
                WHERE ordernumber = 'P191124183517769' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333115'
                WHERE ordernumber = 'P421124183631828' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349122'
                WHERE ordernumber = 'P201124183757801' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349122'
                WHERE ordernumber = 'P201124183933589' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103510'
                WHERE ordernumber = 'P191124184144284' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276651'
                WHERE ordernumber = 'P201124184230877' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344859'
                WHERE ordernumber = 'P201124184458298' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129280'
                WHERE ordernumber = 'P201124184904516' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165549'
                WHERE ordernumber = 'P201124185042813' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349123'
                WHERE ordernumber = 'P191124185140429' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349124'
                WHERE ordernumber = 'P421124185716491' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95310'
                WHERE ordernumber = 'P191124185736274' 
            
2023-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349126'
                WHERE ordernumber = 'P201124190413679' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317326'
                WHERE ordernumber = 'P191124190653459' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263365'
                WHERE ordernumber = 'P191124190938803' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229589'
                WHERE ordernumber = 'P191124191237316' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349127'
                WHERE ordernumber = 'P201124191324782' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161014'
                WHERE ordernumber = 'P191124191346486' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349128'
                WHERE ordernumber = 'P191124191454572' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '132468'
                WHERE ordernumber = 'P191124191644633' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281458'
                WHERE ordernumber = 'P201124192222223' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349131'
                WHERE ordernumber = 'P421124192835758' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344307'
                WHERE ordernumber = 'P201124192930182' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349132'
                WHERE ordernumber = 'P421124193257603' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348315'
                WHERE ordernumber = 'P201124193323359' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349133'
                WHERE ordernumber = 'P201124193752309' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93028'
                WHERE ordernumber = 'P201124194042733' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '32411'
                WHERE ordernumber = 'P201124194203641' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349134'
                WHERE ordernumber = 'P421124194212393' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347940'
                WHERE ordernumber = 'P421124195431799' 
            
2023-11-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349135'
                WHERE ordernumber = 'P201124195930161'