2024-07-01 01:00:02 -- 將會員中心id寫入data-lake 2024-07-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-06-30%'; 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398985' WHERE ordernumber = 'P630630100330451' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '397697' WHERE ordernumber = 'P630630101251447' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398990' WHERE ordernumber = 'P630630104132163' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398991' WHERE ordernumber = 'P630630105258969' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398992' WHERE ordernumber = 'P630630105848153' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '75984' WHERE ordernumber = 'P180630110255422' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398993' WHERE ordernumber = 'P200630110333582' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398994' WHERE ordernumber = 'P420630110539428' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '58935' WHERE ordernumber = 'P180630110625895' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '381089' WHERE ordernumber = 'P420630110819815' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '388241' WHERE ordernumber = 'P190630110902423' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '281863' WHERE ordernumber = 'P180630110959999' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '126683' WHERE ordernumber = 'P190630111045926' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '391913' WHERE ordernumber = 'P420630111214636' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398995' WHERE ordernumber = 'P180630111218487' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '389306' WHERE ordernumber = 'P630630111534817' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '276908' WHERE ordernumber = 'P200630111722644' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '352944' WHERE ordernumber = 'P180630111734642' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '283493' WHERE ordernumber = 'P180630111845727' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '387047' WHERE ordernumber = 'P200630111845332' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '344768' WHERE ordernumber = 'P180630111921462' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398996' WHERE ordernumber = 'P190630112005879' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '171584' WHERE ordernumber = 'P180630112215558' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398998' WHERE ordernumber = 'P420630112311930' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398999' WHERE ordernumber = 'P180630112344979' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '398835' WHERE ordernumber = 'P200630112348546' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '255378' WHERE ordernumber = 'P190630112519679' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '399000' WHERE ordernumber = 'P420630112528903' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '171055' WHERE ordernumber = 'P180630112538251' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '255378' WHERE ordernumber = 'P190630112617294' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '255378' WHERE ordernumber = 'P190630112703779' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '283429' WHERE ordernumber = 'P200630112812739' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '399001' WHERE ordernumber = 'P630630113651225' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '251558' WHERE ordernumber = 'P180630113958777' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '399003' WHERE ordernumber = 'P180630114132372' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '399004' WHERE ordernumber = 'P200630114308214' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '399005' WHERE ordernumber = 'P180630114401978' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '397375' WHERE ordernumber = 'P190630114440344' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '399006' WHERE ordernumber = 'P200630114447377' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '399005' WHERE ordernumber = 'P180630114447313' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '288749' WHERE ordernumber = 'P200630115358136' 2024-07-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '399007' WHERE ordernumber = 'P180630115615531' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '86113' WHERE ordernumber = 'P190630115622647' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '335350' WHERE ordernumber = 'P200630115753955' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399008' WHERE ordernumber = 'P180630115802155' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399010' WHERE ordernumber = 'P200630115944563' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399009' WHERE ordernumber = 'P780630120038677' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399012' WHERE ordernumber = 'P200630120058158' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399013' WHERE ordernumber = 'P180630120123112' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399014' WHERE ordernumber = 'P180630120514336' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '158974' WHERE ordernumber = 'P630630121215472' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '393362' WHERE ordernumber = 'P200630121241896' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399016' WHERE ordernumber = 'P200630121427216' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399017' WHERE ordernumber = 'P780630121735411' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399020' WHERE ordernumber = 'P630630121938806' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399024' WHERE ordernumber = 'P180630123117589' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399025' WHERE ordernumber = 'P420630123250763' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '206653' WHERE ordernumber = 'P180630123321215' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399027' WHERE ordernumber = 'P180630123506309' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399026' WHERE ordernumber = 'P190630123514741' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '345671' WHERE ordernumber = 'P200630123752821' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '244978' WHERE ordernumber = 'P420630124309208' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399028' WHERE ordernumber = 'P180630124316176' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399009' WHERE ordernumber = 'P780630124604342' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '395721' WHERE ordernumber = 'P420630124634288' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399031' WHERE ordernumber = 'P180630125004541' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399032' WHERE ordernumber = 'P200630125011523' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '140510' WHERE ordernumber = 'P180630125120961' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '318117' WHERE ordernumber = 'P190630125424173' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399033' WHERE ordernumber = 'P200630125532662' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '332949' WHERE ordernumber = 'P190630125709723' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399035' WHERE ordernumber = 'P420630130027451' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '389481' WHERE ordernumber = 'P200630130202373' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399036' WHERE ordernumber = 'P420630130520869' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399037' WHERE ordernumber = 'P200630130552654' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399039' WHERE ordernumber = 'P200630130725603' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399038' WHERE ordernumber = 'P420630130735682' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399040' WHERE ordernumber = 'P180630131532364' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '378495' WHERE ordernumber = 'P180630131734204' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399042' WHERE ordernumber = 'P190630132327117' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399043' WHERE ordernumber = 'P420630132407804' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399041' WHERE ordernumber = 'P180630132433942' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '291960' WHERE ordernumber = 'P200630132450176' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '291960' WHERE ordernumber = 'P200630132724250' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '91840' WHERE ordernumber = 'P180630133035312' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399045' WHERE ordernumber = 'P190630133059164' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399046' WHERE ordernumber = 'P420630133152164' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399047' WHERE ordernumber = 'P200630133230506' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399044' WHERE ordernumber = 'P780630133539421' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '393208' WHERE ordernumber = 'P420630133805922' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399048' WHERE ordernumber = 'P180630133906934' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399049' WHERE ordernumber = 'P180630133948778' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '135709' WHERE ordernumber = 'P420630134028949' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399050' WHERE ordernumber = 'P190630134039715' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399051' WHERE ordernumber = 'P420630134204320' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399052' WHERE ordernumber = 'P420630134322431' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399053' WHERE ordernumber = 'P630630134456133' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399054' WHERE ordernumber = 'P630630134545974' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399055' WHERE ordernumber = 'P420630134655436' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399052' WHERE ordernumber = 'P420630134812840' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399056' WHERE ordernumber = 'P420630135012132' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '398191' WHERE ordernumber = 'P190630135547475' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399058' WHERE ordernumber = 'P630630135622922' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '269074' WHERE ordernumber = 'P180630135804506' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399059' WHERE ordernumber = 'P180630140208651' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399060' WHERE ordernumber = 'P180630140304165' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '381638' WHERE ordernumber = 'P190630140321680' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399061' WHERE ordernumber = 'P180630140629511' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '282566' WHERE ordernumber = 'P200630140958989' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399063' WHERE ordernumber = 'P180630141028530' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '381066' WHERE ordernumber = 'P200630141051551' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '376882' WHERE ordernumber = 'P420630141054260' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399064' WHERE ordernumber = 'P420630141302643' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '398564' WHERE ordernumber = 'P200630141443825' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '398564' WHERE ordernumber = 'P200630141450626' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399065' WHERE ordernumber = 'P180630141738370' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399066' WHERE ordernumber = 'P180630141834224' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399067' WHERE ordernumber = 'P180630142022560' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '157218' WHERE ordernumber = 'P200630142028961' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '294343' WHERE ordernumber = 'P420630142029328' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399051' WHERE ordernumber = 'P420630142212328' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399069' WHERE ordernumber = 'P420630142340189' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399070' WHERE ordernumber = 'P180630142356361' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '397950' WHERE ordernumber = 'P420630142615721' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399071' WHERE ordernumber = 'P180630142829796' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399072' WHERE ordernumber = 'P190630142954648' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '216896' WHERE ordernumber = 'P200630143152810' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399073' WHERE ordernumber = 'P180630143230192' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '240625' WHERE ordernumber = 'P200630143253880' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '392228' WHERE ordernumber = 'P190630143735982' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399077' WHERE ordernumber = 'P180630143835522' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399078' WHERE ordernumber = 'P190630144005446' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '207380' WHERE ordernumber = 'P180630144438968' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399080' WHERE ordernumber = 'P420630144447470' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '236826' WHERE ordernumber = 'P190630144537195' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399081' WHERE ordernumber = 'P420630144610143' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399082' WHERE ordernumber = 'P420630144900833' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399083' WHERE ordernumber = 'P420630145139665' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399084' WHERE ordernumber = 'P180630145224507' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399085' WHERE ordernumber = 'P630630145408378' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399084' WHERE ordernumber = 'P190630145455140' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399086' WHERE ordernumber = 'P630630145516973' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '1785' WHERE ordernumber = 'P180630145519295' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399087' WHERE ordernumber = 'P420630145647703' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399079' WHERE ordernumber = 'P780630145701687' 2024-07-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '399089' WHERE ordernumber = 'P420630145837903' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399090' WHERE ordernumber = 'P190630145846292' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399088' WHERE ordernumber = 'P630630145851885' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399091' WHERE ordernumber = 'P630630150033561' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399092' WHERE ordernumber = 'P420630150137262' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '126787' WHERE ordernumber = 'P200630150155782' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399093' WHERE ordernumber = 'P180630150244980' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399094' WHERE ordernumber = 'P420630150517505' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '120489' WHERE ordernumber = 'P420630150857843' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '283200' WHERE ordernumber = 'P420630151050610' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399096' WHERE ordernumber = 'P180630151054437' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '346631' WHERE ordernumber = 'P200630151327509' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399097' WHERE ordernumber = 'P420630151800733' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399098' WHERE ordernumber = 'P180630152046753' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '139250' WHERE ordernumber = 'P200630152321861' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399099' WHERE ordernumber = 'P420630152907535' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399100' WHERE ordernumber = 'P180630153029239' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399102' WHERE ordernumber = 'P420630153604500' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '397556' WHERE ordernumber = 'P180630153817932' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399104' WHERE ordernumber = 'P780630153959575' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399105' WHERE ordernumber = 'P180630154027889' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '315520' WHERE ordernumber = 'P180630154112966' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399106' WHERE ordernumber = 'P190630154214995' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '288236' WHERE ordernumber = 'P200630154228996' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399108' WHERE ordernumber = 'P420630154308753' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399109' WHERE ordernumber = 'P180630154341762' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399110' WHERE ordernumber = 'P190630154429425' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399113' WHERE ordernumber = 'P180630154527614' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399114' WHERE ordernumber = 'P200630154550730' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399111' WHERE ordernumber = 'P780630154619660' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399116' WHERE ordernumber = 'P630630154734369' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '226090' WHERE ordernumber = 'P180630154812707' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '286571' WHERE ordernumber = 'P200630154833150' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399117' WHERE ordernumber = 'P190630154907984' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399101' WHERE ordernumber = 'P180630154934256' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399115' WHERE ordernumber = 'P780630155046563' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399118' WHERE ordernumber = 'P200630155138834' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '24300' WHERE ordernumber = 'P180630155152911' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399120' WHERE ordernumber = 'P420630155254433' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399121' WHERE ordernumber = 'P200630155334681' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '336831' WHERE ordernumber = 'P190630155348543' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '384260' WHERE ordernumber = 'P420630155501327' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '24300' WHERE ordernumber = 'P180630155612398' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399122' WHERE ordernumber = 'P630630155753832' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399119' WHERE ordernumber = 'P180630160052758' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '388572' WHERE ordernumber = 'P200630160148921' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '245637' WHERE ordernumber = 'P180630160234520' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399124' WHERE ordernumber = 'P420630160603729' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399127' WHERE ordernumber = 'P180630160819717' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399126' WHERE ordernumber = 'P420630160846795' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399128' WHERE ordernumber = 'P420630161355630' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399129' WHERE ordernumber = 'P180630161521140' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399130' WHERE ordernumber = 'P420630161601716' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399131' WHERE ordernumber = 'P180630161719262' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '177489' WHERE ordernumber = 'P180630162329619' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399133' WHERE ordernumber = 'P420630162424831' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399132' WHERE ordernumber = 'P180630162504158' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399134' WHERE ordernumber = 'P630630162647612' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399135' WHERE ordernumber = 'P180630162739829' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '385549' WHERE ordernumber = 'P420630163310634' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399138' WHERE ordernumber = 'P200630163334229' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399136' WHERE ordernumber = 'P780630163423281' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399137' WHERE ordernumber = 'P180630163420535' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399137' WHERE ordernumber = 'P180630163453797' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399139' WHERE ordernumber = 'P190630163558844' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399140' WHERE ordernumber = 'P180630163707351' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399142' WHERE ordernumber = 'P180630164358385' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399141' WHERE ordernumber = 'P200630164500132' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399143' WHERE ordernumber = 'P630630164603845' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '27604' WHERE ordernumber = 'P200630164704273' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399145' WHERE ordernumber = 'P630630164804212' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399146' WHERE ordernumber = 'P630630164912387' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399144' WHERE ordernumber = 'P420630165154254' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399148' WHERE ordernumber = 'P200630165317218' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '394977' WHERE ordernumber = 'P190630165448445' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399149' WHERE ordernumber = 'P200630165453762' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399009' WHERE ordernumber = 'P780630165621902' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '242361' WHERE ordernumber = 'P200630165839448' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399147' WHERE ordernumber = 'P180630165850805' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399150' WHERE ordernumber = 'P180630170024730' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '214639' WHERE ordernumber = 'P180630170219820' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '253121' WHERE ordernumber = 'P630630170510906' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399151' WHERE ordernumber = 'P420630170546649' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399152' WHERE ordernumber = 'P180630170758708' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '373703' WHERE ordernumber = 'P420630170926339' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399154' WHERE ordernumber = 'P420630171109919' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399156' WHERE ordernumber = 'P420630171344201' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399155' WHERE ordernumber = 'P180630171345381' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399157' WHERE ordernumber = 'P180630171618283' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399158' WHERE ordernumber = 'P190630171645287' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '353829' WHERE ordernumber = 'P420630171727524' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '373451' WHERE ordernumber = 'P420630171835847' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399159' WHERE ordernumber = 'P200630172003803' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399160' WHERE ordernumber = 'P420630172010709' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399159' WHERE ordernumber = 'P200630172116497' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '397238' WHERE ordernumber = 'P200630172220217' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399161' WHERE ordernumber = 'P180630172404519' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '340270' WHERE ordernumber = 'P180630172820549' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '387822' WHERE ordernumber = 'P200630173040402' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '304934' WHERE ordernumber = 'P200630173130262' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '238940' WHERE ordernumber = 'P180630173348593' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '331118' WHERE ordernumber = 'P420630173515906' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '141805' WHERE ordernumber = 'P200630173539257' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399162' WHERE ordernumber = 'P780630174028639' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399163' WHERE ordernumber = 'P420630174113564' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '399165' WHERE ordernumber = 'P630630174325938' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '85202' WHERE ordernumber = 'P200630174428469' 2024-07-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '85202' WHERE ordernumber = 'P200630174516337' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '134860' WHERE ordernumber = 'P180630175016448' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399166' WHERE ordernumber = 'P420630175107221' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399167' WHERE ordernumber = 'P190630175357639' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '384984' WHERE ordernumber = 'P190630175806636' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '356068' WHERE ordernumber = 'P180630175922269' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399169' WHERE ordernumber = 'P780630180248152' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '136795' WHERE ordernumber = 'P180630180508770' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399170' WHERE ordernumber = 'P420630180519142' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399171' WHERE ordernumber = 'P630630180754240' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '161953' WHERE ordernumber = 'P180630181245533' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399172' WHERE ordernumber = 'P420630181847486' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399173' WHERE ordernumber = 'P180630181917680' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '225487' WHERE ordernumber = 'P180630182443535' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399174' WHERE ordernumber = 'P780630182704394' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '313647' WHERE ordernumber = 'P780630182931395' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399175' WHERE ordernumber = 'P420630182942841' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '122743' WHERE ordernumber = 'P190630183006736' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '346631' WHERE ordernumber = 'P200630183038772' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '381670' WHERE ordernumber = 'P420630183218190' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399176' WHERE ordernumber = 'P420630183345282' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '283615' WHERE ordernumber = 'P420630183527863' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399177' WHERE ordernumber = 'P200630183534588' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '215665' WHERE ordernumber = 'P630630183558895' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399178' WHERE ordernumber = 'P190630183618234' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '52028' WHERE ordernumber = 'P190630183825172' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399179' WHERE ordernumber = 'P630630183910220' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '52028' WHERE ordernumber = 'P190630183929825' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '312952' WHERE ordernumber = 'P190630184008695' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '398592' WHERE ordernumber = 'P200630184029793' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399180' WHERE ordernumber = 'P420630184117322' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '52028' WHERE ordernumber = 'P190630184202790' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '366204' WHERE ordernumber = 'P190630184445480' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399181' WHERE ordernumber = 'P630630184711269' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399182' WHERE ordernumber = 'P590630185256233' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399184' WHERE ordernumber = 'P190630185444438' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399184' WHERE ordernumber = 'P190630185512556' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399185' WHERE ordernumber = 'P420630185633127' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399186' WHERE ordernumber = 'P200630185736243' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399187' WHERE ordernumber = 'P420630185852704' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399189' WHERE ordernumber = 'P190630190802677' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399190' WHERE ordernumber = 'P190630191633386' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399191' WHERE ordernumber = 'P200630191707284' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399192' WHERE ordernumber = 'P190630193056258' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '250975' WHERE ordernumber = 'P190630193530478' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '111604' WHERE ordernumber = 'P200630193551335' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '101365' WHERE ordernumber = 'P200630193724656' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399194' WHERE ordernumber = 'P190630194059399' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399195' WHERE ordernumber = 'P190630194742935' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '397717' WHERE ordernumber = 'P190630194921999' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '395583' WHERE ordernumber = 'P190630195047860' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399197' WHERE ordernumber = 'P190630195211647' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '344160' WHERE ordernumber = 'P630630200724637' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399199' WHERE ordernumber = 'P590630201450766' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399201' WHERE ordernumber = 'P780630204112981' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399202' WHERE ordernumber = 'P630630204423911' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399203' WHERE ordernumber = 'P780630204930292' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '133722' WHERE ordernumber = 'P630630205039601' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399204' WHERE ordernumber = 'P780630205803441' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '399205' WHERE ordernumber = 'P780630211551180' 2024-07-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '337912' WHERE ordernumber = 'P780630212059373'