2024-10-13 01:00:02 -- 將會員中心id寫入data-lake
2024-10-13 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-12%';
        
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425449'
                WHERE ordernumber = 'P631012101402887' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391942'
                WHERE ordernumber = 'P181012110246885' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421065'
                WHERE ordernumber = 'P181012110808789' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421065'
                WHERE ordernumber = 'P181012110911253' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425451'
                WHERE ordernumber = 'P181012111047410' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425452'
                WHERE ordernumber = 'P731012111101112' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425451'
                WHERE ordernumber = 'P181012111153530' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425453'
                WHERE ordernumber = 'P421012111232453' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425455'
                WHERE ordernumber = 'P181012111603738' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425456'
                WHERE ordernumber = 'P191012111629141' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425458'
                WHERE ordernumber = 'P731012111816472' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425463'
                WHERE ordernumber = 'P421012111833335' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425460'
                WHERE ordernumber = 'P191012111937590' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425457'
                WHERE ordernumber = 'P181012111951217' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425460'
                WHERE ordernumber = 'P191012112008835' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102047'
                WHERE ordernumber = 'P201012112114770' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425454'
                WHERE ordernumber = 'P191012112444255' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425465'
                WHERE ordernumber = 'P421012112631350' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425466'
                WHERE ordernumber = 'P421012112907349' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425464'
                WHERE ordernumber = 'P181012113112646' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252810'
                WHERE ordernumber = 'P201012113247924' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382280'
                WHERE ordernumber = 'P421012113324631' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425464'
                WHERE ordernumber = 'P181012113823697' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311719'
                WHERE ordernumber = 'P201012113948939' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425467'
                WHERE ordernumber = 'P731012114027225' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116809'
                WHERE ordernumber = 'P181012114204811' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424034'
                WHERE ordernumber = 'P711012114315427' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275437'
                WHERE ordernumber = 'P201012114339922' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425470'
                WHERE ordernumber = 'P421012114510265' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425473'
                WHERE ordernumber = 'P711012114650823' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425469'
                WHERE ordernumber = 'P181012114936578' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425474'
                WHERE ordernumber = 'P421012114945773' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425468'
                WHERE ordernumber = 'P181012115235832' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425476'
                WHERE ordernumber = 'P201012115455351' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127187'
                WHERE ordernumber = 'P201012115609118' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425477'
                WHERE ordernumber = 'P181012115647620' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291658'
                WHERE ordernumber = 'P181012115956760' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417284'
                WHERE ordernumber = 'P711012120154738' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425479'
                WHERE ordernumber = 'P711012120334291' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425475'
                WHERE ordernumber = 'P181012120654333' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425481'
                WHERE ordernumber = 'P201012120732954' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313212'
                WHERE ordernumber = 'P181012120753945' 
            
2024-10-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81406'
                WHERE ordernumber = 'P201012120836968' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425482'
                WHERE ordernumber = 'P201012121056942' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425480'
                WHERE ordernumber = 'P181012121228183' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '36124'
                WHERE ordernumber = 'P201012121320332' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425483'
                WHERE ordernumber = 'P421012121400948' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365771'
                WHERE ordernumber = 'P181012121733974' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418607'
                WHERE ordernumber = 'P181012122158159' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425484'
                WHERE ordernumber = 'P201012122218116' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365174'
                WHERE ordernumber = 'P201012122503945' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425486'
                WHERE ordernumber = 'P421012122551483' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425487'
                WHERE ordernumber = 'P181012122815878' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425488'
                WHERE ordernumber = 'P201012122821640' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129690'
                WHERE ordernumber = 'P191012122957272' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334303'
                WHERE ordernumber = 'P201012123825194' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425489'
                WHERE ordernumber = 'P181012123836298' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425490'
                WHERE ordernumber = 'P181012124507651' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273500'
                WHERE ordernumber = 'P201012124627751' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392627'
                WHERE ordernumber = 'P181012124636337' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309221'
                WHERE ordernumber = 'P201012124931740' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284599'
                WHERE ordernumber = 'P201012124955747' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93445'
                WHERE ordernumber = 'P201012125211196' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381914'
                WHERE ordernumber = 'P421012125247530' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425491'
                WHERE ordernumber = 'P421012125326970' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425492'
                WHERE ordernumber = 'P181012125700496' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425493'
                WHERE ordernumber = 'P201012130055865' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425494'
                WHERE ordernumber = 'P711012130237262' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425495'
                WHERE ordernumber = 'P201012130443166' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405523'
                WHERE ordernumber = 'P201012130705139' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425492'
                WHERE ordernumber = 'P181012131236286' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425497'
                WHERE ordernumber = 'P631012131300740' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425496'
                WHERE ordernumber = 'P731012131332695' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425500'
                WHERE ordernumber = 'P201012131544479' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425503'
                WHERE ordernumber = 'P181012131854185' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425499'
                WHERE ordernumber = 'P421012131930356' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425501'
                WHERE ordernumber = 'P421012132015156' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425502'
                WHERE ordernumber = 'P421012132052427' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425504'
                WHERE ordernumber = 'P201012132128737' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153983'
                WHERE ordernumber = 'P181012132212382' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425506'
                WHERE ordernumber = 'P181012132334754' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425505'
                WHERE ordernumber = 'P201012132349572' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425500'
                WHERE ordernumber = 'P201012132420951' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279160'
                WHERE ordernumber = 'P181012133028646' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281382'
                WHERE ordernumber = 'P181012133933955' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321276'
                WHERE ordernumber = 'P181012134013931' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336480'
                WHERE ordernumber = 'P421012134112974' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331358'
                WHERE ordernumber = 'P191012134244232' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405826'
                WHERE ordernumber = 'P181012134250724' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425507'
                WHERE ordernumber = 'P421012134620178' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425508'
                WHERE ordernumber = 'P731012134744218' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379174'
                WHERE ordernumber = 'P201012134823391' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425509'
                WHERE ordernumber = 'P191012134824491' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P191012134940201' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425510'
                WHERE ordernumber = 'P731012135153492' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255397'
                WHERE ordernumber = 'P201012135418907' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339198'
                WHERE ordernumber = 'P421012135609461' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421976'
                WHERE ordernumber = 'P191012135659199' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339198'
                WHERE ordernumber = 'P421012135713446' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339198'
                WHERE ordernumber = 'P421012135759339' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '36264'
                WHERE ordernumber = 'P421012135856743' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425512'
                WHERE ordernumber = 'P181012140013923' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423707'
                WHERE ordernumber = 'P631012140429720' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425513'
                WHERE ordernumber = 'P711012141105244' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250269'
                WHERE ordernumber = 'P181012141533533' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425516'
                WHERE ordernumber = 'P421012141542274' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '59203'
                WHERE ordernumber = 'P421012141718877' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425514'
                WHERE ordernumber = 'P181012141923138' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425518'
                WHERE ordernumber = 'P181012142052980' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336162'
                WHERE ordernumber = 'P421012142709344' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425517'
                WHERE ordernumber = 'P181012142736696' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425522'
                WHERE ordernumber = 'P201012143000871' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425521'
                WHERE ordernumber = 'P711012143051995' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425520'
                WHERE ordernumber = 'P181012143126481' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425519'
                WHERE ordernumber = 'P181012143428745' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287701'
                WHERE ordernumber = 'P201012143620935' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425515'
                WHERE ordernumber = 'P711012143700464' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425524'
                WHERE ordernumber = 'P181012143722381' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425523'
                WHERE ordernumber = 'P181012143941250' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425525'
                WHERE ordernumber = 'P181012144147318' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425526'
                WHERE ordernumber = 'P181012144449534' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425531'
                WHERE ordernumber = 'P201012144850750' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425530'
                WHERE ordernumber = 'P421012144858802' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425529'
                WHERE ordernumber = 'P181012144947835' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393447'
                WHERE ordernumber = 'P421012145042266' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378553'
                WHERE ordernumber = 'P731012145130618' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P181012145237717' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323016'
                WHERE ordernumber = 'P421012145245411' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425527'
                WHERE ordernumber = 'P191012145425811' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425533'
                WHERE ordernumber = 'P181012145521944' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425534'
                WHERE ordernumber = 'P421012145641468' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425532'
                WHERE ordernumber = 'P191012145703316' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425535'
                WHERE ordernumber = 'P191012145806360' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135323'
                WHERE ordernumber = 'P201012145855525' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135323'
                WHERE ordernumber = 'P201012150130927' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421153'
                WHERE ordernumber = 'P421012150345748' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425537'
                WHERE ordernumber = 'P191012150437736' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225567'
                WHERE ordernumber = 'P181012150731122' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425538'
                WHERE ordernumber = 'P421012150754557' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302951'
                WHERE ordernumber = 'P181012151010427' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425539'
                WHERE ordernumber = 'P421012151018765' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76364'
                WHERE ordernumber = 'P731012151032999' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425245'
                WHERE ordernumber = 'P201012151154768' 
            
2024-10-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316188'
                WHERE ordernumber = 'P421012151317330' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282236'
                WHERE ordernumber = 'P201012151418249' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425540'
                WHERE ordernumber = 'P181012151428922' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '75630'
                WHERE ordernumber = 'P201012151531664' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425541'
                WHERE ordernumber = 'P181012151642981' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425542'
                WHERE ordernumber = 'P201012151731387' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425543'
                WHERE ordernumber = 'P421012151838187' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425544'
                WHERE ordernumber = 'P421012152155395' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425545'
                WHERE ordernumber = 'P181012152514149' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425548'
                WHERE ordernumber = 'P421012152723644' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321373'
                WHERE ordernumber = 'P181012152813334' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425549'
                WHERE ordernumber = 'P191012153139437' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425546'
                WHERE ordernumber = 'P181012153221789' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377911'
                WHERE ordernumber = 'P191012153333119' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425551'
                WHERE ordernumber = 'P181012153538135' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425552'
                WHERE ordernumber = 'P181012153812309' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425552'
                WHERE ordernumber = 'P181012153929261' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384507'
                WHERE ordernumber = 'P191012154114923' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313941'
                WHERE ordernumber = 'P181012154224232' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425556'
                WHERE ordernumber = 'P731012154518335' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425553'
                WHERE ordernumber = 'P191012154618375' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346416'
                WHERE ordernumber = 'P711012154650368' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425555'
                WHERE ordernumber = 'P181012154658123' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425557'
                WHERE ordernumber = 'P191012154856590' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425554'
                WHERE ordernumber = 'P181012154939570' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144573'
                WHERE ordernumber = 'P201012155121872' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382431'
                WHERE ordernumber = 'P181012155432444' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425558'
                WHERE ordernumber = 'P421012155505416' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304510'
                WHERE ordernumber = 'P181012155717558' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304835'
                WHERE ordernumber = 'P191012155731717' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425559'
                WHERE ordernumber = 'P201012155732657' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425560'
                WHERE ordernumber = 'P421012160103796' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425562'
                WHERE ordernumber = 'P731012161022140' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383777'
                WHERE ordernumber = 'P181012161143914' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402453'
                WHERE ordernumber = 'P201012161411963' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425565'
                WHERE ordernumber = 'P201012161613995' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425563'
                WHERE ordernumber = 'P191012161807457' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425567'
                WHERE ordernumber = 'P731012161943331' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214864'
                WHERE ordernumber = 'P181012162046132' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425566'
                WHERE ordernumber = 'P421012162106251' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425564'
                WHERE ordernumber = 'P191012162259207' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425568'
                WHERE ordernumber = 'P421012162320442' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425570'
                WHERE ordernumber = 'P201012162729609' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425569'
                WHERE ordernumber = 'P191012162854534' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425572'
                WHERE ordernumber = 'P181012163003831' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377580'
                WHERE ordernumber = 'P421012163008247' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181012163048599' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425571'
                WHERE ordernumber = 'P191012163130113' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292914'
                WHERE ordernumber = 'P201012163244853' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425575'
                WHERE ordernumber = 'P421012163254728' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425574'
                WHERE ordernumber = 'P421012163537206' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423293'
                WHERE ordernumber = 'P421012163610493' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248536'
                WHERE ordernumber = 'P191012163823216' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425573'
                WHERE ordernumber = 'P181012164026564' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353350'
                WHERE ordernumber = 'P201012164253263' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87789'
                WHERE ordernumber = 'P181012164414531' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425576'
                WHERE ordernumber = 'P191012164459359' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425580'
                WHERE ordernumber = 'P181012164619402' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P201012164802146' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419353'
                WHERE ordernumber = 'P181012164911759' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140498'
                WHERE ordernumber = 'P191012165000665' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214887'
                WHERE ordernumber = 'P181012165140599' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287880'
                WHERE ordernumber = 'P191012165227497' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425579'
                WHERE ordernumber = 'P181012165257291' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425585'
                WHERE ordernumber = 'P421012165431762' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330826'
                WHERE ordernumber = 'P421012165547746' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P191012165556227' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339788'
                WHERE ordernumber = 'P201012165651112' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425586'
                WHERE ordernumber = 'P421012165804819' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423653'
                WHERE ordernumber = 'P181012165806985' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425582'
                WHERE ordernumber = 'P191012165908384' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425587'
                WHERE ordernumber = 'P731012170011943' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425589'
                WHERE ordernumber = 'P731012170133328' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424251'
                WHERE ordernumber = 'P201012170215994' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425584'
                WHERE ordernumber = 'P191012170241454' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425588'
                WHERE ordernumber = 'P181012170542507' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425588'
                WHERE ordernumber = 'P181012170624194' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283681'
                WHERE ordernumber = 'P181012170809416' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425590'
                WHERE ordernumber = 'P201012170852319' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425591'
                WHERE ordernumber = 'P711012170944258' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P191012171029519' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425592'
                WHERE ordernumber = 'P711012171423368' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423653'
                WHERE ordernumber = 'P181012171504883' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312231'
                WHERE ordernumber = 'P191012171620376' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425593'
                WHERE ordernumber = 'P421012171727199' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297772'
                WHERE ordernumber = 'P181012172216532' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237179'
                WHERE ordernumber = 'P201012172253705' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228760'
                WHERE ordernumber = 'P191012172648853' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291217'
                WHERE ordernumber = 'P191012172902998' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425484'
                WHERE ordernumber = 'P201012172917180' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404129'
                WHERE ordernumber = 'P731012173120154' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139381'
                WHERE ordernumber = 'P201012173419587' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380741'
                WHERE ordernumber = 'P191012173445811' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425596'
                WHERE ordernumber = 'P201012173556726' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256017'
                WHERE ordernumber = 'P191012173606138' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425595'
                WHERE ordernumber = 'P181012174416782' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278884'
                WHERE ordernumber = 'P631012174514525' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425597'
                WHERE ordernumber = 'P421012174533997' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425597'
                WHERE ordernumber = 'P421012174658142' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425601'
                WHERE ordernumber = 'P201012174726627' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425599'
                WHERE ordernumber = 'P421012174746805' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425600'
                WHERE ordernumber = 'P421012174832767' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425598'
                WHERE ordernumber = 'P191012175003381' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425603'
                WHERE ordernumber = 'P421012175647278' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425604'
                WHERE ordernumber = 'P421012175754493' 
            
2024-10-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425605'
                WHERE ordernumber = 'P421012175851963' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425606'
                WHERE ordernumber = 'P191012180233998' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421202'
                WHERE ordernumber = 'P201012180509944' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425607'
                WHERE ordernumber = 'P421012180901808' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425566'
                WHERE ordernumber = 'P421012181031281' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401905'
                WHERE ordernumber = 'P421012181157139' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425608'
                WHERE ordernumber = 'P731012181342113' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P191012181515449' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425611'
                WHERE ordernumber = 'P421012181820336' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424050'
                WHERE ordernumber = 'P421012181902710' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402227'
                WHERE ordernumber = 'P181012181906557' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425613'
                WHERE ordernumber = 'P201012181932641' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425609'
                WHERE ordernumber = 'P181012182029948' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425612'
                WHERE ordernumber = 'P731012182036196' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425610'
                WHERE ordernumber = 'P191012182200349' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425614'
                WHERE ordernumber = 'P181012182503925' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93654'
                WHERE ordernumber = 'P201012183014327' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425617'
                WHERE ordernumber = 'P421012183347577' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425621'
                WHERE ordernumber = 'P191012183520927' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425616'
                WHERE ordernumber = 'P181012183536127' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425618'
                WHERE ordernumber = 'P421012183545807' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '7906'
                WHERE ordernumber = 'P201012183632553' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425619'
                WHERE ordernumber = 'P181012184036428' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424926'
                WHERE ordernumber = 'P631012184146202' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425616'
                WHERE ordernumber = 'P181012184159166' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425620'
                WHERE ordernumber = 'P191012184420944' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390062'
                WHERE ordernumber = 'P201012184638871' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425624'
                WHERE ordernumber = 'P421012185013429' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131323'
                WHERE ordernumber = 'P191012185114678' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266342'
                WHERE ordernumber = 'P191012185618610' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '201702'
                WHERE ordernumber = 'P421012190033509' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425625'
                WHERE ordernumber = 'P191012190421903' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425627'
                WHERE ordernumber = 'P201012190922469' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425626'
                WHERE ordernumber = 'P711012191017666' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425629'
                WHERE ordernumber = 'P711012191511947' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425630'
                WHERE ordernumber = 'P731012191556725' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425631'
                WHERE ordernumber = 'P201012194833327' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417940'
                WHERE ordernumber = 'P191012195230523' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345365'
                WHERE ordernumber = 'P201012195449212' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382865'
                WHERE ordernumber = 'P631012201728179' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425634'
                WHERE ordernumber = 'P711012203404323' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425635'
                WHERE ordernumber = 'P711012204638272' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372322'
                WHERE ordernumber = 'P711012205425138' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425637'
                WHERE ordernumber = 'P711012205942263' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425636'
                WHERE ordernumber = 'P731012210625849' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425639'
                WHERE ordernumber = 'P731012211821310' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425642'
                WHERE ordernumber = 'P731012214645851' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425643'
                WHERE ordernumber = 'P731012220938645' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425644'
                WHERE ordernumber = 'P731012222200891' 
            
2024-10-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130397'
                WHERE ordernumber = 'P711012222313724'