2024-07-04 01:00:03 -- 將會員中心id寫入data-lake
2024-07-04 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-07-03%';
        
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377003'
                WHERE ordernumber = 'P630703100630247' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399472'
                WHERE ordernumber = 'P630703102758202' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399475'
                WHERE ordernumber = 'P630703103730205' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399476'
                WHERE ordernumber = 'P630703105225904' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399477'
                WHERE ordernumber = 'P630703105327977' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399478'
                WHERE ordernumber = 'P630703105927139' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305246'
                WHERE ordernumber = 'P420703110452985' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '3720'
                WHERE ordernumber = 'P180703110509263' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284262'
                WHERE ordernumber = 'P180703110814157' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399480'
                WHERE ordernumber = 'P200703110833994' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399481'
                WHERE ordernumber = 'P200703110934680' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392812'
                WHERE ordernumber = 'P200703111151655' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399482'
                WHERE ordernumber = 'P200703111625720' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162716'
                WHERE ordernumber = 'P180703111655250' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399483'
                WHERE ordernumber = 'P420703111814718' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399484'
                WHERE ordernumber = 'P420703112002609' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399485'
                WHERE ordernumber = 'P180703112051533' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399486'
                WHERE ordernumber = 'P420703112119967' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P420703112204874' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399487'
                WHERE ordernumber = 'P180703112323680' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399488'
                WHERE ordernumber = 'P180703112738154' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399489'
                WHERE ordernumber = 'P420703112856637' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399490'
                WHERE ordernumber = 'P180703113201783' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399491'
                WHERE ordernumber = 'P190703113211871' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399492'
                WHERE ordernumber = 'P190703113432461' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310580'
                WHERE ordernumber = 'P190703113538613' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250190'
                WHERE ordernumber = 'P200703113729752' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399494'
                WHERE ordernumber = 'P200703113849892' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224449'
                WHERE ordernumber = 'P180703113854365' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399495'
                WHERE ordernumber = 'P190703113920815' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398645'
                WHERE ordernumber = 'P190703114244145' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223290'
                WHERE ordernumber = 'P420703114529156' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238518'
                WHERE ordernumber = 'P630703114603762' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399496'
                WHERE ordernumber = 'P630703114819403' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284074'
                WHERE ordernumber = 'P190703114934247' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244090'
                WHERE ordernumber = 'P190703115258586' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399497'
                WHERE ordernumber = 'P630703115314772' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313472'
                WHERE ordernumber = 'P180703115607505' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313464'
                WHERE ordernumber = 'P180703115718629' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399498'
                WHERE ordernumber = 'P190703115750200' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P190703115852788' 
            
2024-07-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160734'
                WHERE ordernumber = 'P200703120152610' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399500'
                WHERE ordernumber = 'P630703120443410' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399499'
                WHERE ordernumber = 'P180703120509371' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98161'
                WHERE ordernumber = 'P630703120657619' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94648'
                WHERE ordernumber = 'P200703120753535' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399217'
                WHERE ordernumber = 'P190703120823602' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399501'
                WHERE ordernumber = 'P180703121039183' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399502'
                WHERE ordernumber = 'P180703121254570' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399503'
                WHERE ordernumber = 'P630703121437182' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399502'
                WHERE ordernumber = 'P180703121616892' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399504'
                WHERE ordernumber = 'P630703121859657' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397764'
                WHERE ordernumber = 'P200703122031924' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397764'
                WHERE ordernumber = 'P200703122114444' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399508'
                WHERE ordernumber = 'P180703122355486' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399507'
                WHERE ordernumber = 'P200703122408945' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399506'
                WHERE ordernumber = 'P630703122512420' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275133'
                WHERE ordernumber = 'P200703123315905' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399510'
                WHERE ordernumber = 'P200703123435782' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398969'
                WHERE ordernumber = 'P630703124446871' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387108'
                WHERE ordernumber = 'P200703124528576' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302814'
                WHERE ordernumber = 'P200703125133774' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241316'
                WHERE ordernumber = 'P200703125826905' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399512'
                WHERE ordernumber = 'P200703130300552' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399514'
                WHERE ordernumber = 'P630703130527912' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98729'
                WHERE ordernumber = 'P200703130707906' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399516'
                WHERE ordernumber = 'P180703130912271' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399515'
                WHERE ordernumber = 'P630703130938901' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98509'
                WHERE ordernumber = 'P200703131159250' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113510'
                WHERE ordernumber = 'P180703131321791' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274967'
                WHERE ordernumber = 'P180703131900615' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399517'
                WHERE ordernumber = 'P200703132053262' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98634'
                WHERE ordernumber = 'P200703132130164' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397488'
                WHERE ordernumber = 'P180703132556340' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334915'
                WHERE ordernumber = 'P590703132616708' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399519'
                WHERE ordernumber = 'P630703133010303' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399518'
                WHERE ordernumber = 'P420703133013904' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399520'
                WHERE ordernumber = 'P420703133447562' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388070'
                WHERE ordernumber = 'P180703133618554' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399522'
                WHERE ordernumber = 'P180703134334121' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399523'
                WHERE ordernumber = 'P180703134842880' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391763'
                WHERE ordernumber = 'P180703140237201' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394528'
                WHERE ordernumber = 'P200703140252271' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399525'
                WHERE ordernumber = 'P200703140721789' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380883'
                WHERE ordernumber = 'P420703141138366' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399527'
                WHERE ordernumber = 'P630703141209627' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399528'
                WHERE ordernumber = 'P180703141311128' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399529'
                WHERE ordernumber = 'P200703141540644' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397717'
                WHERE ordernumber = 'P180703142034444' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399530'
                WHERE ordernumber = 'P180703142412146' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94993'
                WHERE ordernumber = 'P200703142605410' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135579'
                WHERE ordernumber = 'P180703142710227' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236895'
                WHERE ordernumber = 'P190703143436234' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236895'
                WHERE ordernumber = 'P190703143625555' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399531'
                WHERE ordernumber = 'P200703143750334' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330642'
                WHERE ordernumber = 'P420703144546356' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P180703145202803' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280881'
                WHERE ordernumber = 'P200703145306619' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399533'
                WHERE ordernumber = 'P200703145351945' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399534'
                WHERE ordernumber = 'P180703145659591' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P200703150140964' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399535'
                WHERE ordernumber = 'P180703150203262' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399535'
                WHERE ordernumber = 'P180703150205271' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399537'
                WHERE ordernumber = 'P180703151519470' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399536'
                WHERE ordernumber = 'P630703151539305' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115120'
                WHERE ordernumber = 'P200703151712301' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399538'
                WHERE ordernumber = 'P200703152412861' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399539'
                WHERE ordernumber = 'P180703152844355' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311208'
                WHERE ordernumber = 'P200703152931113' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339173'
                WHERE ordernumber = 'P180703153304850' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399541'
                WHERE ordernumber = 'P180703153852458' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87785'
                WHERE ordernumber = 'P200703154123737' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399542'
                WHERE ordernumber = 'P630703154147255' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399543'
                WHERE ordernumber = 'P180703154540723' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P420703154929133' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399545'
                WHERE ordernumber = 'P420703155355136' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420703155716869' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229303'
                WHERE ordernumber = 'P200703155822225' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399546'
                WHERE ordernumber = 'P200703160243173' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119418'
                WHERE ordernumber = 'P180703160842719' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399547'
                WHERE ordernumber = 'P200703161250714' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286322'
                WHERE ordernumber = 'P180703162137677' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286322'
                WHERE ordernumber = 'P180703162236299' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399549'
                WHERE ordernumber = 'P420703162506950' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136759'
                WHERE ordernumber = 'P180703162628834' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100376'
                WHERE ordernumber = 'P180703162748263' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259725'
                WHERE ordernumber = 'P180703162835681' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111709'
                WHERE ordernumber = 'P190703162847920' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399550'
                WHERE ordernumber = 'P180703162927457' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290206'
                WHERE ordernumber = 'P200703163857328' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112395'
                WHERE ordernumber = 'P200703163900765' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399552'
                WHERE ordernumber = 'P200703164030304' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399553'
                WHERE ordernumber = 'P420703164030763' 
            
2024-07-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98706'
                WHERE ordernumber = 'P200703164227351' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399554'
                WHERE ordernumber = 'P180703164242973' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380616'
                WHERE ordernumber = 'P190703164330868' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275321'
                WHERE ordernumber = 'P180703164517913' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399555'
                WHERE ordernumber = 'P630703164904893' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399239'
                WHERE ordernumber = 'P180703165014511' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '82371'
                WHERE ordernumber = 'P190703165015135' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399556'
                WHERE ordernumber = 'P420703165345871' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381778'
                WHERE ordernumber = 'P420703165514499' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399558'
                WHERE ordernumber = 'P180703165913522' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399560'
                WHERE ordernumber = 'P180703170627891' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276021'
                WHERE ordernumber = 'P200703170721420' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399561'
                WHERE ordernumber = 'P180703170832396' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399562'
                WHERE ordernumber = 'P200703170838936' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249085'
                WHERE ordernumber = 'P190703171222140' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118999'
                WHERE ordernumber = 'P200703171317383' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399563'
                WHERE ordernumber = 'P200703171527514' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200703171816534' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399565'
                WHERE ordernumber = 'P180703173217923' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399566'
                WHERE ordernumber = 'P190703173354841' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '322629'
                WHERE ordernumber = 'P420703173453490' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235835'
                WHERE ordernumber = 'P180703173715198' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235835'
                WHERE ordernumber = 'P180703173837434' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399567'
                WHERE ordernumber = 'P180703173958213' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399570'
                WHERE ordernumber = 'P190703174457598' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399569'
                WHERE ordernumber = 'P180703174527724' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399237'
                WHERE ordernumber = 'P180703175047963' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399572'
                WHERE ordernumber = 'P630703175429674' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399573'
                WHERE ordernumber = 'P180703175528703' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399574'
                WHERE ordernumber = 'P180703175727958' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295306'
                WHERE ordernumber = 'P180703175917982' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376025'
                WHERE ordernumber = 'P420703180047595' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275564'
                WHERE ordernumber = 'P180703180123407' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399576'
                WHERE ordernumber = 'P200703180259387' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399577'
                WHERE ordernumber = 'P630703180307853' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348779'
                WHERE ordernumber = 'P180703180920195' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '138850'
                WHERE ordernumber = 'P200703180937290' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111546'
                WHERE ordernumber = 'P180703181102342' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '63005'
                WHERE ordernumber = 'P200703181415445' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399579'
                WHERE ordernumber = 'P630703181702500' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225662'
                WHERE ordernumber = 'P630703182645957' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399581'
                WHERE ordernumber = 'P420703182652196' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128516'
                WHERE ordernumber = 'P180703183041918' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161057'
                WHERE ordernumber = 'P420703183518636' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399583'
                WHERE ordernumber = 'P200703183750900' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399524'
                WHERE ordernumber = 'P200703184415332' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '259709'
                WHERE ordernumber = 'P190703184419201' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399585'
                WHERE ordernumber = 'P200703184545863' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110716'
                WHERE ordernumber = 'P200703184803198' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399586'
                WHERE ordernumber = 'P190703185037532' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399587'
                WHERE ordernumber = 'P630703185231559' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399588'
                WHERE ordernumber = 'P190703185450999' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315107'
                WHERE ordernumber = 'P190703185613193' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399589'
                WHERE ordernumber = 'P200703185732864' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399590'
                WHERE ordernumber = 'P200703185909317' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399336'
                WHERE ordernumber = 'P200703190107701' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399591'
                WHERE ordernumber = 'P190703190132860' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212677'
                WHERE ordernumber = 'P190703191037980' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200703191156703' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '210626'
                WHERE ordernumber = 'P630703191334729' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219994'
                WHERE ordernumber = 'P190703191356911' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102172'
                WHERE ordernumber = 'P190703191506720' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386795'
                WHERE ordernumber = 'P200703191727958' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399593'
                WHERE ordernumber = 'P200703193036879' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299615'
                WHERE ordernumber = 'P190703193139912' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399594'
                WHERE ordernumber = 'P190703193320809' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399464'
                WHERE ordernumber = 'P200703193433585' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287840'
                WHERE ordernumber = 'P200703193630699' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399596'
                WHERE ordernumber = 'P200703193950165' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399597'
                WHERE ordernumber = 'P630703194049362' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345012'
                WHERE ordernumber = 'P190703194127370' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399598'
                WHERE ordernumber = 'P630703194554422' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399599'
                WHERE ordernumber = 'P200703194725323' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399600'
                WHERE ordernumber = 'P200703195238455' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399601'
                WHERE ordernumber = 'P200703195314493' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399603'
                WHERE ordernumber = 'P200703195400322' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399602'
                WHERE ordernumber = 'P190703195420683' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399605'
                WHERE ordernumber = 'P630703195914378' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399607'
                WHERE ordernumber = 'P590703202640685' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399608'
                WHERE ordernumber = 'P630703204213142' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '78110'
                WHERE ordernumber = 'P590703205449137' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399605'
                WHERE ordernumber = 'P630703211539471' 
            
2024-07-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399610'
                WHERE ordernumber = 'P590703211647472'