2024-10-07 01:00:02 -- 將會員中心id寫入data-lake
2024-10-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-10-06%';
        
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403535'
                WHERE ordernumber = 'P631006102757226' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273578'
                WHERE ordernumber = 'P631006104513669' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424406'
                WHERE ordernumber = 'P631006104712255' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P191006110113615' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424409'
                WHERE ordernumber = 'P201006110321650' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P201006110411441' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419177'
                WHERE ordernumber = 'P191006110424316' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424408'
                WHERE ordernumber = 'P421006110436253' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424410'
                WHERE ordernumber = 'P201006110531417' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356224'
                WHERE ordernumber = 'P201006110717355' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424411'
                WHERE ordernumber = 'P181006110806764' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374803'
                WHERE ordernumber = 'P631006110812123' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424414'
                WHERE ordernumber = 'P201006110948916' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424413'
                WHERE ordernumber = 'P181006111429943' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424407'
                WHERE ordernumber = 'P191006111512231' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424412'
                WHERE ordernumber = 'P181006111613312' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424415'
                WHERE ordernumber = 'P421006111944569' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360048'
                WHERE ordernumber = 'P181006112048837' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '196883'
                WHERE ordernumber = 'P191006112144953' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424417'
                WHERE ordernumber = 'P181006112313563' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424418'
                WHERE ordernumber = 'P201006112332415' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424417'
                WHERE ordernumber = 'P181006112334306' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424416'
                WHERE ordernumber = 'P421006112507348' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424419'
                WHERE ordernumber = 'P181006112653607' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424422'
                WHERE ordernumber = 'P181006113135298' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P181006113726387' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107790'
                WHERE ordernumber = 'P191006113903987' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424423'
                WHERE ordernumber = 'P181006114112347' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424425'
                WHERE ordernumber = 'P421006114335950' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141511'
                WHERE ordernumber = 'P201006114339209' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424426'
                WHERE ordernumber = 'P421006114747577' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423956'
                WHERE ordernumber = 'P181006114841299' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '22464'
                WHERE ordernumber = 'P421006114857874' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385965'
                WHERE ordernumber = 'P631006114928485' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416158'
                WHERE ordernumber = 'P191006115142293' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424427'
                WHERE ordernumber = 'P731006115157900' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423956'
                WHERE ordernumber = 'P181006115411996' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424428'
                WHERE ordernumber = 'P731006115702571' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P201006115824487' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281969'
                WHERE ordernumber = 'P201006120055712' 
            
2024-10-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424430'
                WHERE ordernumber = 'P201006120639826' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424432'
                WHERE ordernumber = 'P421006122010951' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424433'
                WHERE ordernumber = 'P711006122445121' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103860'
                WHERE ordernumber = 'P181006122559476' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424435'
                WHERE ordernumber = 'P421006122823349' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100182'
                WHERE ordernumber = 'P181006122827665' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424434'
                WHERE ordernumber = 'P731006122901821' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345668'
                WHERE ordernumber = 'P421006123139564' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424437'
                WHERE ordernumber = 'P731006123521324' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424438'
                WHERE ordernumber = 'P201006123913125' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424439'
                WHERE ordernumber = 'P731006124259992' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424440'
                WHERE ordernumber = 'P421006124653781' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349641'
                WHERE ordernumber = 'P181006124707715' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350393'
                WHERE ordernumber = 'P731006124747677' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219829'
                WHERE ordernumber = 'P181006125033903' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219829'
                WHERE ordernumber = 'P181006125257588' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424442'
                WHERE ordernumber = 'P191006125256202' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424444'
                WHERE ordernumber = 'P181006125901767' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P181006130052226' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424445'
                WHERE ordernumber = 'P191006130233289' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424444'
                WHERE ordernumber = 'P181006130732223' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424446'
                WHERE ordernumber = 'P201006130909464' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397679'
                WHERE ordernumber = 'P421006131421181' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339683'
                WHERE ordernumber = 'P421006131454357' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424447'
                WHERE ordernumber = 'P181006131754169' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95033'
                WHERE ordernumber = 'P201006132142352' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424448'
                WHERE ordernumber = 'P181006132153776' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424449'
                WHERE ordernumber = 'P421006132222386' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424448'
                WHERE ordernumber = 'P181006132222127' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '50278'
                WHERE ordernumber = 'P731006132310190' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424450'
                WHERE ordernumber = 'P191006132453814' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424363'
                WHERE ordernumber = 'P181006132457146' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '194509'
                WHERE ordernumber = 'P191006132641660' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424452'
                WHERE ordernumber = 'P711006133034666' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424451'
                WHERE ordernumber = 'P181006133046793' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424454'
                WHERE ordernumber = 'P201006133133447' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424453'
                WHERE ordernumber = 'P181006133219269' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420782'
                WHERE ordernumber = 'P421006133402617' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424455'
                WHERE ordernumber = 'P201006133628933' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398625'
                WHERE ordernumber = 'P201006134053499' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424456'
                WHERE ordernumber = 'P181006134427926' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424458'
                WHERE ordernumber = 'P711006135016326' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424460'
                WHERE ordernumber = 'P181006135309496' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141776'
                WHERE ordernumber = 'P191006135343140' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424462'
                WHERE ordernumber = 'P711006135457224' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424457'
                WHERE ordernumber = 'P731006135543642' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P191006135603338' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224236'
                WHERE ordernumber = 'P181006135612924' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424461'
                WHERE ordernumber = 'P181006135733548' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424463'
                WHERE ordernumber = 'P731006140346775' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307869'
                WHERE ordernumber = 'P181006140638815' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409580'
                WHERE ordernumber = 'P421006140943726' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424465'
                WHERE ordernumber = 'P181006141434162' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424464'
                WHERE ordernumber = 'P191006141535847' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424468'
                WHERE ordernumber = 'P731006141615309' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424467'
                WHERE ordernumber = 'P181006141625898' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424469'
                WHERE ordernumber = 'P181006141858724' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241376'
                WHERE ordernumber = 'P711006142118311' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424470'
                WHERE ordernumber = 'P731006142250931' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419348'
                WHERE ordernumber = 'P421006142439673' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424472'
                WHERE ordernumber = 'P731006142459285' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387696'
                WHERE ordernumber = 'P421006142527638' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424473'
                WHERE ordernumber = 'P711006142610891' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424474'
                WHERE ordernumber = 'P201006142715657' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424471'
                WHERE ordernumber = 'P421006142817503' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424477'
                WHERE ordernumber = 'P201006142956914' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424475'
                WHERE ordernumber = 'P731006143001763' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287670'
                WHERE ordernumber = 'P731006143110297' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424476'
                WHERE ordernumber = 'P421006143125418' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234151'
                WHERE ordernumber = 'P201006143139923' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424478'
                WHERE ordernumber = 'P181006143320248' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '170080'
                WHERE ordernumber = 'P421006143438294' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424406'
                WHERE ordernumber = 'P631006143506402' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93476'
                WHERE ordernumber = 'P181006143710525' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401701'
                WHERE ordernumber = 'P421006143826843' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424479'
                WHERE ordernumber = 'P191006144220767' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423327'
                WHERE ordernumber = 'P181006144232909' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424480'
                WHERE ordernumber = 'P421006144343319' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424482'
                WHERE ordernumber = 'P421006144705732' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423792'
                WHERE ordernumber = 'P201006144736718' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424483'
                WHERE ordernumber = 'P421006144818305' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284434'
                WHERE ordernumber = 'P191006144938390' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424481'
                WHERE ordernumber = 'P181006144957295' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424484'
                WHERE ordernumber = 'P191006145224598' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153662'
                WHERE ordernumber = 'P731006145246602' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424485'
                WHERE ordernumber = 'P711006145526136' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292465'
                WHERE ordernumber = 'P201006145550255' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424486'
                WHERE ordernumber = 'P711006145724758' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362318'
                WHERE ordernumber = 'P181006145928663' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125136'
                WHERE ordernumber = 'P711006145958119' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234552'
                WHERE ordernumber = 'P201006150319570' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424489'
                WHERE ordernumber = 'P201006150927358' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424488'
                WHERE ordernumber = 'P191006151119145' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291204'
                WHERE ordernumber = 'P201006151120642' 
            
2024-10-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424487'
                WHERE ordernumber = 'P181006151239243' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335289'
                WHERE ordernumber = 'P191006151317693' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253185'
                WHERE ordernumber = 'P201006151324369' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336984'
                WHERE ordernumber = 'P181006151527312' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424490'
                WHERE ordernumber = 'P731006151733698' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342524'
                WHERE ordernumber = 'P631006151904531' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424492'
                WHERE ordernumber = 'P421006152026694' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424491'
                WHERE ordernumber = 'P421006152053208' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424493'
                WHERE ordernumber = 'P731006152109186' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417256'
                WHERE ordernumber = 'P421006152158773' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424495'
                WHERE ordernumber = 'P201006152535466' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424496'
                WHERE ordernumber = 'P181006152954694' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424497'
                WHERE ordernumber = 'P421006153305959' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290016'
                WHERE ordernumber = 'P421006153702981' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424498'
                WHERE ordernumber = 'P711006153716466' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424501'
                WHERE ordernumber = 'P711006154037492' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424499'
                WHERE ordernumber = 'P181006154408175' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424500'
                WHERE ordernumber = 'P421006154740517' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424502'
                WHERE ordernumber = 'P181006154841916' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133035'
                WHERE ordernumber = 'P181006155142839' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424503'
                WHERE ordernumber = 'P421006155649798' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278867'
                WHERE ordernumber = 'P181006155737708' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347375'
                WHERE ordernumber = 'P181006160203266' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424504'
                WHERE ordernumber = 'P201006160811918' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424505'
                WHERE ordernumber = 'P711006160940233' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424507'
                WHERE ordernumber = 'P201006161022886' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368021'
                WHERE ordernumber = 'P191006161056767' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104445'
                WHERE ordernumber = 'P191006161146554' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424506'
                WHERE ordernumber = 'P191006161631965' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424509'
                WHERE ordernumber = 'P421006161803920' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424510'
                WHERE ordernumber = 'P181006161907201' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424511'
                WHERE ordernumber = 'P421006161920317' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101596'
                WHERE ordernumber = 'P191006161939968' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424510'
                WHERE ordernumber = 'P181006161955764' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253491'
                WHERE ordernumber = 'P191006162739506' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424512'
                WHERE ordernumber = 'P181006163034612' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424512'
                WHERE ordernumber = 'P181006163111691' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P201006163126477' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281082'
                WHERE ordernumber = 'P201006163231355' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424513'
                WHERE ordernumber = 'P421006163312400' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424515'
                WHERE ordernumber = 'P201006163345765' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424518'
                WHERE ordernumber = 'P201006163555424' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424520'
                WHERE ordernumber = 'P421006163651655' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424516'
                WHERE ordernumber = 'P421006163803557' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424522'
                WHERE ordernumber = 'P201006163900821' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424523'
                WHERE ordernumber = 'P421006164322741' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424525'
                WHERE ordernumber = 'P201006164518567' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142285'
                WHERE ordernumber = 'P421006164612272' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424526'
                WHERE ordernumber = 'P421006164710919' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424528'
                WHERE ordernumber = 'P421006164944815' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298136'
                WHERE ordernumber = 'P421006165029766' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424524'
                WHERE ordernumber = 'P421006165227806' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422289'
                WHERE ordernumber = 'P421006165504371' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424527'
                WHERE ordernumber = 'P421006165624712' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424529'
                WHERE ordernumber = 'P731006165723122' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227711'
                WHERE ordernumber = 'P181006165814920' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344260'
                WHERE ordernumber = 'P421006170129715' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424530'
                WHERE ordernumber = 'P421006170941649' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159536'
                WHERE ordernumber = 'P181006171111706' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401847'
                WHERE ordernumber = 'P181006171259528' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424532'
                WHERE ordernumber = 'P201006171308893' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424535'
                WHERE ordernumber = 'P731006171621365' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424533'
                WHERE ordernumber = 'P181006171827956' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424534'
                WHERE ordernumber = 'P191006171837265' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268115'
                WHERE ordernumber = 'P181006172014464' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262630'
                WHERE ordernumber = 'P191006172051573' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268115'
                WHERE ordernumber = 'P181006172155583' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424536'
                WHERE ordernumber = 'P711006172233932' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350864'
                WHERE ordernumber = 'P181006172759473' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424538'
                WHERE ordernumber = 'P201006172845593' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372870'
                WHERE ordernumber = 'P181006173006507' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247023'
                WHERE ordernumber = 'P201006173044216' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424539'
                WHERE ordernumber = 'P201006173214456' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104047'
                WHERE ordernumber = 'P181006173303407' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409975'
                WHERE ordernumber = 'P201006173314847' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424540'
                WHERE ordernumber = 'P181006173653457' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424541'
                WHERE ordernumber = 'P181006173857343' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238181'
                WHERE ordernumber = 'P181006174059670' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424544'
                WHERE ordernumber = 'P421006174328624' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424547'
                WHERE ordernumber = 'P201006174409878' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424543'
                WHERE ordernumber = 'P421006174526659' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424545'
                WHERE ordernumber = 'P421006174602819' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424546'
                WHERE ordernumber = 'P421006174657239' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420385'
                WHERE ordernumber = 'P421006174937415' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399160'
                WHERE ordernumber = 'P421006175137838' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89055'
                WHERE ordernumber = 'P201006175137930' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424549'
                WHERE ordernumber = 'P181006175234365' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424551'
                WHERE ordernumber = 'P731006175349663' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181006175511893' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424552'
                WHERE ordernumber = 'P421006175529747' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424537'
                WHERE ordernumber = 'P201006175912692' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424553'
                WHERE ordernumber = 'P421006175918571' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424554'
                WHERE ordernumber = 'P421006180232127' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424556'
                WHERE ordernumber = 'P421006181114792' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424558'
                WHERE ordernumber = 'P421006181341197' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424557'
                WHERE ordernumber = 'P181006181437392' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256644'
                WHERE ordernumber = 'P201006181708658' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424559'
                WHERE ordernumber = 'P631006181728698' 
            
2024-10-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256644'
                WHERE ordernumber = 'P201006181735260' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424562'
                WHERE ordernumber = 'P201006182307962' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424563'
                WHERE ordernumber = 'P191006182621573' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386390'
                WHERE ordernumber = 'P201006183357567' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231741'
                WHERE ordernumber = 'P201006183807166' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422781'
                WHERE ordernumber = 'P201006184249653' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P421006185628494' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206843'
                WHERE ordernumber = 'P711006190245823' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356407'
                WHERE ordernumber = 'P631006191057974' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312863'
                WHERE ordernumber = 'P191006192602894' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94437'
                WHERE ordernumber = 'P191006193159203' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424536'
                WHERE ordernumber = 'P711006193454445' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424566'
                WHERE ordernumber = 'P711006194241166' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98260'
                WHERE ordernumber = 'P191006195025180' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251367'
                WHERE ordernumber = 'P631006200651485' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424569'
                WHERE ordernumber = 'P711006203519934' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424570'
                WHERE ordernumber = 'P711006203828149' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424571'
                WHERE ordernumber = 'P711006204352191' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424573'
                WHERE ordernumber = 'P711006212100291' 
            
2024-10-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '33821'
                WHERE ordernumber = 'P631006212750136'