2024-09-16 01:00:01 -- 將會員中心id寫入data-lake 2024-09-16 01:00:01 -- 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-09-15%'; 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '16876' WHERE ordernumber = 'P420915105917275' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '272013' WHERE ordernumber = 'P200915110124654' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '396722' WHERE ordernumber = 'P190915110151861' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '227557' WHERE ordernumber = 'P180915110300619' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '109478' WHERE ordernumber = 'P200915110327163' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '404069' WHERE ordernumber = 'P420915110332635' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '98694' WHERE ordernumber = 'P420915110548223' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421218' WHERE ordernumber = 'P420915110713237' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421224' WHERE ordernumber = 'P190915110719834' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421218' WHERE ordernumber = 'P420915110730359' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '327941' WHERE ordernumber = 'P180915110739613' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '117614' WHERE ordernumber = 'P180915110837279' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421226' WHERE ordernumber = 'P420915110921120' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421225' WHERE ordernumber = 'P420915110926900' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421227' WHERE ordernumber = 'P200915110928578' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421228' WHERE ordernumber = 'P420915111014938' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421221' WHERE ordernumber = 'P190915111030681' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421229' WHERE ordernumber = 'P420915111113801' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421222' WHERE ordernumber = 'P190915111257739' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421231' WHERE ordernumber = 'P420915111334878' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '380081' WHERE ordernumber = 'P180915111351581' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421230' WHERE ordernumber = 'P420915111434650' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '410569' WHERE ordernumber = 'P190915111449527' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '243294' WHERE ordernumber = 'P420915111646810' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '243294' WHERE ordernumber = 'P420915111730934' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '140855' WHERE ordernumber = 'P180915111840534' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421232' WHERE ordernumber = 'P420915111842390' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '389193' WHERE ordernumber = 'P190915111927420' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421233' WHERE ordernumber = 'P420915112034961' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '420023' WHERE ordernumber = 'P420915112324288' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '420023' WHERE ordernumber = 'P420915112405700' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '389193' WHERE ordernumber = 'P190915112429112' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '411665' WHERE ordernumber = 'P180915112447547' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421234' WHERE ordernumber = 'P420915112513439' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421235' WHERE ordernumber = 'P420915112558576' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421236' WHERE ordernumber = 'P420915112710480' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421237' WHERE ordernumber = 'P420915112803328' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421238' WHERE ordernumber = 'P420915112916187' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '386430' WHERE ordernumber = 'P200915112920513' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421239' WHERE ordernumber = 'P190915113015838' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421240' WHERE ordernumber = 'P420915113048322' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421241' WHERE ordernumber = 'P420915113206189' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '416893' WHERE ordernumber = 'P420915113254117' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '102338' WHERE ordernumber = 'P200915113439496' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '149869' WHERE ordernumber = 'P200915113502596' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421242' WHERE ordernumber = 'P420915113518655' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '390480' WHERE ordernumber = 'P180915113624205' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '97019' WHERE ordernumber = 'P190915113717387' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '329340' WHERE ordernumber = 'P200915114014658' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '70868' WHERE ordernumber = 'P420915114347881' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421243' WHERE ordernumber = 'P200915114357290' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '356802' WHERE ordernumber = 'P420915114455867' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '116243' WHERE ordernumber = 'P200915114651787' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '320018' WHERE ordernumber = 'P420915114814502' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '277878' WHERE ordernumber = 'P180915114833777' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '408819' WHERE ordernumber = 'P420915114857860' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '420419' WHERE ordernumber = 'P420915114950513' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '379300' WHERE ordernumber = 'P420915115027189' 2024-09-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '72906' WHERE ordernumber = 'P420915115125363' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '133680' WHERE ordernumber = 'P200915115208143' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '215448' WHERE ordernumber = 'P180915115335210' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '277878' WHERE ordernumber = 'P180915115435809' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '358703' WHERE ordernumber = 'P180915120320397' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '358703' WHERE ordernumber = 'P180915120410661' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421244' WHERE ordernumber = 'P420915120716774' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '377842' WHERE ordernumber = 'P190915120742262' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421245' WHERE ordernumber = 'P420915121155159' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421246' WHERE ordernumber = 'P420915121320237' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421247' WHERE ordernumber = 'P420915121419839' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '248237' WHERE ordernumber = 'P180915121424228' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '101497' WHERE ordernumber = 'P200915121556389' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421248' WHERE ordernumber = 'P420915121811835' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421249' WHERE ordernumber = 'P420915121903326' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421250' WHERE ordernumber = 'P420915122016383' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '392562' WHERE ordernumber = 'P180915122106588' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '368080' WHERE ordernumber = 'P420915122351364' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '411630' WHERE ordernumber = 'P180915122413510' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '285580' WHERE ordernumber = 'P180915122902524' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '128361' WHERE ordernumber = 'P190915123024219' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '416861' WHERE ordernumber = 'P200915123257789' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '109535' WHERE ordernumber = 'P180915123305768' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '211236' WHERE ordernumber = 'P180915123422360' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421254' WHERE ordernumber = 'P200915123433831' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '419445' WHERE ordernumber = 'P200915124132965' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '419302' WHERE ordernumber = 'P420915124303564' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421255' WHERE ordernumber = 'P180915124401618' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421256' WHERE ordernumber = 'P420915124536959' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '337409' WHERE ordernumber = 'P180915124541679' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421257' WHERE ordernumber = 'P420915124654639' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '354846' WHERE ordernumber = 'P200915124826441' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '349798' WHERE ordernumber = 'P180915125026762' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '404754' WHERE ordernumber = 'P180915125415757' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '311472' WHERE ordernumber = 'P200915125614649' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '39351' WHERE ordernumber = 'P420915125810686' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '382707' WHERE ordernumber = 'P420915125931267' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '223849' WHERE ordernumber = 'P200915130015183' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '407043' WHERE ordernumber = 'P180915130300911' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '416409' WHERE ordernumber = 'P420915130357654' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '275687' WHERE ordernumber = 'P420915130645995' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '184350' WHERE ordernumber = 'P200915131029657' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421261' WHERE ordernumber = 'P180915131118952' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '272795' WHERE ordernumber = 'P420915131121594' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421258' WHERE ordernumber = 'P180915131602390' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '416728' WHERE ordernumber = 'P180915131807717' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421262' WHERE ordernumber = 'P200915131808130' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421263' WHERE ordernumber = 'P420915132340485' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421263' WHERE ordernumber = 'P420915132508401' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '250772' WHERE ordernumber = 'P180915132623765' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421264' WHERE ordernumber = 'P420915132634951' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421265' WHERE ordernumber = 'P420915133145776' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421266' WHERE ordernumber = 'P200915133303234' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421267' WHERE ordernumber = 'P420915133353914' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421269' WHERE ordernumber = 'P420915133517675' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421268' WHERE ordernumber = 'P200915133801890' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '333186' WHERE ordernumber = 'P180915133824425' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421270' WHERE ordernumber = 'P420915133907315' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '387701' WHERE ordernumber = 'P200915134021278' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '417213' WHERE ordernumber = 'P180915134321158' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '405682' WHERE ordernumber = 'P190915134328132' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421271' WHERE ordernumber = 'P420915134404463' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '278628' WHERE ordernumber = 'P180915134442399' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421272' WHERE ordernumber = 'P420915134533962' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '329656' WHERE ordernumber = 'P180915134545705' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '91679' WHERE ordernumber = 'P200915134600185' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '232481' WHERE ordernumber = 'P180915134957613' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421273' WHERE ordernumber = 'P200915135111317' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421005' WHERE ordernumber = 'P420915135410949' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '249106' WHERE ordernumber = 'P200915135418959' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '378673' WHERE ordernumber = 'P420915135550339' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '407181' WHERE ordernumber = 'P180915140022251' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '412128' WHERE ordernumber = 'P190915140216445' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '419810' WHERE ordernumber = 'P630915140230159' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421274' WHERE ordernumber = 'P180915140300708' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '339365' WHERE ordernumber = 'P630915140329175' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '330607' WHERE ordernumber = 'P200915140414220' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421275' WHERE ordernumber = 'P190915140545289' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '366470' WHERE ordernumber = 'P420915140834350' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '409492' WHERE ordernumber = 'P190915141001961' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '420506' WHERE ordernumber = 'P200915141226950' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '413855' WHERE ordernumber = 'P180915141300920' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '420506' WHERE ordernumber = 'P200915141307366' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '102202' WHERE ordernumber = 'P180915141457604' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '93688' WHERE ordernumber = 'P190915141516553' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '421276' WHERE ordernumber = 'P200915141557424' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '273408' WHERE ordernumber = 'P190915141640511' 2024-09-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '333446' WHERE ordernumber = 'P200915141958155' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '93633' WHERE ordernumber = 'P190915142122288' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '408819' WHERE ordernumber = 'P420915142146570' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421277' WHERE ordernumber = 'P200915142233370' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '335835' WHERE ordernumber = 'P200915142346685' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '388969' WHERE ordernumber = 'P180915142347959' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '405226' WHERE ordernumber = 'P420915142620480' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '403875' WHERE ordernumber = 'P200915142623353' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421279' WHERE ordernumber = 'P420915142828748' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421280' WHERE ordernumber = 'P180915143132180' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421281' WHERE ordernumber = 'P420915143156371' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '306484' WHERE ordernumber = 'P420915143255827' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421280' WHERE ordernumber = 'P180915143301925' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421283' WHERE ordernumber = 'P180915143424560' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421282' WHERE ordernumber = 'P180915143621823' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421067' WHERE ordernumber = 'P420915143633377' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421284' WHERE ordernumber = 'P200915143735956' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421286' WHERE ordernumber = 'P180915143911277' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421287' WHERE ordernumber = 'P420915143931716' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '353827' WHERE ordernumber = 'P200915144148756' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421288' WHERE ordernumber = 'P420915144215225' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '310790' WHERE ordernumber = 'P180915144247527' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '388691' WHERE ordernumber = 'P420915144253324' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '64791' WHERE ordernumber = 'P420915144457460' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '91736' WHERE ordernumber = 'P200915144558116' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '158607' WHERE ordernumber = 'P420915144754115' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421289' WHERE ordernumber = 'P420915144915739' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421290' WHERE ordernumber = 'P420915145023397' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421291' WHERE ordernumber = 'P200915145116801' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '324219' WHERE ordernumber = 'P200915145439934' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '170236' WHERE ordernumber = 'P180915145455241' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '401636' WHERE ordernumber = 'P420915145620314' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '408368' WHERE ordernumber = 'P420915150234294' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '405367' WHERE ordernumber = 'P420915150330946' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421292' WHERE ordernumber = 'P420915150505754' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '413149' WHERE ordernumber = 'P200915150521550' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421293' WHERE ordernumber = 'P420915150649248' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '392781' WHERE ordernumber = 'P180915150824489' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '271965' WHERE ordernumber = 'P420915150852459' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421294' WHERE ordernumber = 'P420915151407116' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421296' WHERE ordernumber = 'P420915151547828' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '410600' WHERE ordernumber = 'P180915151602703' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '339979' WHERE ordernumber = 'P420915151649177' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421297' WHERE ordernumber = 'P200915151708646' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '420828' WHERE ordernumber = 'P1050915151818356' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421294' WHERE ordernumber = 'P420915152021701' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '94716' WHERE ordernumber = 'P190915152243798' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '162134' WHERE ordernumber = 'P200915152347216' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421298' WHERE ordernumber = 'P200915152521579' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '224842' WHERE ordernumber = 'P180915153128400' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '394178' WHERE ordernumber = 'P420915153233250' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421299' WHERE ordernumber = 'P420915153417514' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '419858' WHERE ordernumber = 'P420915153627944' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '341339' WHERE ordernumber = 'P200915153645857' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '419858' WHERE ordernumber = 'P420915153654653' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421300' WHERE ordernumber = 'P200915153740424' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421301' WHERE ordernumber = 'P420915153919482' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '158825' WHERE ordernumber = 'P180915153919224' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '407093' WHERE ordernumber = 'P180915154121819' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '341515' WHERE ordernumber = 'P180915154201897' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421303' WHERE ordernumber = 'P200915154207593' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '292368' WHERE ordernumber = 'P420915154625744' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '400231' WHERE ordernumber = 'P200915155010687' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421304' WHERE ordernumber = 'P420915155133155' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '410900' WHERE ordernumber = 'P420915155247263' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '410900' WHERE ordernumber = 'P420915155338398' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '67010' WHERE ordernumber = 'P190915155441188' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '286090' WHERE ordernumber = 'P200915155822911' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '364642' WHERE ordernumber = 'P180915155837923' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '375115' WHERE ordernumber = 'P200915155910308' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421307' WHERE ordernumber = 'P420915160033209' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '408905' WHERE ordernumber = 'P420915160331920' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421309' WHERE ordernumber = 'P180915160624689' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421310' WHERE ordernumber = 'P420915160729217' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '245389' WHERE ordernumber = 'P420915160835235' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '402005' WHERE ordernumber = 'P180915161015377' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421312' WHERE ordernumber = 'P420915161036287' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421313' WHERE ordernumber = 'P420915161147339' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421314' WHERE ordernumber = 'P180915161231903' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '277166' WHERE ordernumber = 'P180915161329745' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '411013' WHERE ordernumber = 'P180915161420904' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421311' WHERE ordernumber = 'P1050915161432469' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '85160' WHERE ordernumber = 'P200915161524571' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421311' WHERE ordernumber = 'P1050915161525215' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '229815' WHERE ordernumber = 'P180915161533925' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '392641' WHERE ordernumber = 'P180915161749901' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '367378' WHERE ordernumber = 'P200915162031526' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421316' WHERE ordernumber = 'P420915162032137' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '208453' WHERE ordernumber = 'P180915162110201' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421318' WHERE ordernumber = 'P420915162425227' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '410963' WHERE ordernumber = 'P180915162458379' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '412772' WHERE ordernumber = 'P420915162548802' 2024-09-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '356255' WHERE ordernumber = 'P200915162640951' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421319' WHERE ordernumber = 'P420915162847551' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '131514' WHERE ordernumber = 'P200915163011976' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421320' WHERE ordernumber = 'P200915163106786' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421321' WHERE ordernumber = 'P420915163245793' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '402075' WHERE ordernumber = 'P180915163252506' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '273289' WHERE ordernumber = 'P200915163400433' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421322' WHERE ordernumber = 'P200915163510426' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '94028' WHERE ordernumber = 'P200915163822244' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '317293' WHERE ordernumber = 'P420915163824362' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421324' WHERE ordernumber = 'P180915163919143' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '416871' WHERE ordernumber = 'P420915163922549' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '356774' WHERE ordernumber = 'P200915163931222' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '301476' WHERE ordernumber = 'P200915164110233' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '337166' WHERE ordernumber = 'P200915164215714' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421325' WHERE ordernumber = 'P180915164306481' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421326' WHERE ordernumber = 'P180915164622987' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421327' WHERE ordernumber = 'P180915164958262' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421328' WHERE ordernumber = 'P180915165136987' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421306' WHERE ordernumber = 'P420915165147490' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421306' WHERE ordernumber = 'P420915165209854' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '380634' WHERE ordernumber = 'P420915165259282' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '159105' WHERE ordernumber = 'P420915170009659' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421330' WHERE ordernumber = 'P200915170226430' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421331' WHERE ordernumber = 'P420915170322806' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421332' WHERE ordernumber = 'P420915170548785' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '95172' WHERE ordernumber = 'P180915170934843' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '257648' WHERE ordernumber = 'P420915170945126' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421333' WHERE ordernumber = 'P420915171023397' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421308' WHERE ordernumber = 'P180915171123220' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421308' WHERE ordernumber = 'P180915171139375' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '402601' WHERE ordernumber = 'P420915171251302' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '309230' WHERE ordernumber = 'P180915171512630' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '345443' WHERE ordernumber = 'P180915171604541' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '310026' WHERE ordernumber = 'P180915171644311' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '397514' WHERE ordernumber = 'P180915171927996' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421335' WHERE ordernumber = 'P420915172016368' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '277175' WHERE ordernumber = 'P180915172044550' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '389746' WHERE ordernumber = 'P420915172140219' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '379256' WHERE ordernumber = 'P180915172413174' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421336' WHERE ordernumber = 'P420915172547992' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '285958' WHERE ordernumber = 'P180915172738854' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421337' WHERE ordernumber = 'P420915172748469' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '233840' WHERE ordernumber = 'P420915172918141' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '193810' WHERE ordernumber = 'P200915173239445' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421339' WHERE ordernumber = 'P420915173322449' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421340' WHERE ordernumber = 'P420915173409506' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '264854' WHERE ordernumber = 'P420915173652651' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '75049' WHERE ordernumber = 'P420915173756289' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '347892' WHERE ordernumber = 'P200915173831511' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421341' WHERE ordernumber = 'P420915173956763' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421342' WHERE ordernumber = 'P420915174457568' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421338' WHERE ordernumber = 'P190915174549248' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '412624' WHERE ordernumber = 'P420915174555317' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '410181' WHERE ordernumber = 'P200915174651712' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421343' WHERE ordernumber = 'P420915174658407' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '419909' WHERE ordernumber = 'P200915175155362' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421345' WHERE ordernumber = 'P420915175327508' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '107927' WHERE ordernumber = 'P200915175349224' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421346' WHERE ordernumber = 'P200915175533536' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '249505' WHERE ordernumber = 'P200915175834606' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '208826' WHERE ordernumber = 'P190915180039648' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421213' WHERE ordernumber = 'P200915180215146' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421347' WHERE ordernumber = 'P420915180533331' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '417831' WHERE ordernumber = 'P200915180638272' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421348' WHERE ordernumber = 'P200915180855245' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '352211' WHERE ordernumber = 'P180915181051604' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421349' WHERE ordernumber = 'P420915181113476' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '283963' WHERE ordernumber = 'P200915181230997' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421350' WHERE ordernumber = 'P420915181516739' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421352' WHERE ordernumber = 'P200915182006782' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '418932' WHERE ordernumber = 'P420915182217468' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421353' WHERE ordernumber = 'P200915182649744' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '237428' WHERE ordernumber = 'P180915182916509' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '349044' WHERE ordernumber = 'P420915182926638' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '246465' WHERE ordernumber = 'P180915183004197' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '169207' WHERE ordernumber = 'P200915183132436' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421325' WHERE ordernumber = 'P180915183312964' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '315690' WHERE ordernumber = 'P200915183334366' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '354846' WHERE ordernumber = 'P630915183452627' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421354' WHERE ordernumber = 'P420915183704963' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '342855' WHERE ordernumber = 'P200915183741241' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '419284' WHERE ordernumber = 'P420915183758653' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '419284' WHERE ordernumber = 'P420915183832151' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421355' WHERE ordernumber = 'P420915184054506' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421356' WHERE ordernumber = 'P420915184232991' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421357' WHERE ordernumber = 'P420915184342770' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '421358' WHERE ordernumber = 'P420915184447473' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '306018' WHERE ordernumber = 'P190915184525361' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '401240' WHERE ordernumber = 'P420915184557232' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '346443' WHERE ordernumber = 'P200915184623671' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '220161' WHERE ordernumber = 'P200915185604997' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '416743' WHERE ordernumber = 'P200915190218937' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '385895' WHERE ordernumber = 'P190915190622353' 2024-09-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '106459' WHERE ordernumber = 'P190915191215114' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '141909' WHERE ordernumber = 'P190915191347571' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '288749' WHERE ordernumber = 'P200915191638501' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '319383' WHERE ordernumber = 'P190915191718208' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '118273' WHERE ordernumber = 'P190915192249574' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '421362' WHERE ordernumber = 'P190915192755122' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '421364' WHERE ordernumber = 'P630915193514744' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '352719' WHERE ordernumber = 'P200915194300923' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '403846' WHERE ordernumber = 'P190915194354667' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '251294' WHERE ordernumber = 'P200915194505465' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '345429' WHERE ordernumber = 'P200915194604118' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '114142' WHERE ordernumber = 'P190915194616879' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '130063' WHERE ordernumber = 'P190915195019303' 2024-09-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '289348' WHERE ordernumber = 'P630915195107384'