2024-03-20 01:00:02 -- 將會員中心id寫入data-lake
2024-03-20 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-03-19%';
        
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221028'
                WHERE ordernumber = 'P200319110158950' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P190319110310852' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312940'
                WHERE ordernumber = 'P190319110429843' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232296'
                WHERE ordernumber = 'P200319111103447' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101613'
                WHERE ordernumber = 'P180319111411208' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374173'
                WHERE ordernumber = 'P200319111554676' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242036'
                WHERE ordernumber = 'P180319112543674' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382176'
                WHERE ordernumber = 'P420319112724804' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356522'
                WHERE ordernumber = 'P200319112915231' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382178'
                WHERE ordernumber = 'P180319113003953' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374930'
                WHERE ordernumber = 'P180319113248152' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346065'
                WHERE ordernumber = 'P200319113527644' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382179'
                WHERE ordernumber = 'P180319113703796' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373861'
                WHERE ordernumber = 'P200319113816203' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162670'
                WHERE ordernumber = 'P420319114134139' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382181'
                WHERE ordernumber = 'P420319114427391' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380517'
                WHERE ordernumber = 'P590319114730686' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112335'
                WHERE ordernumber = 'P180319114850781' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382182'
                WHERE ordernumber = 'P420319115116334' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382184'
                WHERE ordernumber = 'P590319115649242' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382185'
                WHERE ordernumber = 'P200319115733986' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382186'
                WHERE ordernumber = 'P420319115919825' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382187'
                WHERE ordernumber = 'P420319120929267' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342844'
                WHERE ordernumber = 'P420319121137302' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312643'
                WHERE ordernumber = 'P420319121626525' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382188'
                WHERE ordernumber = 'P420319122859904' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378092'
                WHERE ordernumber = 'P180319123242496' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277935'
                WHERE ordernumber = 'P420319123917199' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316701'
                WHERE ordernumber = 'P420319124202369' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364588'
                WHERE ordernumber = 'P190319124416951' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382189'
                WHERE ordernumber = 'P420319124457915' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249257'
                WHERE ordernumber = 'P200319130855567' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97842'
                WHERE ordernumber = 'P180319131023935' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278425'
                WHERE ordernumber = 'P180319131213353' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372893'
                WHERE ordernumber = 'P420319131430959' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382192'
                WHERE ordernumber = 'P420319131628452' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379460'
                WHERE ordernumber = 'P200319131949367' 
            
2024-03-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382193'
                WHERE ordernumber = 'P180319132103766' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382194'
                WHERE ordernumber = 'P200319132116392' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382195'
                WHERE ordernumber = 'P200319132214543' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380226'
                WHERE ordernumber = 'P180319132350756' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289954'
                WHERE ordernumber = 'P180319132816125' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148128'
                WHERE ordernumber = 'P200319133109927' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280432'
                WHERE ordernumber = 'P420319134131633' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382197'
                WHERE ordernumber = 'P420319134318708' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382198'
                WHERE ordernumber = 'P180319135011381' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382201'
                WHERE ordernumber = 'P200319140305427' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382202'
                WHERE ordernumber = 'P420319140352483' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378210'
                WHERE ordernumber = 'P200319140748402' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381410'
                WHERE ordernumber = 'P200319140900499' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382204'
                WHERE ordernumber = 'P180319141610584' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236671'
                WHERE ordernumber = 'P180319141745270' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382205'
                WHERE ordernumber = 'P180319142110198' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344135'
                WHERE ordernumber = 'P200319142420719' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382206'
                WHERE ordernumber = 'P200319143059660' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360735'
                WHERE ordernumber = 'P180319143156931' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344736'
                WHERE ordernumber = 'P200319143239185' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382207'
                WHERE ordernumber = 'P190319143820632' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378402'
                WHERE ordernumber = 'P180319145432160' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382208'
                WHERE ordernumber = 'P200319145727610' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287625'
                WHERE ordernumber = 'P190319145919340' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382210'
                WHERE ordernumber = 'P200319151445645' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364112'
                WHERE ordernumber = 'P200319151521640' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382210'
                WHERE ordernumber = 'P200319151538443' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320727'
                WHERE ordernumber = 'P420319151551215' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131857'
                WHERE ordernumber = 'P180319151551726' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382213'
                WHERE ordernumber = 'P420319151835611' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382214'
                WHERE ordernumber = 'P180319152113781' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382214'
                WHERE ordernumber = 'P180319152238189' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228197'
                WHERE ordernumber = 'P180319152600336' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110069'
                WHERE ordernumber = 'P420319152854800' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220614'
                WHERE ordernumber = 'P200319154358705' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382216'
                WHERE ordernumber = 'P180319154528285' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382217'
                WHERE ordernumber = 'P190319155531359' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250391'
                WHERE ordernumber = 'P180319155554565' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382218'
                WHERE ordernumber = 'P190319155643368' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367988'
                WHERE ordernumber = 'P200319155721812' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353308'
                WHERE ordernumber = 'P590319160231436' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274506'
                WHERE ordernumber = 'P200319160754295' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312031'
                WHERE ordernumber = 'P420319161432876' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299720'
                WHERE ordernumber = 'P180319162518508' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273422'
                WHERE ordernumber = 'P180319162906187' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278151'
                WHERE ordernumber = 'P200319162907949' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286749'
                WHERE ordernumber = 'P420319162944587' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294224'
                WHERE ordernumber = 'P200319162946596' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P190319163112809' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382220'
                WHERE ordernumber = 'P200319164513326' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138349'
                WHERE ordernumber = 'P200319170625797' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382224'
                WHERE ordernumber = 'P180319171028860' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382225'
                WHERE ordernumber = 'P180319171421354' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382227'
                WHERE ordernumber = 'P420319172348649' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382230'
                WHERE ordernumber = 'P420319172717220' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340529'
                WHERE ordernumber = 'P200319172944694' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382231'
                WHERE ordernumber = 'P420319173031300' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276110'
                WHERE ordernumber = 'P200319173449577' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249849'
                WHERE ordernumber = 'P200319174240636' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296619'
                WHERE ordernumber = 'P200319174533306' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283811'
                WHERE ordernumber = 'P180319175747577' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349942'
                WHERE ordernumber = 'P420319180003942' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334527'
                WHERE ordernumber = 'P420319180352406' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380254'
                WHERE ordernumber = 'P180319180425613' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294552'
                WHERE ordernumber = 'P200319180929856' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382233'
                WHERE ordernumber = 'P200319181221835' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '61566'
                WHERE ordernumber = 'P180319181531909' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299652'
                WHERE ordernumber = 'P420319181850930' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355782'
                WHERE ordernumber = 'P200319181953611' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359375'
                WHERE ordernumber = 'P180319182251288' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382237'
                WHERE ordernumber = 'P200319182440996' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382238'
                WHERE ordernumber = 'P180319182619766' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277088'
                WHERE ordernumber = 'P180319183101406' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343928'
                WHERE ordernumber = 'P200319183304397' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374706'
                WHERE ordernumber = 'P180319183454292' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376017'
                WHERE ordernumber = 'P420319183902854' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129784'
                WHERE ordernumber = 'P180319184003283' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284597'
                WHERE ordernumber = 'P200319184751193' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140723'
                WHERE ordernumber = 'P180319184845248' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126043'
                WHERE ordernumber = 'P200319184913535' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232251'
                WHERE ordernumber = 'P180319184948519' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284523'
                WHERE ordernumber = 'P190319185043281' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377081'
                WHERE ordernumber = 'P200319185059595' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345622'
                WHERE ordernumber = 'P200319185143252' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331547'
                WHERE ordernumber = 'P200319185304710' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82535'
                WHERE ordernumber = 'P190319185320961' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163091'
                WHERE ordernumber = 'P200319185530363' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97482'
                WHERE ordernumber = 'P200319185705846' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283374'
                WHERE ordernumber = 'P190319190056248' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283374'
                WHERE ordernumber = 'P190319190133908' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382239'
                WHERE ordernumber = 'P590319190428878' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380301'
                WHERE ordernumber = 'P200319190654448' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382242'
                WHERE ordernumber = 'P200319191809797' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105183'
                WHERE ordernumber = 'P200319191916331' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105183'
                WHERE ordernumber = 'P200319192204905' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239819'
                WHERE ordernumber = 'P190319193117155' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382245'
                WHERE ordernumber = 'P200319194314689' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214355'
                WHERE ordernumber = 'P200319195410315' 
            
2024-03-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382247'
                WHERE ordernumber = 'P590319202037343'