2024-03-07 01:00:02 -- 將會員中心id寫入data-lake
2024-03-07 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-06%';
        
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P420306105402964' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380302'
                WHERE ordernumber = 'P420306105945900' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234846'
                WHERE ordernumber = 'P180306110347976' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380303'
                WHERE ordernumber = 'P190306110421403' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380304'
                WHERE ordernumber = 'P200306110646217' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380305'
                WHERE ordernumber = 'P180306110812344' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380306'
                WHERE ordernumber = 'P420306110826904' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305249'
                WHERE ordernumber = 'P200306111150810' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274721'
                WHERE ordernumber = 'P180306111322923' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231451'
                WHERE ordernumber = 'P190306111503496' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380300'
                WHERE ordernumber = 'P200306111939230' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200306113130429' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133280'
                WHERE ordernumber = 'P180306113507728' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380307'
                WHERE ordernumber = 'P190306113550396' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380309'
                WHERE ordernumber = 'P180306113748115' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371729'
                WHERE ordernumber = 'P190306113841183' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380308'
                WHERE ordernumber = 'P590306114016151' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380311'
                WHERE ordernumber = 'P590306114124642' 
            
2024-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380313'
                WHERE ordernumber = 'P180306114253605' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380315'
                WHERE ordernumber = 'P180306114451567' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317028'
                WHERE ordernumber = 'P180306114613207' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162853'
                WHERE ordernumber = 'P200306114646902' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380316'
                WHERE ordernumber = 'P420306120051584' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368915'
                WHERE ordernumber = 'P200306120401479' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380317'
                WHERE ordernumber = 'P420306120459547' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380318'
                WHERE ordernumber = 'P420306120602119' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380319'
                WHERE ordernumber = 'P420306120811196' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380321'
                WHERE ordernumber = 'P180306122003471' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380323'
                WHERE ordernumber = 'P420306122256495' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380324'
                WHERE ordernumber = 'P590306122911530' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380327'
                WHERE ordernumber = 'P200306123105743' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380326'
                WHERE ordernumber = 'P590306123840288' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308743'
                WHERE ordernumber = 'P180306124144992' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380329'
                WHERE ordernumber = 'P180306124250251' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380331'
                WHERE ordernumber = 'P420306124925964' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287207'
                WHERE ordernumber = 'P180306125010442' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130125'
                WHERE ordernumber = 'P180306125537269' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380297'
                WHERE ordernumber = 'P590306130041691' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346458'
                WHERE ordernumber = 'P200306130253377' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380334'
                WHERE ordernumber = 'P200306130925913' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180306131815255' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166340'
                WHERE ordernumber = 'P180306131915375' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213527'
                WHERE ordernumber = 'P200306132504992' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380336'
                WHERE ordernumber = 'P180306132923421' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380337'
                WHERE ordernumber = 'P420306133011416' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380339'
                WHERE ordernumber = 'P180306133102790' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378465'
                WHERE ordernumber = 'P200306133422659' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200306134127549' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138938'
                WHERE ordernumber = 'P190306134317200' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380340'
                WHERE ordernumber = 'P200306134430915' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380341'
                WHERE ordernumber = 'P180306134526326' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380342'
                WHERE ordernumber = 'P190306134545461' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301684'
                WHERE ordernumber = 'P180306135048318' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380343'
                WHERE ordernumber = 'P420306140316138' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380344'
                WHERE ordernumber = 'P420306140402511' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344460'
                WHERE ordernumber = 'P420306140505611' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380345'
                WHERE ordernumber = 'P180306140655247' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380346'
                WHERE ordernumber = 'P420306140910929' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380347'
                WHERE ordernumber = 'P200306141106279' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380348'
                WHERE ordernumber = 'P180306141230234' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243904'
                WHERE ordernumber = 'P420306141312811' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272211'
                WHERE ordernumber = 'P180306141440435' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380350'
                WHERE ordernumber = 'P200306141803992' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180306141856569' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380351'
                WHERE ordernumber = 'P200306142102887' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380353'
                WHERE ordernumber = 'P420306142510509' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342512'
                WHERE ordernumber = 'P180306142724520' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380295'
                WHERE ordernumber = 'P200306142936970' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380295'
                WHERE ordernumber = 'P200306142940810' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380354'
                WHERE ordernumber = 'P420306143014261' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301962'
                WHERE ordernumber = 'P420306143113374' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380357'
                WHERE ordernumber = 'P180306144333872' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277541'
                WHERE ordernumber = 'P200306144923245' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380358'
                WHERE ordernumber = 'P180306145304159' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200306145421140' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P180306150014378' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380359'
                WHERE ordernumber = 'P200306150216335' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360202'
                WHERE ordernumber = 'P180306150854769' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297310'
                WHERE ordernumber = 'P180306151010442' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298198'
                WHERE ordernumber = 'P200306152204404' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107950'
                WHERE ordernumber = 'P180306154051993' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380361'
                WHERE ordernumber = 'P590306154241640' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285577'
                WHERE ordernumber = 'P200306154244576' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348677'
                WHERE ordernumber = 'P180306154316972' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299656'
                WHERE ordernumber = 'P420306154614204' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285577'
                WHERE ordernumber = 'P200306154904421' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230299'
                WHERE ordernumber = 'P180306155052928' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380362'
                WHERE ordernumber = 'P590306155217807' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248954'
                WHERE ordernumber = 'P180306155259795' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374695'
                WHERE ordernumber = 'P180306155859667' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380364'
                WHERE ordernumber = 'P590306160124225' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380365'
                WHERE ordernumber = 'P180306160139908' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378757'
                WHERE ordernumber = 'P180306160704331' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98203'
                WHERE ordernumber = 'P200306160909915' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380367'
                WHERE ordernumber = 'P420306161333622' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380368'
                WHERE ordernumber = 'P180306161530192' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89653'
                WHERE ordernumber = 'P200306161640138' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377847'
                WHERE ordernumber = 'P200306162029561' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224465'
                WHERE ordernumber = 'P200306162318687' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380369'
                WHERE ordernumber = 'P420306162423566' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322422'
                WHERE ordernumber = 'P180306163114392' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247444'
                WHERE ordernumber = 'P200306163117251' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322422'
                WHERE ordernumber = 'P180306163205766' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238422'
                WHERE ordernumber = 'P180306163340636' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350232'
                WHERE ordernumber = 'P180306163502971' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380371'
                WHERE ordernumber = 'P180306163605912' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156381'
                WHERE ordernumber = 'P200306163637191' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309849'
                WHERE ordernumber = 'P180306163954936' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378892'
                WHERE ordernumber = 'P180306164057451' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380372'
                WHERE ordernumber = 'P200306164115159' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200306164533754' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380373'
                WHERE ordernumber = 'P420306165730751' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228399'
                WHERE ordernumber = 'P420306170120525' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97411'
                WHERE ordernumber = 'P200306170253342' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380374'
                WHERE ordernumber = 'P200306170439981' 
            
2024-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '815'
                WHERE ordernumber = 'P180306170522937' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95991'
                WHERE ordernumber = 'P200306170536827' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380375'
                WHERE ordernumber = 'P200306170713394' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374582'
                WHERE ordernumber = 'P200306170801466' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379190'
                WHERE ordernumber = 'P420306171126554' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380378'
                WHERE ordernumber = 'P200306171134797' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380381'
                WHERE ordernumber = 'P200306173519636' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380382'
                WHERE ordernumber = 'P200306173623371' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380383'
                WHERE ordernumber = 'P200306174331699' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122789'
                WHERE ordernumber = 'P180306174559753' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380384'
                WHERE ordernumber = 'P420306174659384' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380385'
                WHERE ordernumber = 'P200306174709147' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380386'
                WHERE ordernumber = 'P200306175003340' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127611'
                WHERE ordernumber = 'P180306175640632' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292240'
                WHERE ordernumber = 'P200306180641787' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380390'
                WHERE ordernumber = 'P180306181008937' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234966'
                WHERE ordernumber = 'P200306181123483' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146448'
                WHERE ordernumber = 'P180306181154356' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359857'
                WHERE ordernumber = 'P200306181258377' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364176'
                WHERE ordernumber = 'P180306181704990' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284248'
                WHERE ordernumber = 'P180306181808675' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354447'
                WHERE ordernumber = 'P180306182015556' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94983'
                WHERE ordernumber = 'P200306182403544' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380392'
                WHERE ordernumber = 'P200306182618834' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366250'
                WHERE ordernumber = 'P180306182821999' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380393'
                WHERE ordernumber = 'P180306183529293' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P180306184409633' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214465'
                WHERE ordernumber = 'P180306184620675' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256656'
                WHERE ordernumber = 'P200306184805993' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304451'
                WHERE ordernumber = 'P420306184819912' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380394'
                WHERE ordernumber = 'P420306184941666' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380395'
                WHERE ordernumber = 'P200306185324162' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232359'
                WHERE ordernumber = 'P200306190540770' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380396'
                WHERE ordernumber = 'P420306190631442' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237657'
                WHERE ordernumber = 'P190306190841804' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380397'
                WHERE ordernumber = 'P420306191254225' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350632'
                WHERE ordernumber = 'P200306191441975' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380398'
                WHERE ordernumber = 'P200306191839148' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282304'
                WHERE ordernumber = 'P190306192032783' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379186'
                WHERE ordernumber = 'P200306193026766' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380399'
                WHERE ordernumber = 'P190306193218173' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78879'
                WHERE ordernumber = 'P190306193359389' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380400'
                WHERE ordernumber = 'P200306193606770' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380401'
                WHERE ordernumber = 'P420306194210629' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '2588'
                WHERE ordernumber = 'P420306194844438' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357650'
                WHERE ordernumber = 'P190306194842969' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288230'
                WHERE ordernumber = 'P190306195147228' 
            
2024-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380403'
                WHERE ordernumber = 'P190306200104132'