2024-02-01 01:00:02 -- 將會員中心id寫入data-lake 2024-02-01 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-01-31%'; 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '286064' WHERE ordernumber = 'P200131110608578' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '280120' WHERE ordernumber = 'P190131110711882' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '373961' WHERE ordernumber = 'P530131110747293' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374398' WHERE ordernumber = 'P420131110746215' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374397' WHERE ordernumber = 'P180131110812196' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374391' WHERE ordernumber = 'P190131110845153' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '336285' WHERE ordernumber = 'P200131110855485' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '100914' WHERE ordernumber = 'P200131111012310' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '276021' WHERE ordernumber = 'P200131111148276' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374403' WHERE ordernumber = 'P420131111317965' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '146945' WHERE ordernumber = 'P180131111408873' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '356061' WHERE ordernumber = 'P420131111537620' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '287108' WHERE ordernumber = 'P190131111615240' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '118572' WHERE ordernumber = 'P200131111739963' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '287108' WHERE ordernumber = 'P180131111754812' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '124448' WHERE ordernumber = 'P420131111917745' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '263097' WHERE ordernumber = 'P180131112022636' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374407' WHERE ordernumber = 'P420131112038763' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '371908' WHERE ordernumber = 'P420131112147696' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374409' WHERE ordernumber = 'P420131112309115' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '254374' WHERE ordernumber = 'P190131112310133' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374410' WHERE ordernumber = 'P420131112426154' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374383' WHERE ordernumber = 'P190131112509281' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '276021' WHERE ordernumber = 'P200131112543277' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374394' WHERE ordernumber = 'P180131112657993' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '312643' WHERE ordernumber = 'P420131112718718' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374394' WHERE ordernumber = 'P180131112740830' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '115591' WHERE ordernumber = 'P200131112745498' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374394' WHERE ordernumber = 'P180131112830680' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '340773' WHERE ordernumber = 'P190131112835414' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '126743' WHERE ordernumber = 'P190131113045425' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '372682' WHERE ordernumber = 'P420131113241517' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374400' WHERE ordernumber = 'P180131113400502' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374400' WHERE ordernumber = 'P180131113425205' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '258427' WHERE ordernumber = 'P200131113429657' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '314831' WHERE ordernumber = 'P190131113431838' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374402' WHERE ordernumber = 'P180131113537289' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374415' WHERE ordernumber = 'P200131113620263' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374401' WHERE ordernumber = 'P190131113632191' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374402' WHERE ordernumber = 'P180131113643614' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374401' WHERE ordernumber = 'P190131113701484' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374406' WHERE ordernumber = 'P180131113744178' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '372491' WHERE ordernumber = 'P200131113752973' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374413' WHERE ordernumber = 'P180131113909765' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374413' WHERE ordernumber = 'P180131113935648' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '279660' WHERE ordernumber = 'P180131114028155' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374405' WHERE ordernumber = 'P190131114300165' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374412' WHERE ordernumber = 'P180131114321190' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374405' WHERE ordernumber = 'P190131114426435' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374411' WHERE ordernumber = 'P190131114504992' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374411' WHERE ordernumber = 'P190131114535429' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '337851' WHERE ordernumber = 'P180131114647996' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '337851' WHERE ordernumber = 'P180131114748277' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374408' WHERE ordernumber = 'P190131114810457' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '337423' WHERE ordernumber = 'P180131114855350' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374408' WHERE ordernumber = 'P190131114859178' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '269604' WHERE ordernumber = 'P200131114953665' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374248' WHERE ordernumber = 'P420131115047392' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374420' WHERE ordernumber = 'P190131115057518' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '371594' WHERE ordernumber = 'P420131115131907' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '99933' WHERE ordernumber = 'P200131115229137' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374101' WHERE ordernumber = 'P200131115350432' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '142332' WHERE ordernumber = 'P180131115535658' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '336966' WHERE ordernumber = 'P180131115706706' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '143775' WHERE ordernumber = 'P420131115855341' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374417' WHERE ordernumber = 'P180131115932764' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374417' WHERE ordernumber = 'P180131115953828' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374418' WHERE ordernumber = 'P190131120119289' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '269457' WHERE ordernumber = 'P180131120144857' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '138142' WHERE ordernumber = 'P200131120231761' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '237679' WHERE ordernumber = 'P180131120245352' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374424' WHERE ordernumber = 'P420131120313593' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '54356' WHERE ordernumber = 'P180131120401856' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374425' WHERE ordernumber = 'P420131120416914' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '351272' WHERE ordernumber = 'P180131120457788' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '319901' WHERE ordernumber = 'P420131120513959' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374426' WHERE ordernumber = 'P420131120603129' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374427' WHERE ordernumber = 'P420131120647597' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '373688' WHERE ordernumber = 'P420131120714643' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '374417' WHERE ordernumber = 'P180131120827648' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '90873' WHERE ordernumber = 'P420131120957513' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '93882' WHERE ordernumber = 'P420131121111347' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '99991' WHERE ordernumber = 'P190131121222280' 2024-02-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '356061' WHERE ordernumber = 'P420131121253939' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374421' WHERE ordernumber = 'P180131121337313' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374421' WHERE ordernumber = 'P180131121359995' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374433' WHERE ordernumber = 'P420131121427741' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '279310' WHERE ordernumber = 'P190131121515786' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '11229' WHERE ordernumber = 'P200131121638971' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374436' WHERE ordernumber = 'P180131121932526' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '207972' WHERE ordernumber = 'P200131122000665' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '346661' WHERE ordernumber = 'P420131122012709' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '313462' WHERE ordernumber = 'P180131122056626' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374428' WHERE ordernumber = 'P190131122317259' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '348906' WHERE ordernumber = 'P180131122324150' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374435' WHERE ordernumber = 'P180131122454469' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374431' WHERE ordernumber = 'P190131122545548' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '129715' WHERE ordernumber = 'P190131122716847' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '358698' WHERE ordernumber = 'P200131123044446' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '345205' WHERE ordernumber = 'P180131123223285' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '372265' WHERE ordernumber = 'P420131123432901' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '76620' WHERE ordernumber = 'P200131123536554' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '99933' WHERE ordernumber = 'P200131123635889' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '283959' WHERE ordernumber = 'P200131123855699' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '340795' WHERE ordernumber = 'P190131123917947' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '2185' WHERE ordernumber = 'P180131124032284' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '365228' WHERE ordernumber = 'P200131124052566' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '44681' WHERE ordernumber = 'P190131124107529' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374434' WHERE ordernumber = 'P180131124259589' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '341983' WHERE ordernumber = 'P420131124527208' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '94021' WHERE ordernumber = 'P200131124614960' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '372353' WHERE ordernumber = 'P200131124722500' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '99029' WHERE ordernumber = 'P180131125021183' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '263180' WHERE ordernumber = 'P420131125106932' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '90618' WHERE ordernumber = 'P200131125202535' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374442' WHERE ordernumber = 'P420131125252208' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '347616' WHERE ordernumber = 'P180131125301291' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '297418' WHERE ordernumber = 'P420131125428388' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '272572' WHERE ordernumber = 'P420131125508579' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '154926' WHERE ordernumber = 'P200131125553353' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '298474' WHERE ordernumber = 'P420131125814203' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '368163' WHERE ordernumber = 'P200131125920159' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '343365' WHERE ordernumber = 'P200131130115239' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '207694' WHERE ordernumber = 'P200131130604615' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '217661' WHERE ordernumber = 'P180131130643114' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '81546' WHERE ordernumber = 'P200131130841989' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '101741' WHERE ordernumber = 'P200131131037539' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '271251' WHERE ordernumber = 'P420131131140114' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '225379' WHERE ordernumber = 'P200131131249508' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '263180' WHERE ordernumber = 'P420131131322761' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '313978' WHERE ordernumber = 'P420131131510450' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '316113' WHERE ordernumber = 'P200131131552672' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '103830' WHERE ordernumber = 'P180131131827683' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '354128' WHERE ordernumber = 'P190131131855266' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '371919' WHERE ordernumber = 'P200131132726874' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '275905' WHERE ordernumber = 'P420131132753967' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '348860' WHERE ordernumber = 'P200131132844752' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '211508' WHERE ordernumber = 'P180131133027304' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374455' WHERE ordernumber = 'P190131133120446' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374455' WHERE ordernumber = 'P190131133208214' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '367666' WHERE ordernumber = 'P180131133251885' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374453' WHERE ordernumber = 'P190131133342620' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '283943' WHERE ordernumber = 'P180131133402220' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '267034' WHERE ordernumber = 'P190131133620122' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '254447' WHERE ordernumber = 'P200131133704311' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374460' WHERE ordernumber = 'P420131133801801' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374462' WHERE ordernumber = 'P420131133950469' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '232251' WHERE ordernumber = 'P180131134304669' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '137708' WHERE ordernumber = 'P530131134759216' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '305962' WHERE ordernumber = 'P180131134856394' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '223478' WHERE ordernumber = 'P200131135116837' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '303662' WHERE ordernumber = 'P180131135838397' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374467' WHERE ordernumber = 'P180131140353837' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374467' WHERE ordernumber = 'P180131140413685' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '326714' WHERE ordernumber = 'P180131140939898' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374474' WHERE ordernumber = 'P420131141112433' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '252967' WHERE ordernumber = 'P200131141144258' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374475' WHERE ordernumber = 'P420131141255961' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '370971' WHERE ordernumber = 'P420131141437145' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '118908' WHERE ordernumber = 'P180131141524883' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '299661' WHERE ordernumber = 'P200131142108575' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '373261' WHERE ordernumber = 'P180131142437742' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374478' WHERE ordernumber = 'P420131142456561' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374307' WHERE ordernumber = 'P190131142507113' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374307' WHERE ordernumber = 'P190131142545176' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374480' WHERE ordernumber = 'P420131142626689' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '364420' WHERE ordernumber = 'P180131142812600' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '374481' WHERE ordernumber = 'P420131142931956' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '95695' WHERE ordernumber = 'P200131143001480' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '277109' WHERE ordernumber = 'P200131143046288' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '372471' WHERE ordernumber = 'P420131143057892' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '306735' WHERE ordernumber = 'P200131143208191' 2024-02-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '358090' WHERE ordernumber = 'P200131143332641' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '334880' WHERE ordernumber = 'P420131143403537' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '124325' WHERE ordernumber = 'P190131143434305' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '98026' WHERE ordernumber = 'P420131143510301' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '370519' WHERE ordernumber = 'P420131143605974' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374484' WHERE ordernumber = 'P420131143753154' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '367983' WHERE ordernumber = 'P420131143904954' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '221484' WHERE ordernumber = 'P200131144029370' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '299702' WHERE ordernumber = 'P420131144401833' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '373950' WHERE ordernumber = 'P420131144615186' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374487' WHERE ordernumber = 'P200131144629798' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374487' WHERE ordernumber = 'P200131144717991' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '219425' WHERE ordernumber = 'P180131144911983' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374491' WHERE ordernumber = 'P420131144936210' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '296416' WHERE ordernumber = 'P200131145018743' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374485' WHERE ordernumber = 'P180131145133491' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '346862' WHERE ordernumber = 'P200131145135737' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '207850' WHERE ordernumber = 'P420131145155953' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '97293' WHERE ordernumber = 'P420131145224732' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '325330' WHERE ordernumber = 'P420131145316257' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '293405' WHERE ordernumber = 'P180131145356203' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '33612' WHERE ordernumber = 'P200131145443685' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374494' WHERE ordernumber = 'P420131145509927' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374495' WHERE ordernumber = 'P200131145610506' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '314293' WHERE ordernumber = 'P200131145727509' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374498' WHERE ordernumber = 'P420131145835423' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374499' WHERE ordernumber = 'P420131145935642' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '62067' WHERE ordernumber = 'P200131145942657' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374501' WHERE ordernumber = 'P420131150058522' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374489' WHERE ordernumber = 'P180131150323312' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374504' WHERE ordernumber = 'P420131150402706' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374505' WHERE ordernumber = 'P420131150531843' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374506' WHERE ordernumber = 'P420131150636184' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374508' WHERE ordernumber = 'P420131150732684' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '366205' WHERE ordernumber = 'P200131150738799' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374509' WHERE ordernumber = 'P420131150825839' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374510' WHERE ordernumber = 'P200131150916130' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374511' WHERE ordernumber = 'P420131150936135' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '326303' WHERE ordernumber = 'P200131151006466' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '297027' WHERE ordernumber = 'P190131151048974' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374512' WHERE ordernumber = 'P420131151105498' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '244308' WHERE ordernumber = 'P200131151133975' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374513' WHERE ordernumber = 'P420131151204496' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '235847' WHERE ordernumber = 'P420131151242565' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374514' WHERE ordernumber = 'P420131151412149' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '90938' WHERE ordernumber = 'P200131151608370' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374515' WHERE ordernumber = 'P420131151639615' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '230680' WHERE ordernumber = 'P180131151750940' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374516' WHERE ordernumber = 'P420131151813114' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374517' WHERE ordernumber = 'P420131151914676' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '239648' WHERE ordernumber = 'P180131151950922' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374518' WHERE ordernumber = 'P420131152129329' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374520' WHERE ordernumber = 'P420131152214716' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '294660' WHERE ordernumber = 'P200131152305602' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '365864' WHERE ordernumber = 'P420131152312653' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374521' WHERE ordernumber = 'P420131152412133' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '127753' WHERE ordernumber = 'P420131152506812' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374523' WHERE ordernumber = 'P420131152610147' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374524' WHERE ordernumber = 'P420131152656757' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374525' WHERE ordernumber = 'P420131152747778' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '358283' WHERE ordernumber = 'P420131152855128' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '100837' WHERE ordernumber = 'P180131152955483' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374526' WHERE ordernumber = 'P420131152957516' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374527' WHERE ordernumber = 'P420131153104347' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '298988' WHERE ordernumber = 'P200131153136766' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374528' WHERE ordernumber = 'P420131153147194' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374529' WHERE ordernumber = 'P420131153308207' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374530' WHERE ordernumber = 'P420131153356457' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '352418' WHERE ordernumber = 'P190131153504859' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '368641' WHERE ordernumber = 'P200131153519565' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '280918' WHERE ordernumber = 'P420131153523464' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374531' WHERE ordernumber = 'P420131153630884' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '143625' WHERE ordernumber = 'P180131154157177' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '138105' WHERE ordernumber = 'P200131154307304' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '118631' WHERE ordernumber = 'P180131154341827' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374534' WHERE ordernumber = 'P420131154344915' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '240277' WHERE ordernumber = 'P420131154926533' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374536' WHERE ordernumber = 'P180131155132821' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374536' WHERE ordernumber = 'P180131155212380' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '273914' WHERE ordernumber = 'P180131155628804' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '103201' WHERE ordernumber = 'P180131155849557' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374514' WHERE ordernumber = 'P420131160258419' 2024-02-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '374537' WHERE ordernumber = 'P180131160444691' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '271302' WHERE ordernumber = 'P200131160528476' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '138929' WHERE ordernumber = 'P200131160855492' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '72048' WHERE ordernumber = 'P180131160912601' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '274520' WHERE ordernumber = 'P200131161001737' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '45494' WHERE ordernumber = 'P180131161058272' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374544' WHERE ordernumber = 'P180131161542542' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '282623' WHERE ordernumber = 'P190131161627239' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374547' WHERE ordernumber = 'P420131162209615' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '355548' WHERE ordernumber = 'P420131162753181' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374553' WHERE ordernumber = 'P420131163139338' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '306488' WHERE ordernumber = 'P200131163147912' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '338091' WHERE ordernumber = 'P180131163332620' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '322480' WHERE ordernumber = 'P200131164002919' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '330671' WHERE ordernumber = 'P420131164126307' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '322480' WHERE ordernumber = 'P200131164134324' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '372673' WHERE ordernumber = 'P420131164423821' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '322477' WHERE ordernumber = 'P180131164758400' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '119612' WHERE ordernumber = 'P180131165025683' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '119612' WHERE ordernumber = 'P180131165110652' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '93774' WHERE ordernumber = 'P180131165205612' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '347195' WHERE ordernumber = 'P530131165417320' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '348622' WHERE ordernumber = 'P180131171051878' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374206' WHERE ordernumber = 'P420131171116413' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '363108' WHERE ordernumber = 'P180131171209613' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '232257' WHERE ordernumber = 'P420131171546845' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '343932' WHERE ordernumber = 'P180131171603849' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '231701' WHERE ordernumber = 'P180131171743246' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374564' WHERE ordernumber = 'P420131171756139' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '352089' WHERE ordernumber = 'P420131171932644' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '364337' WHERE ordernumber = 'P180131171933113' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374562' WHERE ordernumber = 'P180131172213787' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '291412' WHERE ordernumber = 'P180131172520737' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '362215' WHERE ordernumber = 'P180131172847791' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '255573' WHERE ordernumber = 'P180131173835339' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '232128' WHERE ordernumber = 'P200131174101539' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '372854' WHERE ordernumber = 'P420131174312869' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '372854' WHERE ordernumber = 'P420131174346612' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374571' WHERE ordernumber = 'P180131174742551' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '373833' WHERE ordernumber = 'P420131174819638' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '364542' WHERE ordernumber = 'P180131175439460' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374578' WHERE ordernumber = 'P420131175708338' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '271937' WHERE ordernumber = 'P180131180307408' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374580' WHERE ordernumber = 'P420131181035885' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374581' WHERE ordernumber = 'P420131181156814' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '237283' WHERE ordernumber = 'P190131181159596' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374433' WHERE ordernumber = 'P420131181254302' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374062' WHERE ordernumber = 'P420131181405627' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374582' WHERE ordernumber = 'P420131181626311' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '223553' WHERE ordernumber = 'P420131181731858' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '307486' WHERE ordernumber = 'P420131181819271' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374584' WHERE ordernumber = 'P420131182052129' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374584' WHERE ordernumber = 'P530131182252911' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '345954' WHERE ordernumber = 'P420131182355294' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '120570' WHERE ordernumber = 'P180131182436972' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '358072' WHERE ordernumber = 'P200131182808340' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '113807' WHERE ordernumber = 'P180131183255950' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374590' WHERE ordernumber = 'P420131183843299' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '367024' WHERE ordernumber = 'P180131184234248' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '236188' WHERE ordernumber = 'P180131184520600' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374596' WHERE ordernumber = 'P180131184914948' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '372536' WHERE ordernumber = 'P420131184940653' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374597' WHERE ordernumber = 'P180131185139458' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374599' WHERE ordernumber = 'P420131185147685' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374601' WHERE ordernumber = 'P420131185811704' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '277810' WHERE ordernumber = 'P200131190104796' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '57052' WHERE ordernumber = 'P420131190121388' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374404' WHERE ordernumber = 'P420131190853951' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374404' WHERE ordernumber = 'P420131191028551' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '235646' WHERE ordernumber = 'P200131191126792' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374608' WHERE ordernumber = 'P200131191549870' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '209927' WHERE ordernumber = 'P180131191633723' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '337354' WHERE ordernumber = 'P420131191757875' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374609' WHERE ordernumber = 'P200131191801329' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '365731' WHERE ordernumber = 'P180131191821383' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '286450' WHERE ordernumber = 'P200131191939696' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '100936' WHERE ordernumber = 'P180131192237575' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '356635' WHERE ordernumber = 'P420131192244408' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '356635' WHERE ordernumber = 'P420131192412229' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374360' WHERE ordernumber = 'P420131192649666' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '265198' WHERE ordernumber = 'P180131193910796' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374619' WHERE ordernumber = 'P420131194847133' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374622' WHERE ordernumber = 'P420131195124266' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '349107' WHERE ordernumber = 'P420131195252757' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374624' WHERE ordernumber = 'P420131195659972' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374627' WHERE ordernumber = 'P420131200916609' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374630' WHERE ordernumber = 'P420131201355789' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '373555' WHERE ordernumber = 'P420131203642318' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '294683' WHERE ordernumber = 'P420131203806764' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '152024' WHERE ordernumber = 'P420131204344786' 2024-02-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '374643' WHERE ordernumber = 'P530131210020983' 2024-02-01 01:00:07 -- UPDATE `omo_order_list` SET userId = '247927' WHERE ordernumber = 'P420131210603931' 2024-02-01 01:00:07 -- UPDATE `omo_order_list` SET userId = '334506' WHERE ordernumber = 'P420131211615546'