2024-01-08 01:00:02 -- 將會員中心id寫入data-lake 2024-01-08 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-07%'; 2024-01-08 01:00:02 -- UPDATE `omo_order_list` SET userId = '360739' WHERE ordernumber = 'P420107101507490' 2024-01-08 01:00:02 -- UPDATE `omo_order_list` SET userId = '360765' WHERE ordernumber = 'P420107104042599' 2024-01-08 01:00:02 -- UPDATE `omo_order_list` SET userId = '360768' WHERE ordernumber = 'P420107104400678' 2024-01-08 01:00:02 -- UPDATE `omo_order_list` SET userId = '341398' WHERE ordernumber = 'P420107105439937' 2024-01-08 01:00:02 -- UPDATE `omo_order_list` SET userId = '360779' WHERE ordernumber = 'P420107110123756' 2024-01-08 01:00:02 -- UPDATE `omo_order_list` SET userId = '301559' WHERE ordernumber = 'P420107110209565' 2024-01-08 01:00:02 -- UPDATE `omo_order_list` SET userId = '134860' WHERE ordernumber = 'P180107110345710' 2024-01-08 01:00:02 -- UPDATE `omo_order_list` SET userId = '360786' WHERE ordernumber = 'P180107110730408' 2024-01-08 01:00:02 -- UPDATE `omo_order_list` SET userId = '97151' WHERE ordernumber = 'P200107110740927' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360788' WHERE ordernumber = 'P420107110800834' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '222823' WHERE ordernumber = 'P190107110816601' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '156047' WHERE ordernumber = 'P180107110954946' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360778' WHERE ordernumber = 'P190107111158208' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360778' WHERE ordernumber = 'P190107111227519' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '357770' WHERE ordernumber = 'P420107111305472' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '225810' WHERE ordernumber = 'P200107111355672' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360801' WHERE ordernumber = 'P420107111653723' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '333459' WHERE ordernumber = 'P180107111825458' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '237104' WHERE ordernumber = 'P200107111900434' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360809' WHERE ordernumber = 'P200107112020119' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360812' WHERE ordernumber = 'P420107112112249' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '339173' WHERE ordernumber = 'P190107112135242' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '353020' WHERE ordernumber = 'P190107112218654' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '275427' WHERE ordernumber = 'P200107112254953' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '350777' WHERE ordernumber = 'P420107112333943' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '350985' WHERE ordernumber = 'P190107112333717' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360817' WHERE ordernumber = 'P200107112434267' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '352043' WHERE ordernumber = 'P180107112444633' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '97151' WHERE ordernumber = 'P200107112500965' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '141605' WHERE ordernumber = 'P180107112712114' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360803' WHERE ordernumber = 'P200107112838562' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '339929' WHERE ordernumber = 'P420107113229788' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '357385' WHERE ordernumber = 'P180107113259112' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '240565' WHERE ordernumber = 'P200107113310644' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360803' WHERE ordernumber = 'P200107113614690' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360832' WHERE ordernumber = 'P180107113741611' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '340912' WHERE ordernumber = 'P200107113756986' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360834' WHERE ordernumber = 'P420107113851487' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '347035' WHERE ordernumber = 'P180107113938468' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360828' WHERE ordernumber = 'P200107114042699' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360819' WHERE ordernumber = 'P190107114147322' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360840' WHERE ordernumber = 'P190107114318135' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360839' WHERE ordernumber = 'P200107114351893' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360842' WHERE ordernumber = 'P190107114645210' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '267420' WHERE ordernumber = 'P200107114809903' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '218069' WHERE ordernumber = 'P180107115141557' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '344837' WHERE ordernumber = 'P200107115442210' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360850' WHERE ordernumber = 'P180107115854197' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '357330' WHERE ordernumber = 'P190107115903347' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '36187' WHERE ordernumber = 'P200107120258730' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360850' WHERE ordernumber = 'P180107120558306' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360857' WHERE ordernumber = 'P420107120611233' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360857' WHERE ordernumber = 'P420107120752292' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '287888' WHERE ordernumber = 'P190107121316811' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '325175' WHERE ordernumber = 'P200107121348311' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360864' WHERE ordernumber = 'P180107121509676' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '243411' WHERE ordernumber = 'P420107121612217' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '49065' WHERE ordernumber = 'P180107122105973' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360873' WHERE ordernumber = 'P420107122635598' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '280062' WHERE ordernumber = 'P180107122657305' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '314562' WHERE ordernumber = 'P190107122754345' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360876' WHERE ordernumber = 'P180107122810428' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '106911' WHERE ordernumber = 'P200107122926484' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360879' WHERE ordernumber = 'P180107122928920' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360881' WHERE ordernumber = 'P190107122942151' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360883' WHERE ordernumber = 'P420107123103129' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '328566' WHERE ordernumber = 'P180107123128289' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360884' WHERE ordernumber = 'P180107123335959' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360888' WHERE ordernumber = 'P200107123422668' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360890' WHERE ordernumber = 'P180107123712371' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360891' WHERE ordernumber = 'P200107123743840' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '280143' WHERE ordernumber = 'P180107123903751' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '280143' WHERE ordernumber = 'P180107123948365' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '237429' WHERE ordernumber = 'P180107124200947' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360897' WHERE ordernumber = 'P200107124235634' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '234543' WHERE ordernumber = 'P190107124325180' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360898' WHERE ordernumber = 'P180107124335577' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360900' WHERE ordernumber = 'P180107124421662' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '209575' WHERE ordernumber = 'P180107124455433' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360904' WHERE ordernumber = 'P200107124639752' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360906' WHERE ordernumber = 'P190107124651538' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '342900' WHERE ordernumber = 'P190107124726250' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360909' WHERE ordernumber = 'P420107124809710' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360910' WHERE ordernumber = 'P200107124844733' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360908' WHERE ordernumber = 'P180107124846984' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '321976' WHERE ordernumber = 'P180107124928555' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360911' WHERE ordernumber = 'P200107124943681' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360912' WHERE ordernumber = 'P200107125029203' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '345022' WHERE ordernumber = 'P190107125057769' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360915' WHERE ordernumber = 'P180107125133676' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '248446' WHERE ordernumber = 'P180107125359665' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '225299' WHERE ordernumber = 'P200107125454480' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360920' WHERE ordernumber = 'P180107125534488' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360921' WHERE ordernumber = 'P200107125732610' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '353192' WHERE ordernumber = 'P190107125747361' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '81972' WHERE ordernumber = 'P200107125759894' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360922' WHERE ordernumber = 'P420107125800219' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '353192' WHERE ordernumber = 'P190107125826641' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '248446' WHERE ordernumber = 'P180107125848907' 2024-01-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '360926' WHERE ordernumber = 'P180107130010681' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '86479' WHERE ordernumber = 'P190107130018244' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360927' WHERE ordernumber = 'P190107130156398' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360929' WHERE ordernumber = 'P420107130245442' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360931' WHERE ordernumber = 'P200107130258643' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '214794' WHERE ordernumber = 'P180107130851220' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360939' WHERE ordernumber = 'P420107130909619' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360940' WHERE ordernumber = 'P180107131030137' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360941' WHERE ordernumber = 'P420107131211865' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360942' WHERE ordernumber = 'P180107131233458' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '99029' WHERE ordernumber = 'P180107131352200' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '133133' WHERE ordernumber = 'P180107131436782' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360944' WHERE ordernumber = 'P200107131442787' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360946' WHERE ordernumber = 'P180107131647620' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '101332' WHERE ordernumber = 'P200107131805117' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360953' WHERE ordernumber = 'P180107132109259' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360952' WHERE ordernumber = 'P420107132212886' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '248142' WHERE ordernumber = 'P180107132348326' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '356531' WHERE ordernumber = 'P200107132405877' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '96105' WHERE ordernumber = 'P200107132535304' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '61816' WHERE ordernumber = 'P420107132803917' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '279508' WHERE ordernumber = 'P180107132855744' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '287701' WHERE ordernumber = 'P200107133003809' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '317375' WHERE ordernumber = 'P180107133102347' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360975' WHERE ordernumber = 'P200107133314561' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '357289' WHERE ordernumber = 'P190107133459239' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360978' WHERE ordernumber = 'P420107133746861' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360981' WHERE ordernumber = 'P420107133837267' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360982' WHERE ordernumber = 'P180107133904482' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360984' WHERE ordernumber = 'P420107134042297' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360986' WHERE ordernumber = 'P190107134210956' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '277234' WHERE ordernumber = 'P190107134232708' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '222047' WHERE ordernumber = 'P180107134234771' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360987' WHERE ordernumber = 'P420107134308393' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '360989' WHERE ordernumber = 'P190107134313606' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '241501' WHERE ordernumber = 'P180107134458855' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '282905' WHERE ordernumber = 'P180107134558997' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361007' WHERE ordernumber = 'P180107135555413' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '349282' WHERE ordernumber = 'P180107135931262' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361016' WHERE ordernumber = 'P420107135951196' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '113793' WHERE ordernumber = 'P180107140051249' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361018' WHERE ordernumber = 'P190107140204442' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361020' WHERE ordernumber = 'P420107140213496' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361023' WHERE ordernumber = 'P420107140423230' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '348555' WHERE ordernumber = 'P190107140429545' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361024' WHERE ordernumber = 'P180107140505769' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '358966' WHERE ordernumber = 'P420107140614775' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361029' WHERE ordernumber = 'P190107141540642' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '255362' WHERE ordernumber = 'P190107141632630' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361034' WHERE ordernumber = 'P190107141849586' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '138433' WHERE ordernumber = 'P190107142123262' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361037' WHERE ordernumber = 'P190107142219243' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361038' WHERE ordernumber = 'P180107142314369' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '264740' WHERE ordernumber = 'P180107142345320' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '343274' WHERE ordernumber = 'P180107142457184' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361042' WHERE ordernumber = 'P190107142607478' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361044' WHERE ordernumber = 'P200107142630597' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361044' WHERE ordernumber = 'P200107142632380' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361042' WHERE ordernumber = 'P190107142643718' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '330795' WHERE ordernumber = 'P180107142700246' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361052' WHERE ordernumber = 'P200107142830323' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361056' WHERE ordernumber = 'P190107143156640' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '230868' WHERE ordernumber = 'P420107143509994' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '337889' WHERE ordernumber = 'P180107143700186' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '58018' WHERE ordernumber = 'P190107143703195' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '288868' WHERE ordernumber = 'P190107143730644' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '125335' WHERE ordernumber = 'P190107143847197' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361070' WHERE ordernumber = 'P190107143948684' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '122143' WHERE ordernumber = 'P190107144053883' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '102922' WHERE ordernumber = 'P420107144453178' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361086' WHERE ordernumber = 'P180107144619755' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '122143' WHERE ordernumber = 'P180107144819980' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '287104' WHERE ordernumber = 'P180107145118643' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '357003' WHERE ordernumber = 'P420107145125325' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '17684' WHERE ordernumber = 'P420107145227973' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '334532' WHERE ordernumber = 'P200107145241218' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361093' WHERE ordernumber = 'P190107145402690' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '318604' WHERE ordernumber = 'P180107145510885' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '158836' WHERE ordernumber = 'P200107145831238' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361096' WHERE ordernumber = 'P200107145926510' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '318854' WHERE ordernumber = 'P190107150454426' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361105' WHERE ordernumber = 'P180107150708234' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '350554' WHERE ordernumber = 'P200107150716118' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361109' WHERE ordernumber = 'P200107150759529' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '361105' WHERE ordernumber = 'P180107150855395' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '265702' WHERE ordernumber = 'P190107150901848' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '98869' WHERE ordernumber = 'P200107150939533' 2024-01-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '354500' WHERE ordernumber = 'P180107150956458' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361120' WHERE ordernumber = 'P180107151114751' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '353647' WHERE ordernumber = 'P190107151406813' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361125' WHERE ordernumber = 'P180107151419434' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '281545' WHERE ordernumber = 'P180107151515437' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361127' WHERE ordernumber = 'P200107151707164' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '290603' WHERE ordernumber = 'P420107152140469' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361140' WHERE ordernumber = 'P180107152332880' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361144' WHERE ordernumber = 'P200107152447888' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '264646' WHERE ordernumber = 'P180107152555731' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361146' WHERE ordernumber = 'P200107152610622' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '132144' WHERE ordernumber = 'P420107152646764' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361149' WHERE ordernumber = 'P180107152733268' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '241158' WHERE ordernumber = 'P180107152859899' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361151' WHERE ordernumber = 'P180107153115748' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361154' WHERE ordernumber = 'P200107153205315' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361159' WHERE ordernumber = 'P180107153449672' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361154' WHERE ordernumber = 'P200107153601874' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361163' WHERE ordernumber = 'P180107153736654' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '341398' WHERE ordernumber = 'P420107153827729' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361165' WHERE ordernumber = 'P180107153857310' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361162' WHERE ordernumber = 'P190107153913728' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '341570' WHERE ordernumber = 'P180107153943119' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '286631' WHERE ordernumber = 'P200107154102665' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '169376' WHERE ordernumber = 'P180107154628811' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361173' WHERE ordernumber = 'P180107154738478' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '241326' WHERE ordernumber = 'P190107154750975' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '360671' WHERE ordernumber = 'P180107154844660' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361182' WHERE ordernumber = 'P190107154930474' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361184' WHERE ordernumber = 'P200107155024252' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '360671' WHERE ordernumber = 'P180107155058598' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361193' WHERE ordernumber = 'P180107155308533' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '28872' WHERE ordernumber = 'P420107155426666' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '231825' WHERE ordernumber = 'P200107155528642' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361198' WHERE ordernumber = 'P180107155717710' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '74302' WHERE ordernumber = 'P200107155729332' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '320317' WHERE ordernumber = 'P200107155756959' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361198' WHERE ordernumber = 'P180107155816761' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '353647' WHERE ordernumber = 'P190107155903177' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361201' WHERE ordernumber = 'P180107155926283' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361213' WHERE ordernumber = 'P180107160858933' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '267616' WHERE ordernumber = 'P180107161031688' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361218' WHERE ordernumber = 'P180107161251460' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '281097' WHERE ordernumber = 'P200107161302279' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '345147' WHERE ordernumber = 'P180107161353796' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '165237' WHERE ordernumber = 'P200107161557657' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361223' WHERE ordernumber = 'P180107161706114' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '345622' WHERE ordernumber = 'P420107161923710' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '272986' WHERE ordernumber = 'P180107162248552' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361233' WHERE ordernumber = 'P200107162442555' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361235' WHERE ordernumber = 'P200107162548628' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '342844' WHERE ordernumber = 'P420107162750227' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361237' WHERE ordernumber = 'P180107162810199' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361240' WHERE ordernumber = 'P180107163002502' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361244' WHERE ordernumber = 'P180107163341296' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361244' WHERE ordernumber = 'P180107163420472' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '261147' WHERE ordernumber = 'P200107164139274' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '237681' WHERE ordernumber = 'P190107164259208' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361253' WHERE ordernumber = 'P180107164342486' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '163019' WHERE ordernumber = 'P200107164405849' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '345228' WHERE ordernumber = 'P180107164611367' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '100063' WHERE ordernumber = 'P200107164705195' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190107164806963' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '280479' WHERE ordernumber = 'P200107164955818' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190107165207316' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190107165313684' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '83902' WHERE ordernumber = 'P180107165354369' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '252973' WHERE ordernumber = 'P180107165425443' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190107165517880' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361272' WHERE ordernumber = 'P180107165552949' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190107165638591' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190107165818313' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190107170006630' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '309530' WHERE ordernumber = 'P180107170028548' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361276' WHERE ordernumber = 'P180107170155438' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '236685' WHERE ordernumber = 'P200107170240604' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '121531' WHERE ordernumber = 'P200107170325657' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361277' WHERE ordernumber = 'P180107170457448' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '311951' WHERE ordernumber = 'P200107170558448' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '269473' WHERE ordernumber = 'P200107170644215' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '360882' WHERE ordernumber = 'P180107170730142' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361280' WHERE ordernumber = 'P200107170739611' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190107170812686' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '282143' WHERE ordernumber = 'P200107170821706' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '141777' WHERE ordernumber = 'P420107171119382' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361282' WHERE ordernumber = 'P180107171122845' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '356275' WHERE ordernumber = 'P180107171208572' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '282143' WHERE ordernumber = 'P200107171229947' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '160727' WHERE ordernumber = 'P200107171954735' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361291' WHERE ordernumber = 'P180107172410887' 2024-01-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '361294' WHERE ordernumber = 'P180107172522922' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361295' WHERE ordernumber = 'P180107172623141' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361296' WHERE ordernumber = 'P180107172704645' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '214554' WHERE ordernumber = 'P200107172853772' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '356597' WHERE ordernumber = 'P180107172918763' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361303' WHERE ordernumber = 'P180107173032899' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '351741' WHERE ordernumber = 'P180107173250889' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '245652' WHERE ordernumber = 'P200107173325469' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361309' WHERE ordernumber = 'P180107173346505' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '254213' WHERE ordernumber = 'P180107173442934' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361315' WHERE ordernumber = 'P180107174138691' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '292526' WHERE ordernumber = 'P200107174158344' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '78130' WHERE ordernumber = 'P420107174208483' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361316' WHERE ordernumber = 'P180107174346390' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '354422' WHERE ordernumber = 'P180107174540236' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361318' WHERE ordernumber = 'P180107174630494' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '359015' WHERE ordernumber = 'P180107174742153' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361312' WHERE ordernumber = 'P200107174910520' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '213044' WHERE ordernumber = 'P180107175123137' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '352404' WHERE ordernumber = 'P180107175225186' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '322480' WHERE ordernumber = 'P180107180148886' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '267353' WHERE ordernumber = 'P180107180300286' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '346960' WHERE ordernumber = 'P180107180440351' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361336' WHERE ordernumber = 'P180107180721768' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '357691' WHERE ordernumber = 'P200107180736287' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361337' WHERE ordernumber = 'P190107180853540' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361338' WHERE ordernumber = 'P180107180911588' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '319383' WHERE ordernumber = 'P190107180943692' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361340' WHERE ordernumber = 'P180107181030704' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361334' WHERE ordernumber = 'P190107181221965' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361341' WHERE ordernumber = 'P200107181236923' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '90253' WHERE ordernumber = 'P420107181413823' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '129707' WHERE ordernumber = 'P190107181419711' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361342' WHERE ordernumber = 'P180107181430636' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '252894' WHERE ordernumber = 'P200107181543844' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361344' WHERE ordernumber = 'P180107181546271' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361344' WHERE ordernumber = 'P190107181700714' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361346' WHERE ordernumber = 'P180107181702584' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361348' WHERE ordernumber = 'P190107181829942' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '241569' WHERE ordernumber = 'P180107182002579' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361358' WHERE ordernumber = 'P180107182605468' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361359' WHERE ordernumber = 'P180107182732628' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '213847' WHERE ordernumber = 'P200107182902441' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '217158' WHERE ordernumber = 'P190107183205865' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '101638' WHERE ordernumber = 'P200107183312810' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '352644' WHERE ordernumber = 'P180107183500731' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361368' WHERE ordernumber = 'P190107183611165' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361369' WHERE ordernumber = 'P180107183809774' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361372' WHERE ordernumber = 'P180107184017728' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '302812' WHERE ordernumber = 'P200107184200592' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '158709' WHERE ordernumber = 'P200107184446467' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361385' WHERE ordernumber = 'P190107184827503' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '344829' WHERE ordernumber = 'P190107185436866' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '239611' WHERE ordernumber = 'P200107185442694' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361394' WHERE ordernumber = 'P190107185849332' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361397' WHERE ordernumber = 'P200107190124457' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361406' WHERE ordernumber = 'P190107190509540' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '127611' WHERE ordernumber = 'P190107190652433' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '99941' WHERE ordernumber = 'P190107191013733' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361411' WHERE ordernumber = 'P200107191029285' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '99941' WHERE ordernumber = 'P190107191620163' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361417' WHERE ordernumber = 'P190107191735815' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361422' WHERE ordernumber = 'P190107192240395' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '293690' WHERE ordernumber = 'P190107192527401' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '87749' WHERE ordernumber = 'P190107193010617' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '38038' WHERE ordernumber = 'P190107193258275' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '316199' WHERE ordernumber = 'P200107193346865' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '340190' WHERE ordernumber = 'P190107193502727' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '344909' WHERE ordernumber = 'P420107193528686' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361445' WHERE ordernumber = 'P190107194025751' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361449' WHERE ordernumber = 'P190107194228365' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361453' WHERE ordernumber = 'P190107194327332' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361461' WHERE ordernumber = 'P190107194915655' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361460' WHERE ordernumber = 'P190107194941774' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361468' WHERE ordernumber = 'P200107195052496' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361469' WHERE ordernumber = 'P190107195058827' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '337223' WHERE ordernumber = 'P190107195218208' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361473' WHERE ordernumber = 'P200107195509175' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '361475' WHERE ordernumber = 'P190107195612138' 2024-01-08 01:00:06 -- UPDATE `omo_order_list` SET userId = '283536' WHERE ordernumber = 'P200107195657667'