2024-02-16 01:00:02 -- 將會員中心id寫入data-lake
2024-02-16 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-02-15%';
        
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159014'
                WHERE ordernumber = 'P190215110226412' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240937'
                WHERE ordernumber = 'P180215110501674' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332265'
                WHERE ordernumber = 'P180215110653670' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363301'
                WHERE ordernumber = 'P180215111219780' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80893'
                WHERE ordernumber = 'P200215111405315' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234716'
                WHERE ordernumber = 'P180215111702128' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341032'
                WHERE ordernumber = 'P190215112123392' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100750'
                WHERE ordernumber = 'P190215112401802' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324718'
                WHERE ordernumber = 'P190215112909706' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377263'
                WHERE ordernumber = 'P200215112922533' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377266'
                WHERE ordernumber = 'P180215114337804' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377266'
                WHERE ordernumber = 'P180215114439243' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377267'
                WHERE ordernumber = 'P200215114510972' 
            
2024-02-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282597'
                WHERE ordernumber = 'P200215114809111' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134291'
                WHERE ordernumber = 'P200215115020214' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180215115245385' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377270'
                WHERE ordernumber = 'P200215115258149' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248934'
                WHERE ordernumber = 'P200215115555478' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377273'
                WHERE ordernumber = 'P180215120259389' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102972'
                WHERE ordernumber = 'P200215120706577' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200215120851359' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348810'
                WHERE ordernumber = 'P200215121240139' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377274'
                WHERE ordernumber = 'P200215121616810' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377276'
                WHERE ordernumber = 'P200215122536568' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296345'
                WHERE ordernumber = 'P190215122629624' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138351'
                WHERE ordernumber = 'P200215122752508' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279668'
                WHERE ordernumber = 'P190215123651259' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377207'
                WHERE ordernumber = 'P420215124033698' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P420215124130644' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P200215124142519' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377279'
                WHERE ordernumber = 'P420215124724376' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377258'
                WHERE ordernumber = 'P190215125607831' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377282'
                WHERE ordernumber = 'P420215125718901' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350514'
                WHERE ordernumber = 'P420215130354857' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220660'
                WHERE ordernumber = 'P200215130805846' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232297'
                WHERE ordernumber = 'P200215130913465' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377283'
                WHERE ordernumber = 'P200215131259296' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221611'
                WHERE ordernumber = 'P190215131455114' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155893'
                WHERE ordernumber = 'P200215131823897' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125957'
                WHERE ordernumber = 'P200215132017115' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366074'
                WHERE ordernumber = 'P420215132454340' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '574'
                WHERE ordernumber = 'P180215133226675' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128183'
                WHERE ordernumber = 'P180215133332537' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377289'
                WHERE ordernumber = 'P200215133642869' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96055'
                WHERE ordernumber = 'P190215134025175' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286609'
                WHERE ordernumber = 'P200215134522588' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220284'
                WHERE ordernumber = 'P180215134620679' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336922'
                WHERE ordernumber = 'P190215135901561' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377291'
                WHERE ordernumber = 'P200215135932383' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377292'
                WHERE ordernumber = 'P200215140036254' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377294'
                WHERE ordernumber = 'P200215140311680' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305497'
                WHERE ordernumber = 'P190215140425120' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269827'
                WHERE ordernumber = 'P200215140520157' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377295'
                WHERE ordernumber = 'P190215140621451' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269827'
                WHERE ordernumber = 'P200215140627234' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377296'
                WHERE ordernumber = 'P200215140726442' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377297'
                WHERE ordernumber = 'P190215140750914' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377299'
                WHERE ordernumber = 'P190215141026957' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166685'
                WHERE ordernumber = 'P190215141346315' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377300'
                WHERE ordernumber = 'P200215141438578' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259831'
                WHERE ordernumber = 'P420215141439134' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377300'
                WHERE ordernumber = 'P200215141702415' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377301'
                WHERE ordernumber = 'P190215141727902' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377301'
                WHERE ordernumber = 'P190215141743712' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377302'
                WHERE ordernumber = 'P190215142203501' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377303'
                WHERE ordernumber = 'P190215142351809' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352826'
                WHERE ordernumber = 'P420215142634982' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313052'
                WHERE ordernumber = 'P190215142859668' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377304'
                WHERE ordernumber = 'P190215143029629' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377305'
                WHERE ordernumber = 'P200215143157402' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320608'
                WHERE ordernumber = 'P180215143426841' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377306'
                WHERE ordernumber = 'P180215143614982' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365768'
                WHERE ordernumber = 'P420215143826725' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377307'
                WHERE ordernumber = 'P180215143939312' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377308'
                WHERE ordernumber = 'P420215144031118' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377310'
                WHERE ordernumber = 'P200215144922452' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377312'
                WHERE ordernumber = 'P180215145310635' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230861'
                WHERE ordernumber = 'P200215145424604' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377313'
                WHERE ordernumber = 'P180215145453118' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P180215145803878' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230861'
                WHERE ordernumber = 'P200215145927412' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303576'
                WHERE ordernumber = 'P180215150010175' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377251'
                WHERE ordernumber = 'P180215150131363' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277109'
                WHERE ordernumber = 'P200215150409188' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377314'
                WHERE ordernumber = 'P200215150525302' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241480'
                WHERE ordernumber = 'P420215150828793' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166310'
                WHERE ordernumber = 'P190215151449427' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250939'
                WHERE ordernumber = 'P180215151546818' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228492'
                WHERE ordernumber = 'P190215151648168' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374299'
                WHERE ordernumber = 'P190215151736991' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276776'
                WHERE ordernumber = 'P190215151936884' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363982'
                WHERE ordernumber = 'P200215152059630' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327916'
                WHERE ordernumber = 'P190215152146231' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377317'
                WHERE ordernumber = 'P190215152327975' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292620'
                WHERE ordernumber = 'P420215152422791' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377318'
                WHERE ordernumber = 'P180215153811296' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377319'
                WHERE ordernumber = 'P190215153949643' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314562'
                WHERE ordernumber = 'P180215154127504' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244313'
                WHERE ordernumber = 'P190215154334412' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346054'
                WHERE ordernumber = 'P180215154639863' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377320'
                WHERE ordernumber = 'P180215154919286' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278199'
                WHERE ordernumber = 'P180215155045902' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P420215155047213' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377321'
                WHERE ordernumber = 'P180215155516551' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377322'
                WHERE ordernumber = 'P180215155628925' 
            
2024-02-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377323'
                WHERE ordernumber = 'P180215155808301' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377324'
                WHERE ordernumber = 'P180215160039317' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375094'
                WHERE ordernumber = 'P420215160103565' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377325'
                WHERE ordernumber = 'P180215160214257' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377326'
                WHERE ordernumber = 'P180215160423792' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377329'
                WHERE ordernumber = 'P180215160547464' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331186'
                WHERE ordernumber = 'P200215160555853' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369334'
                WHERE ordernumber = 'P420215161010759' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343244'
                WHERE ordernumber = 'P420215161155759' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377331'
                WHERE ordernumber = 'P180215161247383' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377333'
                WHERE ordernumber = 'P180215161502122' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334226'
                WHERE ordernumber = 'P200215161856508' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273583'
                WHERE ordernumber = 'P200215161935970' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139190'
                WHERE ordernumber = 'P200215162239787' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139190'
                WHERE ordernumber = 'P200215162416238' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235583'
                WHERE ordernumber = 'P200215162558922' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235113'
                WHERE ordernumber = 'P200215162836418' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377336'
                WHERE ordernumber = 'P420215162849885' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245053'
                WHERE ordernumber = 'P200215163137700' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286160'
                WHERE ordernumber = 'P180215163611506' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377339'
                WHERE ordernumber = 'P200215163940492' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377340'
                WHERE ordernumber = 'P200215164034859' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81119'
                WHERE ordernumber = 'P180215164152226' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377341'
                WHERE ordernumber = 'P180215164408719' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377342'
                WHERE ordernumber = 'P200215164452542' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377344'
                WHERE ordernumber = 'P180215165254671' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377341'
                WHERE ordernumber = 'P190215165313270' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325832'
                WHERE ordernumber = 'P190215165413325' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377345'
                WHERE ordernumber = 'P180215165413173' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377222'
                WHERE ordernumber = 'P420215165632344' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377347'
                WHERE ordernumber = 'P180215165707284' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377346'
                WHERE ordernumber = 'P200215165721331' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377349'
                WHERE ordernumber = 'P180215170108385' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377350'
                WHERE ordernumber = 'P420215170140787' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377351'
                WHERE ordernumber = 'P180215170345133' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377352'
                WHERE ordernumber = 'P180215170515136' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236840'
                WHERE ordernumber = 'P200215170532750' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377349'
                WHERE ordernumber = 'P180215170846344' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287278'
                WHERE ordernumber = 'P190215170912945' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357700'
                WHERE ordernumber = 'P420215170918307' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377352'
                WHERE ordernumber = 'P180215171114503' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294309'
                WHERE ordernumber = 'P200215171217856' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375510'
                WHERE ordernumber = 'P180215171246337' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377355'
                WHERE ordernumber = 'P200215172128572' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343158'
                WHERE ordernumber = 'P190215172137232' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377356'
                WHERE ordernumber = 'P180215172157490' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270218'
                WHERE ordernumber = 'P200215172226912' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363412'
                WHERE ordernumber = 'P190215172239217' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132601'
                WHERE ordernumber = 'P180215172249193' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377357'
                WHERE ordernumber = 'P200215172616886' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289348'
                WHERE ordernumber = 'P420215172927746' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226174'
                WHERE ordernumber = 'P200215173030755' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357700'
                WHERE ordernumber = 'P420215173120785' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377359'
                WHERE ordernumber = 'P420215173320717' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339398'
                WHERE ordernumber = 'P420215173418916' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377360'
                WHERE ordernumber = 'P420215173714910' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377359'
                WHERE ordernumber = 'P420215174155132' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377361'
                WHERE ordernumber = 'P200215174749833' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377362'
                WHERE ordernumber = 'P200215174833957' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '45270'
                WHERE ordernumber = 'P200215175742412' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215698'
                WHERE ordernumber = 'P180215175809731' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377364'
                WHERE ordernumber = 'P180215175935374' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377365'
                WHERE ordernumber = 'P200215180051492' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288609'
                WHERE ordernumber = 'P180215180137542' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277354'
                WHERE ordernumber = 'P180215180310858' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377368'
                WHERE ordernumber = 'P420215180523557' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377369'
                WHERE ordernumber = 'P200215180826583' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303444'
                WHERE ordernumber = 'P200215180917765' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377371'
                WHERE ordernumber = 'P180215180943548' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135447'
                WHERE ordernumber = 'P180215181120447' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377370'
                WHERE ordernumber = 'P420215181227378' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163259'
                WHERE ordernumber = 'P200215181301997' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377373'
                WHERE ordernumber = 'P200215181405682' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239096'
                WHERE ordernumber = 'P200215181512294' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377375'
                WHERE ordernumber = 'P200215181606562' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345528'
                WHERE ordernumber = 'P420215182505678' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377378'
                WHERE ordernumber = 'P180215182612538' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223482'
                WHERE ordernumber = 'P180215182813353' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351140'
                WHERE ordernumber = 'P180215182926245' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368818'
                WHERE ordernumber = 'P420215182942861' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377379'
                WHERE ordernumber = 'P200215183048428' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209266'
                WHERE ordernumber = 'P180215183121786' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272269'
                WHERE ordernumber = 'P180215183627175' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375205'
                WHERE ordernumber = 'P180215184004411' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375205'
                WHERE ordernumber = 'P180215184020748' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375205'
                WHERE ordernumber = 'P180215184035239' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358364'
                WHERE ordernumber = 'P420215184051654' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351986'
                WHERE ordernumber = 'P200215184340773' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317600'
                WHERE ordernumber = 'P190215184451427' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348787'
                WHERE ordernumber = 'P200215184617756' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377381'
                WHERE ordernumber = 'P200215184713644' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348787'
                WHERE ordernumber = 'P200215184737857' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377382'
                WHERE ordernumber = 'P200215184950592' 
            
2024-02-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377382'
                WHERE ordernumber = 'P200215185028223' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377383'
                WHERE ordernumber = 'P420215185043897' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376952'
                WHERE ordernumber = 'P200215185234585' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377384'
                WHERE ordernumber = 'P180215185302907' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377386'
                WHERE ordernumber = 'P200215185754208' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342436'
                WHERE ordernumber = 'P420215190434224' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377388'
                WHERE ordernumber = 'P200215190641388' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377389'
                WHERE ordernumber = 'P200215190850363' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P200215191004600' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299361'
                WHERE ordernumber = 'P190215191453987' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206906'
                WHERE ordernumber = 'P190215191953345' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377392'
                WHERE ordernumber = 'P200215193730610' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377392'
                WHERE ordernumber = 'P200215193932207' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366074'
                WHERE ordernumber = 'P420215194206134' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102417'
                WHERE ordernumber = 'P190215194748365' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377390'
                WHERE ordernumber = 'P420215195140217' 
            
2024-02-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377395'
                WHERE ordernumber = 'P420215195835595'