2024-08-29 01:00:02 -- 將會員中心id寫入data-lake
2024-08-29 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-08-28%';
        
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342917'
                WHERE ordernumber = 'P630828101944121' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415115'
                WHERE ordernumber = 'P180828110232573' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115139'
                WHERE ordernumber = 'P180828110410918' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200828110435389' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154616'
                WHERE ordernumber = 'P200828110452345' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415118'
                WHERE ordernumber = 'P180828110535946' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '124677'
                WHERE ordernumber = 'P200828110546518' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287754'
                WHERE ordernumber = 'P180828110604782' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415119'
                WHERE ordernumber = 'P420828110642957' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414738'
                WHERE ordernumber = 'P200828110705807' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '91718'
                WHERE ordernumber = 'P200828110814698' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415119'
                WHERE ordernumber = 'P420828110923638' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190828110955627' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297105'
                WHERE ordernumber = 'P420828111412892' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415123'
                WHERE ordernumber = 'P180828111434188' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297136'
                WHERE ordernumber = 'P420828111528898' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415124'
                WHERE ordernumber = 'P190828111607743' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '68308'
                WHERE ordernumber = 'P180828111812401' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245453'
                WHERE ordernumber = 'P420828111946871' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415125'
                WHERE ordernumber = 'P180828112051600' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249673'
                WHERE ordernumber = 'P180828112412525' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415128'
                WHERE ordernumber = 'P200828112507769' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415130'
                WHERE ordernumber = 'P420828112539178' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415131'
                WHERE ordernumber = 'P190828112551733' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '149829'
                WHERE ordernumber = 'P180828113327216' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371797'
                WHERE ordernumber = 'P180828113453957' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296175'
                WHERE ordernumber = 'P420828113834886' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P200828113853129' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415137'
                WHERE ordernumber = 'P420828114036904' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415138'
                WHERE ordernumber = 'P420828114230620' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414575'
                WHERE ordernumber = 'P180828114253593' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406465'
                WHERE ordernumber = 'P180828114349265' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405650'
                WHERE ordernumber = 'P180828114658758' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415144'
                WHERE ordernumber = 'P180828114834899' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414007'
                WHERE ordernumber = 'P420828115001759' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414007'
                WHERE ordernumber = 'P420828115525199' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90887'
                WHERE ordernumber = 'P180828115601988' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415149'
                WHERE ordernumber = 'P420828115654430' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313279'
                WHERE ordernumber = 'P180828115936601' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415150'
                WHERE ordernumber = 'P180828120103307' 
            
2024-08-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206819'
                WHERE ordernumber = 'P190828120122892' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206819'
                WHERE ordernumber = 'P190828120221159' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413001'
                WHERE ordernumber = 'P420828120305262' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286632'
                WHERE ordernumber = 'P180828120721224' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337409'
                WHERE ordernumber = 'P180828120834654' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109673'
                WHERE ordernumber = 'P190828121206126' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415159'
                WHERE ordernumber = 'P180828121334767' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415162'
                WHERE ordernumber = 'P180828121555959' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415163'
                WHERE ordernumber = 'P420828121616350' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415166'
                WHERE ordernumber = 'P420828121912242' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298076'
                WHERE ordernumber = 'P200828121927714' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248311'
                WHERE ordernumber = 'P200828122228329' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415169'
                WHERE ordernumber = 'P200828122408650' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333961'
                WHERE ordernumber = 'P420828122411942' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412924'
                WHERE ordernumber = 'P200828122619143' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412924'
                WHERE ordernumber = 'P200828122627688' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413679'
                WHERE ordernumber = 'P420828122642681' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239380'
                WHERE ordernumber = 'P180828122657737' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327708'
                WHERE ordernumber = 'P420828122845210' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413679'
                WHERE ordernumber = 'P420828123004842' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415174'
                WHERE ordernumber = 'P200828123100444' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415172'
                WHERE ordernumber = 'P190828123205852' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415177'
                WHERE ordernumber = 'P180828123319812' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415179'
                WHERE ordernumber = 'P180828123558570' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415182'
                WHERE ordernumber = 'P180828123949798' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409940'
                WHERE ordernumber = 'P420828124026949' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406529'
                WHERE ordernumber = 'P180828124222963' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410429'
                WHERE ordernumber = 'P420828124405440' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415185'
                WHERE ordernumber = 'P180828124432489' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415188'
                WHERE ordernumber = 'P420828125244929' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415190'
                WHERE ordernumber = 'P180828125816706' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375069'
                WHERE ordernumber = 'P200828130330143' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415193'
                WHERE ordernumber = 'P180828130349267' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415195'
                WHERE ordernumber = 'P200828130751949' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161630'
                WHERE ordernumber = 'P200828131137164' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406985'
                WHERE ordernumber = 'P420828131431736' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336569'
                WHERE ordernumber = 'P420828131513792' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413541'
                WHERE ordernumber = 'P180828131541572' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413541'
                WHERE ordernumber = 'P180828131653659' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413541'
                WHERE ordernumber = 'P180828132130147' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415199'
                WHERE ordernumber = 'P180828132315611' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266863'
                WHERE ordernumber = 'P200828132410733' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329846'
                WHERE ordernumber = 'P180828132448146' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320351'
                WHERE ordernumber = 'P420828132519502' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320351'
                WHERE ordernumber = 'P420828132644576' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258005'
                WHERE ordernumber = 'P180828133300163' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415205'
                WHERE ordernumber = 'P420828133448834' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414544'
                WHERE ordernumber = 'P180828133450929' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414544'
                WHERE ordernumber = 'P180828133519280' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415207'
                WHERE ordernumber = 'P180828133658917' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277899'
                WHERE ordernumber = 'P200828133744880' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123989'
                WHERE ordernumber = 'P420828133841936' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395863'
                WHERE ordernumber = 'P180828134313232' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223893'
                WHERE ordernumber = 'P190828134801170' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415215'
                WHERE ordernumber = 'P200828134814506' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415216'
                WHERE ordernumber = 'P200828134924477' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415217'
                WHERE ordernumber = 'P420828134939737' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415220'
                WHERE ordernumber = 'P180828135051448' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415224'
                WHERE ordernumber = 'P180828135352685' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112916'
                WHERE ordernumber = 'P190828135444239' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415225'
                WHERE ordernumber = 'P200828135536832' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338004'
                WHERE ordernumber = 'P180828135738242' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415231'
                WHERE ordernumber = 'P420828140214779' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415235'
                WHERE ordernumber = 'P180828140452946' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404300'
                WHERE ordernumber = 'P420828140557125' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211162'
                WHERE ordernumber = 'P180828140617182' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335117'
                WHERE ordernumber = 'P180828140708475' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415241'
                WHERE ordernumber = 'P180828141306975' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415242'
                WHERE ordernumber = 'P420828141332423' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415243'
                WHERE ordernumber = 'P200828141605148' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227936'
                WHERE ordernumber = 'P180828141611555' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415244'
                WHERE ordernumber = 'P420828141638923' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415250'
                WHERE ordernumber = 'P180828142606134' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343769'
                WHERE ordernumber = 'P420828142909420' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415253'
                WHERE ordernumber = 'P420828143326614' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415256'
                WHERE ordernumber = 'P180828143845852' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410429'
                WHERE ordernumber = 'P420828143900816' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413026'
                WHERE ordernumber = 'P190828143935954' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414736'
                WHERE ordernumber = 'P420828143953831' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406941'
                WHERE ordernumber = 'P420828144131113' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124677'
                WHERE ordernumber = 'P200828144249779' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106194'
                WHERE ordernumber = 'P180828144305605' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381096'
                WHERE ordernumber = 'P180828144411762' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124677'
                WHERE ordernumber = 'P200828144440991' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415262'
                WHERE ordernumber = 'P190828144800973' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132502'
                WHERE ordernumber = 'P180828144850881' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415264'
                WHERE ordernumber = 'P200828145008834' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415266'
                WHERE ordernumber = 'P190828145009200' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123880'
                WHERE ordernumber = 'P180828145027158' 
            
2024-08-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402089'
                WHERE ordernumber = 'P180828145330952' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415269'
                WHERE ordernumber = 'P180828145623412' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405044'
                WHERE ordernumber = 'P420828145637648' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357631'
                WHERE ordernumber = 'P180828145947540' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230187'
                WHERE ordernumber = 'P190828150036256' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357631'
                WHERE ordernumber = 'P180828150037963' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98582'
                WHERE ordernumber = 'P200828150050602' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382319'
                WHERE ordernumber = 'P200828150217931' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319554'
                WHERE ordernumber = 'P420828150313580' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230187'
                WHERE ordernumber = 'P190828150439735' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388329'
                WHERE ordernumber = 'P180828150714581' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180828150939169' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368724'
                WHERE ordernumber = 'P630828150953885' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415277'
                WHERE ordernumber = 'P190828151419395' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '176323'
                WHERE ordernumber = 'P180828151428755' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415277'
                WHERE ordernumber = 'P180828151522476' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415279'
                WHERE ordernumber = 'P190828151621699' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415280'
                WHERE ordernumber = 'P180828151929456' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415284'
                WHERE ordernumber = 'P180828152202817' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389005'
                WHERE ordernumber = 'P180828152331695' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415286'
                WHERE ordernumber = 'P190828152804611' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351726'
                WHERE ordernumber = 'P200828152857673' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415229'
                WHERE ordernumber = 'P180828153145626' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394365'
                WHERE ordernumber = 'P420828153322731' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414995'
                WHERE ordernumber = 'P190828153326824' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408543'
                WHERE ordernumber = 'P180828153757587' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405698'
                WHERE ordernumber = 'P420828153847476' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400150'
                WHERE ordernumber = 'P180828154029147' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415229'
                WHERE ordernumber = 'P180828154136704' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94980'
                WHERE ordernumber = 'P180828154553911' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222836'
                WHERE ordernumber = 'P420828154638791' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415293'
                WHERE ordernumber = 'P180828154703217' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406105'
                WHERE ordernumber = 'P200828154801478' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405698'
                WHERE ordernumber = 'P420828154847339' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415295'
                WHERE ordernumber = 'P180828154848695' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415299'
                WHERE ordernumber = 'P420828155041855' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415301'
                WHERE ordernumber = 'P180828155231594' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415302'
                WHERE ordernumber = 'P200828155238753' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415306'
                WHERE ordernumber = 'P200828155430398' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415305'
                WHERE ordernumber = 'P180828155439311' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415307'
                WHERE ordernumber = 'P180828155556767' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253422'
                WHERE ordernumber = 'P630828155606593' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415309'
                WHERE ordernumber = 'P190828155648244' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234582'
                WHERE ordernumber = 'P420828155650520' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '70336'
                WHERE ordernumber = 'P180828155939442' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415313'
                WHERE ordernumber = 'P420828160034866' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415316'
                WHERE ordernumber = 'P180828160322145' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '172513'
                WHERE ordernumber = 'P200828160355117' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415318'
                WHERE ordernumber = 'P420828160408583' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '70336'
                WHERE ordernumber = 'P180828160451137' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100581'
                WHERE ordernumber = 'P180828160539787' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415322'
                WHERE ordernumber = 'P420828160709999' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413187'
                WHERE ordernumber = 'P420828160735443' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380616'
                WHERE ordernumber = 'P180828160840502' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '175455'
                WHERE ordernumber = 'P200828160929771' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415324'
                WHERE ordernumber = 'P420828161023214' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415325'
                WHERE ordernumber = 'P190828161140441' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415326'
                WHERE ordernumber = 'P420828161156173' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411638'
                WHERE ordernumber = 'P180828161342297' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415328'
                WHERE ordernumber = 'P200828161501652' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339282'
                WHERE ordernumber = 'P420828161808619' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409890'
                WHERE ordernumber = 'P180828161823760' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394142'
                WHERE ordernumber = 'P420828162126377' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415334'
                WHERE ordernumber = 'P180828162309476' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409042'
                WHERE ordernumber = 'P190828162346134' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415337'
                WHERE ordernumber = 'P180828162728671' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415340'
                WHERE ordernumber = 'P180828163055226' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415331'
                WHERE ordernumber = 'P420828163208775' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415342'
                WHERE ordernumber = 'P180828163320180' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275485'
                WHERE ordernumber = 'P420828163346775' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105116'
                WHERE ordernumber = 'P200828163447498' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407601'
                WHERE ordernumber = 'P200828163659893' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414162'
                WHERE ordernumber = 'P420828163700816' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415340'
                WHERE ordernumber = 'P180828163823433' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415349'
                WHERE ordernumber = 'P180828164014795' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415353'
                WHERE ordernumber = 'P190828164111705' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386367'
                WHERE ordernumber = 'P180828164123541' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160518'
                WHERE ordernumber = 'P190828164159276' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415355'
                WHERE ordernumber = 'P180828164312303' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P200828164826645' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249813'
                WHERE ordernumber = 'P180828164924390' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348233'
                WHERE ordernumber = 'P180828165117285' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229170'
                WHERE ordernumber = 'P420828165138776' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306995'
                WHERE ordernumber = 'P200828165417892' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415360'
                WHERE ordernumber = 'P180828165532822' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415362'
                WHERE ordernumber = 'P420828165614451' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '70209'
                WHERE ordernumber = 'P420828165708371' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415363'
                WHERE ordernumber = 'P200828165713586' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '70209'
                WHERE ordernumber = 'P420828165903172' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296067'
                WHERE ordernumber = 'P420828170113812' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403142'
                WHERE ordernumber = 'P180828170509490' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415367'
                WHERE ordernumber = 'P190828170705869' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411711'
                WHERE ordernumber = 'P190828171142261' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288264'
                WHERE ordernumber = 'P200828171206636' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267344'
                WHERE ordernumber = 'P200828171446132' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415117'
                WHERE ordernumber = 'P180828171455475' 
            
2024-08-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413032'
                WHERE ordernumber = 'P420828171503498' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415362'
                WHERE ordernumber = 'P420828171651694' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415375'
                WHERE ordernumber = 'P420828171806446' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415376'
                WHERE ordernumber = 'P200828172015292' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415378'
                WHERE ordernumber = 'P180828172021455' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415379'
                WHERE ordernumber = 'P420828172055684' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415381'
                WHERE ordernumber = 'P180828172209310' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190828172425341' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415382'
                WHERE ordernumber = 'P420828172515598' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380671'
                WHERE ordernumber = 'P180828173118345' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415387'
                WHERE ordernumber = 'P200828173308672' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415389'
                WHERE ordernumber = 'P180828173315991' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415393'
                WHERE ordernumber = 'P190828173643251' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '79984'
                WHERE ordernumber = 'P200828173657486' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415395'
                WHERE ordernumber = 'P180828173741236' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415396'
                WHERE ordernumber = 'P420828174142701' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412193'
                WHERE ordernumber = 'P420828174346337' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415397'
                WHERE ordernumber = 'P180828174447402' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334525'
                WHERE ordernumber = 'P420828174644618' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394414'
                WHERE ordernumber = 'P200828174706226' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407998'
                WHERE ordernumber = 'P190828174820564' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '83410'
                WHERE ordernumber = 'P180828174825234' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415402'
                WHERE ordernumber = 'P200828175001661' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415404'
                WHERE ordernumber = 'P200828175054298' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415403'
                WHERE ordernumber = 'P180828175055773' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415406'
                WHERE ordernumber = 'P190828175122665' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P180828175202532' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415410'
                WHERE ordernumber = 'P180828175813954' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306150'
                WHERE ordernumber = 'P180828180344341' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415413'
                WHERE ordernumber = 'P200828180457880' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394851'
                WHERE ordernumber = 'P420828180542744' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415415'
                WHERE ordernumber = 'P180828180730643' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415416'
                WHERE ordernumber = 'P190828180940432' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415418'
                WHERE ordernumber = 'P180828181033355' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398615'
                WHERE ordernumber = 'P200828181209652' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415421'
                WHERE ordernumber = 'P180828181213744' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212232'
                WHERE ordernumber = 'P180828181324368' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415414'
                WHERE ordernumber = 'P200828181342209' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384186'
                WHERE ordernumber = 'P180828181434160' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415414'
                WHERE ordernumber = 'P200828181500533' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297640'
                WHERE ordernumber = 'P200828181724465' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415426'
                WHERE ordernumber = 'P200828182021655' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '22085'
                WHERE ordernumber = 'P420828182145742' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248196'
                WHERE ordernumber = 'P200828182312810' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415427'
                WHERE ordernumber = 'P200828182437827' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415428'
                WHERE ordernumber = 'P200828182651577' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '260853'
                WHERE ordernumber = 'P180828182804271' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414899'
                WHERE ordernumber = 'P420828182957936' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94993'
                WHERE ordernumber = 'P200828183227758' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415433'
                WHERE ordernumber = 'P180828183327221' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286323'
                WHERE ordernumber = 'P180828183518756' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415439'
                WHERE ordernumber = 'P190828183655336' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325362'
                WHERE ordernumber = 'P420828183659179' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415439'
                WHERE ordernumber = 'P190828183745455' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415441'
                WHERE ordernumber = 'P200828184256233' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359823'
                WHERE ordernumber = 'P200828184352555' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415443'
                WHERE ordernumber = 'P180828184420642' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415444'
                WHERE ordernumber = 'P190828184609124' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390242'
                WHERE ordernumber = 'P200828184733604' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415445'
                WHERE ordernumber = 'P420828184809892' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213847'
                WHERE ordernumber = 'P590828184832911' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415450'
                WHERE ordernumber = 'P190828185414545' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '29379'
                WHERE ordernumber = 'P200828185757148' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338088'
                WHERE ordernumber = 'P190828190154384' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341550'
                WHERE ordernumber = 'P200828190213314' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415458'
                WHERE ordernumber = 'P190828190616135' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P630828191524224' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415464'
                WHERE ordernumber = 'P200828191758345' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393998'
                WHERE ordernumber = 'P200828191838351' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303738'
                WHERE ordernumber = 'P200828192010993' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415467'
                WHERE ordernumber = 'P190828192109858' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415469'
                WHERE ordernumber = 'P200828192457416' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110751'
                WHERE ordernumber = 'P190828192749967' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127851'
                WHERE ordernumber = 'P190828192910909' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '216322'
                WHERE ordernumber = 'P190828193009742' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415476'
                WHERE ordernumber = 'P190828193232723' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415478'
                WHERE ordernumber = 'P190828194220818' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '78849'
                WHERE ordernumber = 'P190828194531459' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P190828194838207' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368242'
                WHERE ordernumber = 'P200828195039170' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '170389'
                WHERE ordernumber = 'P190828195058634' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415243'
                WHERE ordernumber = 'P200828195340678' 
            
2024-08-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414402'
                WHERE ordernumber = 'P200828195512529'