2024-11-17 01:00:02 -- 將會員中心id寫入data-lake
2024-11-17 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-11-16%';
        
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396977'
                WHERE ordernumber = 'P2411160000231' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46603'
                WHERE ordernumber = 'P2411160000359' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403292'
                WHERE ordernumber = 'P2411160000532' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426759'
                WHERE ordernumber = 'P2411160000811' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430427'
                WHERE ordernumber = 'P2411160001062' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352626'
                WHERE ordernumber = 'P2411160001147' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394499'
                WHERE ordernumber = 'P2411160001277' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379470'
                WHERE ordernumber = 'P2411160001390' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430429'
                WHERE ordernumber = 'P2411160001475' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430430'
                WHERE ordernumber = 'P2411160001690' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380784'
                WHERE ordernumber = 'P2411160001851' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430432'
                WHERE ordernumber = 'P2411160001926' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430431'
                WHERE ordernumber = 'P2411160002099' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430434'
                WHERE ordernumber = 'P2411160002539' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430433'
                WHERE ordernumber = 'P2411160002651' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430422'
                WHERE ordernumber = 'P2411160002881' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430435'
                WHERE ordernumber = 'P2411160002982' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430438'
                WHERE ordernumber = 'P2411160003095' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430437'
                WHERE ordernumber = 'P2411160003266' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268830'
                WHERE ordernumber = 'P2411160003375' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395011'
                WHERE ordernumber = 'P2411160003417' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430439'
                WHERE ordernumber = 'P2411160003692' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430440'
                WHERE ordernumber = 'P2411160003853' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385317'
                WHERE ordernumber = 'P2411160003963' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430442'
                WHERE ordernumber = 'P2411160004758' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395131'
                WHERE ordernumber = 'P2411160004949' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430443'
                WHERE ordernumber = 'P2411160005282' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430444'
                WHERE ordernumber = 'P2411160005320' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430446'
                WHERE ordernumber = 'P2411160005416' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430445'
                WHERE ordernumber = 'P2411160005518' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207123'
                WHERE ordernumber = 'P2411160005862' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430447'
                WHERE ordernumber = 'P2411160005942' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368224'
                WHERE ordernumber = 'P2411160006073' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430406'
                WHERE ordernumber = 'P2411160006158' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P2411160006817' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427640'
                WHERE ordernumber = 'P2411160006930' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430450'
                WHERE ordernumber = 'P2411160007043' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340041'
                WHERE ordernumber = 'P2411160007160' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430448'
                WHERE ordernumber = 'P2411160007278' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430451'
                WHERE ordernumber = 'P2411160007391' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396718'
                WHERE ordernumber = 'P2411160007484' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422323'
                WHERE ordernumber = 'P2411160007564' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430454'
                WHERE ordernumber = 'P2411160007756' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430452'
                WHERE ordernumber = 'P2411160007972' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430455'
                WHERE ordernumber = 'P2411160008248' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101828'
                WHERE ordernumber = 'P2411160008345' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430458'
                WHERE ordernumber = 'P2411160008476' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '24223'
                WHERE ordernumber = 'P2411160008551' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255762'
                WHERE ordernumber = 'P2411160008652' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '24223'
                WHERE ordernumber = 'P2411160008774' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430460'
                WHERE ordernumber = 'P2411160008895' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387520'
                WHERE ordernumber = 'P2411160008954' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417227'
                WHERE ordernumber = 'P2411160009377' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146262'
                WHERE ordernumber = 'P2411160009572' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356345'
                WHERE ordernumber = 'P2411160009743' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286464'
                WHERE ordernumber = 'P2411160010095' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391942'
                WHERE ordernumber = 'P2411160010348' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430463'
                WHERE ordernumber = 'P2411160010590' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284685'
                WHERE ordernumber = 'P2411160010767' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339912'
                WHERE ordernumber = 'P2411160010916' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430466'
                WHERE ordernumber = 'P2411160011629' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299755'
                WHERE ordernumber = 'P2411160011714' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167494'
                WHERE ordernumber = 'P2411160011923' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424658'
                WHERE ordernumber = 'P2411160012798' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430468'
                WHERE ordernumber = 'P2411160012899' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430469'
                WHERE ordernumber = 'P2411160013072' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309225'
                WHERE ordernumber = 'P2411160013222' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283600'
                WHERE ordernumber = 'P2411160013338' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361082'
                WHERE ordernumber = 'P2411160013580' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430470'
                WHERE ordernumber = 'P2411160013625' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430467'
                WHERE ordernumber = 'P2411160013755' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430471'
                WHERE ordernumber = 'P2411160013899' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430472'
                WHERE ordernumber = 'P2411160013999' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214519'
                WHERE ordernumber = 'P2411160014233' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430473'
                WHERE ordernumber = 'P2411160014414' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430474'
                WHERE ordernumber = 'P2411160014859' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375972'
                WHERE ordernumber = 'P2411160014960' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430476'
                WHERE ordernumber = 'P2411160015143' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430474'
                WHERE ordernumber = 'P2411160015237' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430478'
                WHERE ordernumber = 'P2411160015315' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430480'
                WHERE ordernumber = 'P2411160015430' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296398'
                WHERE ordernumber = 'P2411160015578' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430482'
                WHERE ordernumber = 'P2411160015628' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106180'
                WHERE ordernumber = 'P2411160015765' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430481'
                WHERE ordernumber = 'P2411160015820' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430477'
                WHERE ordernumber = 'P2411160015962' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307752'
                WHERE ordernumber = 'P2411160016225' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430483'
                WHERE ordernumber = 'P2411160016391' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430484'
                WHERE ordernumber = 'P2411160016468' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95433'
                WHERE ordernumber = 'P2411160016540' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246901'
                WHERE ordernumber = 'P2411160016631' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430488'
                WHERE ordernumber = 'P2411160016846' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430489'
                WHERE ordernumber = 'P2411160016955' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91125'
                WHERE ordernumber = 'P2411160017018' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430490'
                WHERE ordernumber = 'P2411160017195' 
            
2024-11-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99445'
                WHERE ordernumber = 'P2411160017375' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225145'
                WHERE ordernumber = 'P2411160017475' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430484'
                WHERE ordernumber = 'P2411160017550' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380797'
                WHERE ordernumber = 'P2411160017649' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208112'
                WHERE ordernumber = 'P2411160017734' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380797'
                WHERE ordernumber = 'P2411160017815' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430486'
                WHERE ordernumber = 'P2411160018293' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430491'
                WHERE ordernumber = 'P2411160018379' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430492'
                WHERE ordernumber = 'P2411160018477' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430412'
                WHERE ordernumber = 'P2411160018528' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430485'
                WHERE ordernumber = 'P2411160018671' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430493'
                WHERE ordernumber = 'P2411160018813' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306273'
                WHERE ordernumber = 'P2411160018967' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430493'
                WHERE ordernumber = 'P2411160019036' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347354'
                WHERE ordernumber = 'P2411160019166' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399842'
                WHERE ordernumber = 'P2411160019291' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '77463'
                WHERE ordernumber = 'P2411160019447' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430495'
                WHERE ordernumber = 'P2411160019590' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430496'
                WHERE ordernumber = 'P2411160019647' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420184'
                WHERE ordernumber = 'P2411160019753' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95433'
                WHERE ordernumber = 'P2411160019868' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114727'
                WHERE ordernumber = 'P2411160019932' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430499'
                WHERE ordernumber = 'P2411160020178' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420128'
                WHERE ordernumber = 'P2411160020212' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430500'
                WHERE ordernumber = 'P2411160020456' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430501'
                WHERE ordernumber = 'P2411160021175' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157569'
                WHERE ordernumber = 'P2411160021262' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430502'
                WHERE ordernumber = 'P2411160021350' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430504'
                WHERE ordernumber = 'P2411160021778' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30556'
                WHERE ordernumber = 'P2411160021856' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430505'
                WHERE ordernumber = 'P2411160021938' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430506'
                WHERE ordernumber = 'P2411160022375' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430507'
                WHERE ordernumber = 'P2411160022284' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430509'
                WHERE ordernumber = 'P2411160022447' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430508'
                WHERE ordernumber = 'P2411160022546' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347551'
                WHERE ordernumber = 'P2411160022639' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430511'
                WHERE ordernumber = 'P2411160022775' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430510'
                WHERE ordernumber = 'P2411160022911' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430512'
                WHERE ordernumber = 'P2411160023165' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405262'
                WHERE ordernumber = 'P2411160023273' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430513'
                WHERE ordernumber = 'P2411160023367' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430514'
                WHERE ordernumber = 'P2411160023964' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430517'
                WHERE ordernumber = 'P2411160024066' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296849'
                WHERE ordernumber = 'P2411160024168' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164460'
                WHERE ordernumber = 'P2411160024265' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430518'
                WHERE ordernumber = 'P2411160024351' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397129'
                WHERE ordernumber = 'P2411160024432' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405899'
                WHERE ordernumber = 'P2411160024515' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430519'
                WHERE ordernumber = 'P2411160024897' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430516'
                WHERE ordernumber = 'P2411160024972' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318869'
                WHERE ordernumber = 'P2411160025080' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379439'
                WHERE ordernumber = 'P2411160025576' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430520'
                WHERE ordernumber = 'P2411160025673' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430521'
                WHERE ordernumber = 'P2411160025990' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430519'
                WHERE ordernumber = 'P2411160026052' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430523'
                WHERE ordernumber = 'P2411160026199' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430522'
                WHERE ordernumber = 'P2411160026273' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220126'
                WHERE ordernumber = 'P2411160026445' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429723'
                WHERE ordernumber = 'P2411160026670' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348093'
                WHERE ordernumber = 'P2411160026783' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430524'
                WHERE ordernumber = 'P2411160026858' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354150'
                WHERE ordernumber = 'P2411160026949' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361455'
                WHERE ordernumber = 'P2411160027071' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430526'
                WHERE ordernumber = 'P2411160027155' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430527'
                WHERE ordernumber = 'P2411160027278' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430528'
                WHERE ordernumber = 'P2411160027397' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430529'
                WHERE ordernumber = 'P2411160027486' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397340'
                WHERE ordernumber = 'P2411160027560' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430531'
                WHERE ordernumber = 'P2411160027740' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300072'
                WHERE ordernumber = 'P2411160027871' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430535'
                WHERE ordernumber = 'P2411160027912' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290394'
                WHERE ordernumber = 'P2411160028057' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430535'
                WHERE ordernumber = 'P2411160028121' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430530'
                WHERE ordernumber = 'P2411160028256' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430536'
                WHERE ordernumber = 'P2411160028389' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430533'
                WHERE ordernumber = 'P2411160028479' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383852'
                WHERE ordernumber = 'P2411160028639' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430534'
                WHERE ordernumber = 'P2411160028724' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430537'
                WHERE ordernumber = 'P2411160029532' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430538'
                WHERE ordernumber = 'P2411160029975' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430539'
                WHERE ordernumber = 'P2411160030019' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306719'
                WHERE ordernumber = 'P2411160030161' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430540'
                WHERE ordernumber = 'P2411160030377' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430541'
                WHERE ordernumber = 'P2411160030720' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428946'
                WHERE ordernumber = 'P2411160030897' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402693'
                WHERE ordernumber = 'P2411160031088' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340376'
                WHERE ordernumber = 'P2411160031162' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400998'
                WHERE ordernumber = 'P2411160031462' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387109'
                WHERE ordernumber = 'P2411160031677' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430544'
                WHERE ordernumber = 'P2411160031843' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208634'
                WHERE ordernumber = 'P2411160031921' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430543'
                WHERE ordernumber = 'P2411160032029' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391920'
                WHERE ordernumber = 'P2411160032119' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256123'
                WHERE ordernumber = 'P2411160032266' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207305'
                WHERE ordernumber = 'P2411160032383' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103922'
                WHERE ordernumber = 'P2411160032443' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430545'
                WHERE ordernumber = 'P2411160032538' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310767'
                WHERE ordernumber = 'P2411160032627' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430546'
                WHERE ordernumber = 'P2411160032892' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430547'
                WHERE ordernumber = 'P2411160033073' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430546'
                WHERE ordernumber = 'P2411160033114' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430548'
                WHERE ordernumber = 'P2411160033390' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430549'
                WHERE ordernumber = 'P2411160033456' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430550'
                WHERE ordernumber = 'P2411160033776' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421189'
                WHERE ordernumber = 'P2411160034175' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221725'
                WHERE ordernumber = 'P2411160034287' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315708'
                WHERE ordernumber = 'P2411160034448' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248979'
                WHERE ordernumber = 'P2411160035198' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243656'
                WHERE ordernumber = 'P2411160035372' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430545'
                WHERE ordernumber = 'P2411160035461' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402737'
                WHERE ordernumber = 'P2411160035520' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249878'
                WHERE ordernumber = 'P2411160035672' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310767'
                WHERE ordernumber = 'P2411160035760' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430552'
                WHERE ordernumber = 'P2411160035834' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366385'
                WHERE ordernumber = 'P2411160035936' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426962'
                WHERE ordernumber = 'P2411160036133' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430553'
                WHERE ordernumber = 'P2411160036283' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294420'
                WHERE ordernumber = 'P2411160036443' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430554'
                WHERE ordernumber = 'P2411160036698' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357123'
                WHERE ordernumber = 'P2411160036755' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430555'
                WHERE ordernumber = 'P2411160036841' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274963'
                WHERE ordernumber = 'P2411160036988' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114309'
                WHERE ordernumber = 'P2411160037044' 
            
2024-11-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430560'
                WHERE ordernumber = 'P2411160037169' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394144'
                WHERE ordernumber = 'P2411160037259' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430557'
                WHERE ordernumber = 'P2411160037317' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328884'
                WHERE ordernumber = 'P2411160037624' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430561'
                WHERE ordernumber = 'P2411160037731' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430563'
                WHERE ordernumber = 'P2411160037880' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214528'
                WHERE ordernumber = 'P2411160037910' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430564'
                WHERE ordernumber = 'P2411160038012' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430566'
                WHERE ordernumber = 'P2411160038218' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430565'
                WHERE ordernumber = 'P2411160038351' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430565'
                WHERE ordernumber = 'P2411160038459' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430567'
                WHERE ordernumber = 'P2411160038575' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '427293'
                WHERE ordernumber = 'P2411160038622' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430568'
                WHERE ordernumber = 'P2411160038759' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430568'
                WHERE ordernumber = 'P2411160038823' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360966'
                WHERE ordernumber = 'P2411160039090' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241795'
                WHERE ordernumber = 'P2411160039124' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430569'
                WHERE ordernumber = 'P2411160039329' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403755'
                WHERE ordernumber = 'P2411160039795' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349135'
                WHERE ordernumber = 'P2411160039972' 
            
2024-11-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133686'
                WHERE ordernumber = 'P2411160040190'