2024-01-22 01:00:02 -- 將會員中心id寫入data-lake 2024-01-22 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-21%'; 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '297533' WHERE ordernumber = 'P420121101139495' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370198' WHERE ordernumber = 'P420121101617621' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370200' WHERE ordernumber = 'P420121101819420' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370205' WHERE ordernumber = 'P420121102411238' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370209' WHERE ordernumber = 'P420121103114360' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370214' WHERE ordernumber = 'P420121104103814' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370222' WHERE ordernumber = 'P420121105652350' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370218' WHERE ordernumber = 'P180121110136138' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370218' WHERE ordernumber = 'P180121110157515' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '104419' WHERE ordernumber = 'P180121110244265' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370227' WHERE ordernumber = 'P200121110341606' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '252809' WHERE ordernumber = 'P180121110354536' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '365459' WHERE ordernumber = 'P200121110517657' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '344696' WHERE ordernumber = 'P180121110551323' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '324082' WHERE ordernumber = 'P200121110622998' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '365459' WHERE ordernumber = 'P200121110818916' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '313542' WHERE ordernumber = 'P200121111020602' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370223' WHERE ordernumber = 'P180121111100261' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370229' WHERE ordernumber = 'P200121111237487' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370232' WHERE ordernumber = 'P420121111635241' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370231' WHERE ordernumber = 'P180121111636915' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370226' WHERE ordernumber = 'P180121111905774' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370225' WHERE ordernumber = 'P180121111948751' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '294323' WHERE ordernumber = 'P420121112049756' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '228258' WHERE ordernumber = 'P190121112102305' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '362594' WHERE ordernumber = 'P180121112248989' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '354087' WHERE ordernumber = 'P420121112308655' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '370234' WHERE ordernumber = 'P420121112622663' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '263959' WHERE ordernumber = 'P180121112640662' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '311030' WHERE ordernumber = 'P420121112852477' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '364737' WHERE ordernumber = 'P200121112912521' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '136864' WHERE ordernumber = 'P180121112922445' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '278409' WHERE ordernumber = 'P420121113015767' 2024-01-22 01:00:02 -- UPDATE `omo_order_list` SET userId = '360035' WHERE ordernumber = 'P180121113203149' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '367568' WHERE ordernumber = 'P200121113426325' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '230437' WHERE ordernumber = 'P200121113843190' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370247' WHERE ordernumber = 'P200121114040518' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370245' WHERE ordernumber = 'P180121114103732' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370247' WHERE ordernumber = 'P200121114104821' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370245' WHERE ordernumber = 'P180121114127895' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370248' WHERE ordernumber = 'P190121114213318' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370251' WHERE ordernumber = 'P420121114256769' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370254' WHERE ordernumber = 'P420121114737137' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '257782' WHERE ordernumber = 'P200121115045936' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370258' WHERE ordernumber = 'P420121115347715' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370261' WHERE ordernumber = 'P420121115544746' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '271544' WHERE ordernumber = 'P200121115634999' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370262' WHERE ordernumber = 'P420121115736786' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '347220' WHERE ordernumber = 'P200121115757380' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '210683' WHERE ordernumber = 'P180121115808984' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '99144' WHERE ordernumber = 'P200121115838697' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '314928' WHERE ordernumber = 'P420121120011971' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370263' WHERE ordernumber = 'P420121120106638' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '339509' WHERE ordernumber = 'P420121120653638' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '354204' WHERE ordernumber = 'P180121120803424' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '160974' WHERE ordernumber = 'P190121120840229' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '314449' WHERE ordernumber = 'P200121121109978' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '338556' WHERE ordernumber = 'P190121121151529' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370269' WHERE ordernumber = 'P420121121206209' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '352006' WHERE ordernumber = 'P200121121331278' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '368365' WHERE ordernumber = 'P420121121643723' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370277' WHERE ordernumber = 'P420121122200121' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '153364' WHERE ordernumber = 'P180121122247416' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370110' WHERE ordernumber = 'P420121122250428' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '256346' WHERE ordernumber = 'P180121123046976' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370281' WHERE ordernumber = 'P420121123139745' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '339493' WHERE ordernumber = 'P200121123222611' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '343198' WHERE ordernumber = 'P200121123328285' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '341738' WHERE ordernumber = 'P190121123404520' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '118455' WHERE ordernumber = 'P180121123456592' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370284' WHERE ordernumber = 'P180121123803386' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '248174' WHERE ordernumber = 'P180121123936404' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '360788' WHERE ordernumber = 'P420121124239409' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '103501' WHERE ordernumber = 'P180121124326279' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370289' WHERE ordernumber = 'P180121124407578' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '203480' WHERE ordernumber = 'P200121124420623' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '206594' WHERE ordernumber = 'P180121124543165' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '327368' WHERE ordernumber = 'P180121124647138' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '156098' WHERE ordernumber = 'P420121124649835' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '276538' WHERE ordernumber = 'P200121124806540' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '342645' WHERE ordernumber = 'P180121124951153' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '368620' WHERE ordernumber = 'P200121125128361' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370294' WHERE ordernumber = 'P420121125229590' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '360881' WHERE ordernumber = 'P190121125326296' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '140182' WHERE ordernumber = 'P180121125345582' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370298' WHERE ordernumber = 'P420121125509681' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '347580' WHERE ordernumber = 'P180121125624229' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '260675' WHERE ordernumber = 'P200121125649639' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '164904' WHERE ordernumber = 'P420121130013195' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '310908' WHERE ordernumber = 'P180121130128892' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '164904' WHERE ordernumber = 'P420121130225823' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '342308' WHERE ordernumber = 'P190121130408764' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '334257' WHERE ordernumber = 'P420121130501865' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370302' WHERE ordernumber = 'P420121130618570' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370305' WHERE ordernumber = 'P420121130734694' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '361197' WHERE ordernumber = 'P180121130805312' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '242872' WHERE ordernumber = 'P200121131318709' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '63197' WHERE ordernumber = 'P190121131319597' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '367223' WHERE ordernumber = 'P200121131528253' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '235750' WHERE ordernumber = 'P200121131706822' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370314' WHERE ordernumber = 'P420121131852958' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '369978' WHERE ordernumber = 'P200121132019973' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370316' WHERE ordernumber = 'P420121132218404' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370318' WHERE ordernumber = 'P200121132319810' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '84727' WHERE ordernumber = 'P180121132320706' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370318' WHERE ordernumber = 'P200121132500963' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '368867' WHERE ordernumber = 'P180121132538875' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '368867' WHERE ordernumber = 'P180121132657413' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370323' WHERE ordernumber = 'P420121132734159' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '367806' WHERE ordernumber = 'P430121132820872' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370324' WHERE ordernumber = 'P200121132826733' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370325' WHERE ordernumber = 'P420121132847967' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '98968' WHERE ordernumber = 'P200121132914994' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '323810' WHERE ordernumber = 'P180121133004504' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '303362' WHERE ordernumber = 'P200121133020661' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '105186' WHERE ordernumber = 'P180121133115523' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370324' WHERE ordernumber = 'P200121133354169' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '365203' WHERE ordernumber = 'P420121133610233' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '348643' WHERE ordernumber = 'P200121133626141' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370330' WHERE ordernumber = 'P420121133821568' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370332' WHERE ordernumber = 'P200121133918701' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370331' WHERE ordernumber = 'P430121133956526' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '334797' WHERE ordernumber = 'P420121134253726' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '368348' WHERE ordernumber = 'P430121134448877' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370339' WHERE ordernumber = 'P420121134538287' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '315521' WHERE ordernumber = 'P190121134702476' 2024-01-22 01:00:03 -- UPDATE `omo_order_list` SET userId = '370343' WHERE ordernumber = 'P420121134745337' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370344' WHERE ordernumber = 'P430121134822758' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '365623' WHERE ordernumber = 'P190121134834614' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370345' WHERE ordernumber = 'P420121135022906' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '276943' WHERE ordernumber = 'P200121135128291' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '339062' WHERE ordernumber = 'P430121135330607' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '273427' WHERE ordernumber = 'P420121135407583' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '366195' WHERE ordernumber = 'P190121135955867' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '295608' WHERE ordernumber = 'P200121140110119' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370352' WHERE ordernumber = 'P200121140229316' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '357686' WHERE ordernumber = 'P190121140231683' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '230319' WHERE ordernumber = 'P200121140420497' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '357509' WHERE ordernumber = 'P430121140716705' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '114400' WHERE ordernumber = 'P420121141017677' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370360' WHERE ordernumber = 'P200121141105426' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '154476' WHERE ordernumber = 'P180121141256994' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '241534' WHERE ordernumber = 'P180121141629378' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '368573' WHERE ordernumber = 'P200121141741609' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370362' WHERE ordernumber = 'P430121141958658' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370363' WHERE ordernumber = 'P190121142045719' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '81142' WHERE ordernumber = 'P180121142327168' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '365277' WHERE ordernumber = 'P420121142437224' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '283996' WHERE ordernumber = 'P180121142455168' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '271110' WHERE ordernumber = 'P190121142552760' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370370' WHERE ordernumber = 'P420121142805963' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '99833' WHERE ordernumber = 'P190121142851364' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '353350' WHERE ordernumber = 'P200121142914112' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '353079' WHERE ordernumber = 'P190121143032230' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '364256' WHERE ordernumber = 'P200121143219179' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370375' WHERE ordernumber = 'P180121143259951' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '369034' WHERE ordernumber = 'P190121143622223' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370377' WHERE ordernumber = 'P420121143644921' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '369034' WHERE ordernumber = 'P190121143653860' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '104133' WHERE ordernumber = 'P180121143801996' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '358480' WHERE ordernumber = 'P200121143847689' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '42300' WHERE ordernumber = 'P200121143954796' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '350514' WHERE ordernumber = 'P420121143957779' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '281760' WHERE ordernumber = 'P190121144039672' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '281760' WHERE ordernumber = 'P190121144146351' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370384' WHERE ordernumber = 'P200121144156625' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '281760' WHERE ordernumber = 'P190121144235933' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '281760' WHERE ordernumber = 'P190121144335417' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '281760' WHERE ordernumber = 'P190121144350139' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '118833' WHERE ordernumber = 'P200121144438748' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '230419' WHERE ordernumber = 'P180121144552316' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '282116' WHERE ordernumber = 'P190121144638594' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '224520' WHERE ordernumber = 'P180121144810909' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '74290' WHERE ordernumber = 'P420121145003850' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '272151' WHERE ordernumber = 'P200121145014424' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '255325' WHERE ordernumber = 'P190121145156132' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '301162' WHERE ordernumber = 'P200121145215496' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '368283' WHERE ordernumber = 'P190121145702419' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '330303' WHERE ordernumber = 'P200121145831290' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '216372' WHERE ordernumber = 'P200121145936442' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '330303' WHERE ordernumber = 'P200121150025712' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '155156' WHERE ordernumber = 'P180121150110744' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '362194' WHERE ordernumber = 'P420121150149860' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370397' WHERE ordernumber = 'P180121150211277' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '289704' WHERE ordernumber = 'P180121150329612' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '362194' WHERE ordernumber = 'P420121150335787' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '367550' WHERE ordernumber = 'P200121150404560' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '361664' WHERE ordernumber = 'P200121150549263' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '368283' WHERE ordernumber = 'P180121150634430' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370405' WHERE ordernumber = 'P180121150859275' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '327735' WHERE ordernumber = 'P420121150913676' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '142759' WHERE ordernumber = 'P200121150958852' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '129132' WHERE ordernumber = 'P180121151230650' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '171633' WHERE ordernumber = 'P200121151320910' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '348624' WHERE ordernumber = 'P180121151327618' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370410' WHERE ordernumber = 'P420121151332199' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '369640' WHERE ordernumber = 'P200121151414742' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '133686' WHERE ordernumber = 'P180121151620850' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370413' WHERE ordernumber = 'P420121151714394' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370417' WHERE ordernumber = 'P420121151911243' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370418' WHERE ordernumber = 'P180121152125400' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '248803' WHERE ordernumber = 'P200121152437894' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '237534' WHERE ordernumber = 'P200121152757438' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370212' WHERE ordernumber = 'P200121152843601' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '81603' WHERE ordernumber = 'P180121152850703' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370423' WHERE ordernumber = 'P180121153017415' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370423' WHERE ordernumber = 'P180121153055492' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '270505' WHERE ordernumber = 'P180121153258829' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '368814' WHERE ordernumber = 'P200121153303992' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '368879' WHERE ordernumber = 'P420121154607697' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '88581' WHERE ordernumber = 'P190121154646129' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '23864' WHERE ordernumber = 'P200121154826284' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '350541' WHERE ordernumber = 'P180121154827988' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '312200' WHERE ordernumber = 'P190121155956204' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '352682' WHERE ordernumber = 'P430121160259429' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '230143' WHERE ordernumber = 'P200121160619236' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '231525' WHERE ordernumber = 'P190121160702215' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '370443' WHERE ordernumber = 'P180121160717464' 2024-01-22 01:00:04 -- UPDATE `omo_order_list` SET userId = '94874' WHERE ordernumber = 'P420121160836147' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '279073' WHERE ordernumber = 'P180121160904289' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '240347' WHERE ordernumber = 'P200121161255153' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '358411' WHERE ordernumber = 'P200121162041976' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '322420' WHERE ordernumber = 'P200121162518261' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370456' WHERE ordernumber = 'P200121162703267' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '255121' WHERE ordernumber = 'P180121162812120' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '136621' WHERE ordernumber = 'P200121162826956' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370459' WHERE ordernumber = 'P200121163016383' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370457' WHERE ordernumber = 'P430121163207272' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370462' WHERE ordernumber = 'P200121163254697' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '251382' WHERE ordernumber = 'P200121163353772' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370463' WHERE ordernumber = 'P200121163606604' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '237226' WHERE ordernumber = 'P180121163646689' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '357702' WHERE ordernumber = 'P420121163731691' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '366196' WHERE ordernumber = 'P180121163740613' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '348093' WHERE ordernumber = 'P200121163816579' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '366123' WHERE ordernumber = 'P420121163822835' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '307718' WHERE ordernumber = 'P200121163945576' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '340163' WHERE ordernumber = 'P200121164028527' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '154268' WHERE ordernumber = 'P200121164540634' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '321868' WHERE ordernumber = 'P180121164827268' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '368514' WHERE ordernumber = 'P430121164929437' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '106086' WHERE ordernumber = 'P190121165407454' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '369576' WHERE ordernumber = 'P200121165645457' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '228542' WHERE ordernumber = 'P200121165820725' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '195490' WHERE ordernumber = 'P420121170254824' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '42414' WHERE ordernumber = 'P190121170757397' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370483' WHERE ordernumber = 'P420121170803646' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '340830' WHERE ordernumber = 'P180121171145512' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '313345' WHERE ordernumber = 'P420121171228531' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '352520' WHERE ordernumber = 'P420121171747240' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370489' WHERE ordernumber = 'P420121171957807' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370490' WHERE ordernumber = 'P200121172004782' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370491' WHERE ordernumber = 'P200121172109581' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370493' WHERE ordernumber = 'P200121172223918' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '233907' WHERE ordernumber = 'P200121172412943' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '340068' WHERE ordernumber = 'P420121172745577' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '261216' WHERE ordernumber = 'P200121172859904' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370499' WHERE ordernumber = 'P420121172859826' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370504' WHERE ordernumber = 'P180121173419753' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '249554' WHERE ordernumber = 'P200121173529205' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370505' WHERE ordernumber = 'P180121173533737' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '256850' WHERE ordernumber = 'P200121173648899' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '294072' WHERE ordernumber = 'P420121173922225' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '367594' WHERE ordernumber = 'P420121174135469' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '367594' WHERE ordernumber = 'P420121174250829' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370508' WHERE ordernumber = 'P190121174610492' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '369272' WHERE ordernumber = 'P180121174708583' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '369272' WHERE ordernumber = 'P180121174811265' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370511' WHERE ordernumber = 'P180121174857914' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '293077' WHERE ordernumber = 'P190121174902188' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '220707' WHERE ordernumber = 'P200121174908349' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '229280' WHERE ordernumber = 'P180121175022448' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370512' WHERE ordernumber = 'P420121175030117' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370515' WHERE ordernumber = 'P180121175110505' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370516' WHERE ordernumber = 'P420121175148446' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370517' WHERE ordernumber = 'P420121175322476' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370519' WHERE ordernumber = 'P420121175632256' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P180121180510126' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '287790' WHERE ordernumber = 'P200121180947595' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '369503' WHERE ordernumber = 'P200121181447146' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '258835' WHERE ordernumber = 'P180121182112772' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '358422' WHERE ordernumber = 'P420121182312390' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '235287' WHERE ordernumber = 'P180121182417263' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370537' WHERE ordernumber = 'P420121182842867' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370543' WHERE ordernumber = 'P420121183916559' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370544' WHERE ordernumber = 'P420121184032358' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370546' WHERE ordernumber = 'P420121184242980' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '119752' WHERE ordernumber = 'P180121184344377' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370548' WHERE ordernumber = 'P420121184417816' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '94143' WHERE ordernumber = 'P180121184502793' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '367092' WHERE ordernumber = 'P180121184743771' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370470' WHERE ordernumber = 'P420121184848187' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370470' WHERE ordernumber = 'P420121184917930' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '367964' WHERE ordernumber = 'P180121185021995' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '367964' WHERE ordernumber = 'P180121185109886' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '369322' WHERE ordernumber = 'P190121185125214' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '158000' WHERE ordernumber = 'P200121185247258' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370557' WHERE ordernumber = 'P420121185254679' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '314212' WHERE ordernumber = 'P420121185406951' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '368501' WHERE ordernumber = 'P180121185707339' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '352487' WHERE ordernumber = 'P180121190512124' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370568' WHERE ordernumber = 'P180121190752969' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370568' WHERE ordernumber = 'P180121190853280' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '238189' WHERE ordernumber = 'P180121190953983' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370570' WHERE ordernumber = 'P420121191035660' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '238189' WHERE ordernumber = 'P180121191039776' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370573' WHERE ordernumber = 'P420121191419151' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '146920' WHERE ordernumber = 'P420121191521556' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '146920' WHERE ordernumber = 'P420121192509170' 2024-01-22 01:00:05 -- UPDATE `omo_order_list` SET userId = '370578' WHERE ordernumber = 'P420121192701932' 2024-01-22 01:00:06 -- UPDATE `omo_order_list` SET userId = '146920' WHERE ordernumber = 'P420121192733444' 2024-01-22 01:00:06 -- UPDATE `omo_order_list` SET userId = '292461' WHERE ordernumber = 'P190121192824570' 2024-01-22 01:00:06 -- UPDATE `omo_order_list` SET userId = '273238' WHERE ordernumber = 'P190121193855737' 2024-01-22 01:00:06 -- UPDATE `omo_order_list` SET userId = '366461' WHERE ordernumber = 'P420121195654626' 2024-01-22 01:00:06 -- UPDATE `omo_order_list` SET userId = '361369' WHERE ordernumber = 'P190121195830904'