2024-08-16 01:00:02 -- 將會員中心id寫入data-lake
2024-08-16 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-08-15%';
        
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385439'
                WHERE ordernumber = 'P200815110215362' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408675'
                WHERE ordernumber = 'P420815110258528' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217473'
                WHERE ordernumber = 'P190815110317117' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200815110343260' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403761'
                WHERE ordernumber = 'P190815110432867' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408677'
                WHERE ordernumber = 'P190815110602522' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99845'
                WHERE ordernumber = 'P190815110736195' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '330585'
                WHERE ordernumber = 'P200815110758658' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408680'
                WHERE ordernumber = 'P190815111023661' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384921'
                WHERE ordernumber = 'P180815111118556' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408681'
                WHERE ordernumber = 'P200815111252151' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165039'
                WHERE ordernumber = 'P200815111451909' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408685'
                WHERE ordernumber = 'P420815111636865' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408686'
                WHERE ordernumber = 'P200815111803651' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218546'
                WHERE ordernumber = 'P200815111947714' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276843'
                WHERE ordernumber = 'P420815112022949' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408687'
                WHERE ordernumber = 'P420815112531227' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408688'
                WHERE ordernumber = 'P190815112641911' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229003'
                WHERE ordernumber = 'P200815112729559' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318474'
                WHERE ordernumber = 'P190815112931413' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408686'
                WHERE ordernumber = 'P200815113015284' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314569'
                WHERE ordernumber = 'P180815113057410' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408693'
                WHERE ordernumber = 'P190815113250915' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '124367'
                WHERE ordernumber = 'P180815113533457' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408694'
                WHERE ordernumber = 'P200815113640558' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247853'
                WHERE ordernumber = 'P200815113738236' 
            
2024-08-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344591'
                WHERE ordernumber = 'P200815113849777' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336542'
                WHERE ordernumber = 'P200815113918250' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408697'
                WHERE ordernumber = 'P180815114003304' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408698'
                WHERE ordernumber = 'P200815114020788' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408701'
                WHERE ordernumber = 'P420815114541801' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408702'
                WHERE ordernumber = 'P200815114746284' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124367'
                WHERE ordernumber = 'P180815114747503' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160887'
                WHERE ordernumber = 'P630815115041982' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363039'
                WHERE ordernumber = 'P180815115149522' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408152'
                WHERE ordernumber = 'P180815115513263' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249592'
                WHERE ordernumber = 'P180815115721440' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403941'
                WHERE ordernumber = 'P200815115744260' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408706'
                WHERE ordernumber = 'P180815115825532' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408708'
                WHERE ordernumber = 'P200815120231762' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408711'
                WHERE ordernumber = 'P420815121126669' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245652'
                WHERE ordernumber = 'P200815121253440' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398353'
                WHERE ordernumber = 'P420815121255477' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245652'
                WHERE ordernumber = 'P200815121625561' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408715'
                WHERE ordernumber = 'P180815121744769' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400757'
                WHERE ordernumber = 'P200815121804135' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398645'
                WHERE ordernumber = 'P180815122006573' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408716'
                WHERE ordernumber = 'P420815122453680' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334987'
                WHERE ordernumber = 'P420815122749765' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259312'
                WHERE ordernumber = 'P190815122909606' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153875'
                WHERE ordernumber = 'P200815123304902' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408721'
                WHERE ordernumber = 'P420815123430945' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285414'
                WHERE ordernumber = 'P200815123527380' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408723'
                WHERE ordernumber = 'P420815123659489' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408725'
                WHERE ordernumber = 'P420815123942462' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408727'
                WHERE ordernumber = 'P420815124109846' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408733'
                WHERE ordernumber = 'P420815125125634' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '27604'
                WHERE ordernumber = 'P200815125313504' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408736'
                WHERE ordernumber = 'P420815125522506' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106191'
                WHERE ordernumber = 'P180815125930143' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270538'
                WHERE ordernumber = 'P200815130305464' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180815130646681' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408741'
                WHERE ordernumber = 'P420815131125743' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408746'
                WHERE ordernumber = 'P180815131804542' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408744'
                WHERE ordernumber = 'P180815131853729' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408749'
                WHERE ordernumber = 'P180815132007349' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216595'
                WHERE ordernumber = 'P200815133032587' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P200815133401661' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113879'
                WHERE ordernumber = 'P190815133534262' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165030'
                WHERE ordernumber = 'P190815134039217' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142736'
                WHERE ordernumber = 'P420815134056363' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '3749'
                WHERE ordernumber = 'P190815134229231' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216895'
                WHERE ordernumber = 'P190815134634740' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408767'
                WHERE ordernumber = 'P190815140240179' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310908'
                WHERE ordernumber = 'P190815140303441' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90577'
                WHERE ordernumber = 'P630815140328280' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408768'
                WHERE ordernumber = 'P190815140449992' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190815140747726' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '28699'
                WHERE ordernumber = 'P200815141106391' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P200815141232985' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400781'
                WHERE ordernumber = 'P180815141420880' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378339'
                WHERE ordernumber = 'P200815141605711' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397724'
                WHERE ordernumber = 'P200815141821919' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408775'
                WHERE ordernumber = 'P180815142134546' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402607'
                WHERE ordernumber = 'P190815143041643' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402528'
                WHERE ordernumber = 'P420815143118291' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100518'
                WHERE ordernumber = 'P190815143320549' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408789'
                WHERE ordernumber = 'P190815143549525' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91952'
                WHERE ordernumber = 'P180815143624439' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281387'
                WHERE ordernumber = 'P180815144000769' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350032'
                WHERE ordernumber = 'P190815144015165' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400843'
                WHERE ordernumber = 'P630815144343459' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408794'
                WHERE ordernumber = 'P180815144727486' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347220'
                WHERE ordernumber = 'P200815144754229' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404315'
                WHERE ordernumber = 'P200815144907817' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269457'
                WHERE ordernumber = 'P180815145046454' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408797'
                WHERE ordernumber = 'P200815145122372' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106167'
                WHERE ordernumber = 'P180815145349435' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225688'
                WHERE ordernumber = 'P630815145440564' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354160'
                WHERE ordernumber = 'P200815145732433' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385830'
                WHERE ordernumber = 'P180815150106457' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312873'
                WHERE ordernumber = 'P200815150508973' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339254'
                WHERE ordernumber = 'P420815151052390' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408805'
                WHERE ordernumber = 'P420815151247297' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408806'
                WHERE ordernumber = 'P200815151253236' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408808'
                WHERE ordernumber = 'P190815151552852' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408810'
                WHERE ordernumber = 'P190815151738640' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234750'
                WHERE ordernumber = 'P200815152431428' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252077'
                WHERE ordernumber = 'P180815152433865' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '83943'
                WHERE ordernumber = 'P190815152639586' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408814'
                WHERE ordernumber = 'P180815152809707' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408816'
                WHERE ordernumber = 'P180815153600365' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372909'
                WHERE ordernumber = 'P200815153703485' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292994'
                WHERE ordernumber = 'P180815153754818' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408819'
                WHERE ordernumber = 'P420815153819397' 
            
2024-08-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339254'
                WHERE ordernumber = 'P420815151052390' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408822'
                WHERE ordernumber = 'P420815154211688' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408823'
                WHERE ordernumber = 'P420815154558290' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408824'
                WHERE ordernumber = 'P420815154918286' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148024'
                WHERE ordernumber = 'P180815155122371' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408824'
                WHERE ordernumber = 'P420815155430963' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215485'
                WHERE ordernumber = 'P190815155513742' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406714'
                WHERE ordernumber = 'P190815155659451' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382271'
                WHERE ordernumber = 'P420815155701245' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408633'
                WHERE ordernumber = 'P180815155819549' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401879'
                WHERE ordernumber = 'P190815155923906' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408828'
                WHERE ordernumber = 'P190815160109671' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408831'
                WHERE ordernumber = 'P180815160535396' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408833'
                WHERE ordernumber = 'P180815160714188' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408834'
                WHERE ordernumber = 'P420815160751406' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408836'
                WHERE ordernumber = 'P180815160912145' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406706'
                WHERE ordernumber = 'P420815161042326' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408830'
                WHERE ordernumber = 'P200815161105423' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380174'
                WHERE ordernumber = 'P200815161412786' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282648'
                WHERE ordernumber = 'P190815162008397' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408843'
                WHERE ordernumber = 'P190815162115516' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408842'
                WHERE ordernumber = 'P420815162224509' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408844'
                WHERE ordernumber = 'P190815162249151' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408847'
                WHERE ordernumber = 'P420815162818778' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206879'
                WHERE ordernumber = 'P190815163053444' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288768'
                WHERE ordernumber = 'P420815163100363' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '193585'
                WHERE ordernumber = 'P180815163110679' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408846'
                WHERE ordernumber = 'P180815163455752' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408852'
                WHERE ordernumber = 'P180815163704562' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408854'
                WHERE ordernumber = 'P180815164455765' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343715'
                WHERE ordernumber = 'P180815164522615' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135332'
                WHERE ordernumber = 'P190815165354933' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408861'
                WHERE ordernumber = 'P200815165620438' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P180815165710255' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135332'
                WHERE ordernumber = 'P190815165754934' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408863'
                WHERE ordernumber = 'P200815165923904' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408864'
                WHERE ordernumber = 'P200815170018231' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329828'
                WHERE ordernumber = 'P420815170432471' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408866'
                WHERE ordernumber = 'P180815170459229' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288836'
                WHERE ordernumber = 'P190815170744169' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206305'
                WHERE ordernumber = 'P180815171459490' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408871'
                WHERE ordernumber = 'P200815171557511' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304198'
                WHERE ordernumber = 'P200815171828343' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408876'
                WHERE ordernumber = 'P180815172020313' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408875'
                WHERE ordernumber = 'P200815172042803' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408872'
                WHERE ordernumber = 'P180815172048822' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408875'
                WHERE ordernumber = 'P200815172221658' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309780'
                WHERE ordernumber = 'P180815172504624' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408880'
                WHERE ordernumber = 'P420815172900209' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152100'
                WHERE ordernumber = 'P180815173155349' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283325'
                WHERE ordernumber = 'P420815173506755' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408886'
                WHERE ordernumber = 'P200815173727432' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408888'
                WHERE ordernumber = 'P420815174236818' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390151'
                WHERE ordernumber = 'P180815174305132' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '38536'
                WHERE ordernumber = 'P180815174630456' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154308'
                WHERE ordernumber = 'P180815175049267' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408890'
                WHERE ordernumber = 'P420815175213550' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408892'
                WHERE ordernumber = 'P420815175318720' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408893'
                WHERE ordernumber = 'P420815175452968' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243690'
                WHERE ordernumber = 'P200815175627156' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408895'
                WHERE ordernumber = 'P180815175856788' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228553'
                WHERE ordernumber = 'P180815180329615' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408898'
                WHERE ordernumber = 'P420815180618758' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331945'
                WHERE ordernumber = 'P190815180637179' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408900'
                WHERE ordernumber = 'P420815180824891' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405780'
                WHERE ordernumber = 'P180815181017518' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398116'
                WHERE ordernumber = 'P420815181133705' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405180'
                WHERE ordernumber = 'P420815181303727' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297582'
                WHERE ordernumber = 'P420815181455123' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408903'
                WHERE ordernumber = 'P180815181553706' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408904'
                WHERE ordernumber = 'P190815181741119' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408905'
                WHERE ordernumber = 'P420815182015256' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408907'
                WHERE ordernumber = 'P190815182344283' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408908'
                WHERE ordernumber = 'P190815182504308' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283798'
                WHERE ordernumber = 'P200815182613635' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408909'
                WHERE ordernumber = 'P190815182843121' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406457'
                WHERE ordernumber = 'P200815182903497' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95439'
                WHERE ordernumber = 'P180815183011731' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240419'
                WHERE ordernumber = 'P180815183832126' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408912'
                WHERE ordernumber = 'P200815183845584' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408913'
                WHERE ordernumber = 'P180815184044123' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408915'
                WHERE ordernumber = 'P180815184437596' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285868'
                WHERE ordernumber = 'P200815184703653' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364742'
                WHERE ordernumber = 'P200815184758217' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296980'
                WHERE ordernumber = 'P420815185022531' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405747'
                WHERE ordernumber = 'P180815185326816' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98007'
                WHERE ordernumber = 'P190815190147917' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355466'
                WHERE ordernumber = 'P630815190546835' 
            
2024-08-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408918'
                WHERE ordernumber = 'P200815190554543' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386640'
                WHERE ordernumber = 'P200815190808783' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '35479'
                WHERE ordernumber = 'P630815191119566' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408920'
                WHERE ordernumber = 'P200815191249508' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282851'
                WHERE ordernumber = 'P200815191434691' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249385'
                WHERE ordernumber = 'P200815191628736' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398388'
                WHERE ordernumber = 'P190815192003383' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408927'
                WHERE ordernumber = 'P200815192216527' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408929'
                WHERE ordernumber = 'P200815192410979' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251258'
                WHERE ordernumber = 'P190815192442549' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396200'
                WHERE ordernumber = 'P200815192507349' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408932'
                WHERE ordernumber = 'P200815192851187' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407321'
                WHERE ordernumber = 'P200815193018682' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408934'
                WHERE ordernumber = 'P200815193224633' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336454'
                WHERE ordernumber = 'P200815195417546' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P590815202708531' 
            
2024-08-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110046'
                WHERE ordernumber = 'P590815213314402'