2024-03-18 01:00:02 -- 將會員中心id寫入data-lake
2024-03-18 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-03-17%';
        
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141664'
                WHERE ordernumber = 'P200317110138714' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381899'
                WHERE ordernumber = 'P180317110333154' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349380'
                WHERE ordernumber = 'P180317110417998' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273422'
                WHERE ordernumber = 'P180317110607767' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381900'
                WHERE ordernumber = 'P590317111006541' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319604'
                WHERE ordernumber = 'P190317111359702' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381902'
                WHERE ordernumber = 'P420317111759337' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381903'
                WHERE ordernumber = 'P180317111957376' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381904'
                WHERE ordernumber = 'P420317112023300' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381905'
                WHERE ordernumber = 'P180317112149616' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381906'
                WHERE ordernumber = 'P180317112609708' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354489'
                WHERE ordernumber = 'P590317113056241' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '84778'
                WHERE ordernumber = 'P180317113143195' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381907'
                WHERE ordernumber = 'P420317113217260' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381908'
                WHERE ordernumber = 'P190317113258128' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230680'
                WHERE ordernumber = 'P180317113828673' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381909'
                WHERE ordernumber = 'P200317114140308' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98140'
                WHERE ordernumber = 'P200317114240369' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275038'
                WHERE ordernumber = 'P420317114459892' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259648'
                WHERE ordernumber = 'P200317114541893' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351025'
                WHERE ordernumber = 'P180317114730985' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '148149'
                WHERE ordernumber = 'P200317114955647' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381910'
                WHERE ordernumber = 'P190317115234306' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '150537'
                WHERE ordernumber = 'P180317115332736' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87871'
                WHERE ordernumber = 'P590317115412939' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381911'
                WHERE ordernumber = 'P180317115537956' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167943'
                WHERE ordernumber = 'P200317115628687' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207831'
                WHERE ordernumber = 'P420317115643970' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381910'
                WHERE ordernumber = 'P180317115706573' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276041'
                WHERE ordernumber = 'P420317115736980' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381895'
                WHERE ordernumber = 'P590317115818493' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381912'
                WHERE ordernumber = 'P180317115827602' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '52632'
                WHERE ordernumber = 'P420317120240316' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246611'
                WHERE ordernumber = 'P190317120241903' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336397'
                WHERE ordernumber = 'P180317120539565' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102337'
                WHERE ordernumber = 'P180317120710521' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358343'
                WHERE ordernumber = 'P200317120718124' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '76147'
                WHERE ordernumber = 'P180317121038276' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381913'
                WHERE ordernumber = 'P590317121736350' 
            
2024-03-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96141'
                WHERE ordernumber = 'P180317121752418' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215272'
                WHERE ordernumber = 'P180317122818216' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381914'
                WHERE ordernumber = 'P420317123229687' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381915'
                WHERE ordernumber = 'P420317123436961' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381916'
                WHERE ordernumber = 'P200317123516290' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381917'
                WHERE ordernumber = 'P200317123615262' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381919'
                WHERE ordernumber = 'P200317123733568' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381918'
                WHERE ordernumber = 'P420317123738502' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114707'
                WHERE ordernumber = 'P180317124446521' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381920'
                WHERE ordernumber = 'P180317124820989' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381920'
                WHERE ordernumber = 'P180317125001137' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381922'
                WHERE ordernumber = 'P200317125126313' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379985'
                WHERE ordernumber = 'P180317125216970' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251486'
                WHERE ordernumber = 'P180317130237778' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381923'
                WHERE ordernumber = 'P200317130309735' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365369'
                WHERE ordernumber = 'P420317130355126' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381895'
                WHERE ordernumber = 'P200317130501138' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230937'
                WHERE ordernumber = 'P180317130706754' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214550'
                WHERE ordernumber = 'P200317130835752' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381924'
                WHERE ordernumber = 'P420317130915153' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381327'
                WHERE ordernumber = 'P420317131054716' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314047'
                WHERE ordernumber = 'P420317131407527' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381926'
                WHERE ordernumber = 'P180317131552133' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97170'
                WHERE ordernumber = 'P180317131707424' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363219'
                WHERE ordernumber = 'P420317132032243' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329282'
                WHERE ordernumber = 'P420317132153452' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381927'
                WHERE ordernumber = 'P420317132535807' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381928'
                WHERE ordernumber = 'P420317132827899' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225562'
                WHERE ordernumber = 'P190317133607351' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381828'
                WHERE ordernumber = 'P420317134000287' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279244'
                WHERE ordernumber = 'P180317134004796' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378646'
                WHERE ordernumber = 'P200317134346943' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380759'
                WHERE ordernumber = 'P200317135239690' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381931'
                WHERE ordernumber = 'P200317135649272' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381932'
                WHERE ordernumber = 'P420317135757213' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381933'
                WHERE ordernumber = 'P180317140046582' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348974'
                WHERE ordernumber = 'P180317140509413' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346452'
                WHERE ordernumber = 'P420317141329527' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381935'
                WHERE ordernumber = 'P420317141615835' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253113'
                WHERE ordernumber = 'P180317141625549' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381936'
                WHERE ordernumber = 'P420317141849641' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380735'
                WHERE ordernumber = 'P190317141918756' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381937'
                WHERE ordernumber = 'P420317141954272' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313542'
                WHERE ordernumber = 'P200317143353913' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350341'
                WHERE ordernumber = 'P420317143427313' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255573'
                WHERE ordernumber = 'P180317143529303' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381939'
                WHERE ordernumber = 'P200317143605254' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381940'
                WHERE ordernumber = 'P180317143640383' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311208'
                WHERE ordernumber = 'P200317143652560' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313542'
                WHERE ordernumber = 'P200317143718695' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381767'
                WHERE ordernumber = 'P180317144452260' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381941'
                WHERE ordernumber = 'P420317144637521' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381941'
                WHERE ordernumber = 'P420317144912334' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301428'
                WHERE ordernumber = 'P180317145110830' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381942'
                WHERE ordernumber = 'P420317145135196' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381943'
                WHERE ordernumber = 'P190317145515825' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220265'
                WHERE ordernumber = 'P200317145608116' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381945'
                WHERE ordernumber = 'P200317145924541' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381946'
                WHERE ordernumber = 'P200317150112565' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381944'
                WHERE ordernumber = 'P590317150204387' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291055'
                WHERE ordernumber = 'P200317150212213' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323353'
                WHERE ordernumber = 'P420317150430177' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283782'
                WHERE ordernumber = 'P200317150431222' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381948'
                WHERE ordernumber = 'P200317150452609' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381947'
                WHERE ordernumber = 'P420317150616398' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381949'
                WHERE ordernumber = 'P180317151118144' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381950'
                WHERE ordernumber = 'P420317151214138' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317348'
                WHERE ordernumber = 'P180317151256525' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381951'
                WHERE ordernumber = 'P420317151332167' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381952'
                WHERE ordernumber = 'P420317151701830' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381953'
                WHERE ordernumber = 'P180317152123997' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358306'
                WHERE ordernumber = 'P180317152244939' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381954'
                WHERE ordernumber = 'P190317152335880' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381955'
                WHERE ordernumber = 'P420317152449396' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381934'
                WHERE ordernumber = 'P200317152537275' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381957'
                WHERE ordernumber = 'P190317152632869' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381958'
                WHERE ordernumber = 'P200317152657907' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381959'
                WHERE ordernumber = 'P420317152855521' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381960'
                WHERE ordernumber = 'P180317152911449' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381961'
                WHERE ordernumber = 'P200317153538638' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298665'
                WHERE ordernumber = 'P200317153733534' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101722'
                WHERE ordernumber = 'P180317153735769' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165024'
                WHERE ordernumber = 'P200317154511290' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287333'
                WHERE ordernumber = 'P180317154740608' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381962'
                WHERE ordernumber = 'P200317154807503' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190317155244151' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381964'
                WHERE ordernumber = 'P200317155312562' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344736'
                WHERE ordernumber = 'P200317155701820' 
            
2024-03-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96123'
                WHERE ordernumber = 'P180317155737799' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381966'
                WHERE ordernumber = 'P420317155804295' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317295'
                WHERE ordernumber = 'P190317155808680' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252861'
                WHERE ordernumber = 'P180317160015634' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381968'
                WHERE ordernumber = 'P420317160501807' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100515'
                WHERE ordernumber = 'P180317160733362' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381969'
                WHERE ordernumber = 'P420317160855405' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274955'
                WHERE ordernumber = 'P180317161457384' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381970'
                WHERE ordernumber = 'P180317161631255' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381972'
                WHERE ordernumber = 'P180317162128572' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381973'
                WHERE ordernumber = 'P200317162131623' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381974'
                WHERE ordernumber = 'P420317162148343' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381975'
                WHERE ordernumber = 'P180317162318746' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381976'
                WHERE ordernumber = 'P420317162436665' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381971'
                WHERE ordernumber = 'P200317162531576' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381977'
                WHERE ordernumber = 'P200317162715122' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337562'
                WHERE ordernumber = 'P180317162936374' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381978'
                WHERE ordernumber = 'P190317163129611' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337562'
                WHERE ordernumber = 'P180317163138127' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190317163309795' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381979'
                WHERE ordernumber = 'P180317163310852' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381980'
                WHERE ordernumber = 'P200317163437263' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381981'
                WHERE ordernumber = 'P420317163747693' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '41250'
                WHERE ordernumber = 'P180317163753215' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107419'
                WHERE ordernumber = 'P420317163816735' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338113'
                WHERE ordernumber = 'P590317163823256' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107770'
                WHERE ordernumber = 'P180317163840781' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381982'
                WHERE ordernumber = 'P200317164223797' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381983'
                WHERE ordernumber = 'P200317164234980' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119140'
                WHERE ordernumber = 'P180317164311127' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381984'
                WHERE ordernumber = 'P180317164506229' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381986'
                WHERE ordernumber = 'P420317164600436' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308019'
                WHERE ordernumber = 'P200317164823251' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P200317165336157' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381987'
                WHERE ordernumber = 'P420317165506974' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381988'
                WHERE ordernumber = 'P180317165522194' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381989'
                WHERE ordernumber = 'P200317165754285' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334112'
                WHERE ordernumber = 'P590317165850335' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381992'
                WHERE ordernumber = 'P420317170443152' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85728'
                WHERE ordernumber = 'P180317171009393' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381993'
                WHERE ordernumber = 'P180317171203592' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381990'
                WHERE ordernumber = 'P180317171513469' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381990'
                WHERE ordernumber = 'P180317171540308' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381995'
                WHERE ordernumber = 'P200317171540966' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381994'
                WHERE ordernumber = 'P180317171606798' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381994'
                WHERE ordernumber = 'P180317171630247' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381996'
                WHERE ordernumber = 'P180317171900828' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377744'
                WHERE ordernumber = 'P180317172046386' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P180317172310600' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278444'
                WHERE ordernumber = 'P180317172458940' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269016'
                WHERE ordernumber = 'P420317172650648' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381999'
                WHERE ordernumber = 'P180317172702470' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278444'
                WHERE ordernumber = 'P180317172745603' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318094'
                WHERE ordernumber = 'P420317172822843' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107391'
                WHERE ordernumber = 'P180317172924138' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304084'
                WHERE ordernumber = 'P180317173039754' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382000'
                WHERE ordernumber = 'P200317173051850' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304667'
                WHERE ordernumber = 'P420317174103211' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382001'
                WHERE ordernumber = 'P200317174245984' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382003'
                WHERE ordernumber = 'P420317174728924' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382004'
                WHERE ordernumber = 'P200317175145331' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160143'
                WHERE ordernumber = 'P190317175210114' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382005'
                WHERE ordernumber = 'P180317175302896' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382002'
                WHERE ordernumber = 'P590317175312206' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382006'
                WHERE ordernumber = 'P190317175320788' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134506'
                WHERE ordernumber = 'P420317175538770' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160947'
                WHERE ordernumber = 'P180317175908784' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '53753'
                WHERE ordernumber = 'P420317175936361' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265946'
                WHERE ordernumber = 'P200317180253789' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374299'
                WHERE ordernumber = 'P180317180707880' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382007'
                WHERE ordernumber = 'P420317180821726' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382008'
                WHERE ordernumber = 'P180317180824325' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382009'
                WHERE ordernumber = 'P420317180921609' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230647'
                WHERE ordernumber = 'P180317180924612' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382010'
                WHERE ordernumber = 'P420317181149274' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295346'
                WHERE ordernumber = 'P180317181321215' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382008'
                WHERE ordernumber = 'P180317181443714' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298055'
                WHERE ordernumber = 'P420317181448493' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141898'
                WHERE ordernumber = 'P180317181636907' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298055'
                WHERE ordernumber = 'P420317181701373' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378250'
                WHERE ordernumber = 'P180317181933343' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382012'
                WHERE ordernumber = 'P180317182812154' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366355'
                WHERE ordernumber = 'P420317183825516' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382014'
                WHERE ordernumber = 'P190317184053493' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224056'
                WHERE ordernumber = 'P420317184316685' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235631'
                WHERE ordernumber = 'P200317184400204' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118590'
                WHERE ordernumber = 'P190317184430427' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382015'
                WHERE ordernumber = 'P420317184446709' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382017'
                WHERE ordernumber = 'P190317184601734' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382016'
                WHERE ordernumber = 'P420317184604751' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378805'
                WHERE ordernumber = 'P420317185408870' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382018'
                WHERE ordernumber = 'P190317185506572' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352970'
                WHERE ordernumber = 'P200317185535377' 
            
2024-03-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258644'
                WHERE ordernumber = 'P190317185845634' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382019'
                WHERE ordernumber = 'P190317185959753' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382019'
                WHERE ordernumber = 'P190317190031974' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382020'
                WHERE ordernumber = 'P200317190416978' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '224033'
                WHERE ordernumber = 'P190317190420945' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '316030'
                WHERE ordernumber = 'P420317190621161' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228494'
                WHERE ordernumber = 'P200317190831277' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382023'
                WHERE ordernumber = 'P190317191421591' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382022'
                WHERE ordernumber = 'P190317192207177' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382022'
                WHERE ordernumber = 'P190317192252177' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382025'
                WHERE ordernumber = 'P420317192440650' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382026'
                WHERE ordernumber = 'P190317192531606' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294925'
                WHERE ordernumber = 'P200317192615856' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382027'
                WHERE ordernumber = 'P190317192748708' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382028'
                WHERE ordernumber = 'P190317193010885' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382029'
                WHERE ordernumber = 'P200317193256276' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381671'
                WHERE ordernumber = 'P420317193559973' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362842'
                WHERE ordernumber = 'P190317193803273' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161965'
                WHERE ordernumber = 'P200317193942363' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382031'
                WHERE ordernumber = 'P190317194036205' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302233'
                WHERE ordernumber = 'P420317194853812' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347529'
                WHERE ordernumber = 'P200317195137461' 
            
2024-03-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380045'
                WHERE ordernumber = 'P200317195513878'