2024-08-01 01:00:03 -- 將會員中心id寫入data-lake
2024-08-01 01:00:03 -- 
            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-07-31%';
        
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112684'
                WHERE ordernumber = 'P180731110124881' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200731110315579' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404228'
                WHERE ordernumber = 'P180731110356421' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404229'
                WHERE ordernumber = 'P180731110553374' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404230'
                WHERE ordernumber = 'P200731110730771' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320078'
                WHERE ordernumber = 'P200731111005694' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232073'
                WHERE ordernumber = 'P180731112657710' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304694'
                WHERE ordernumber = 'P420731112716362' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404232'
                WHERE ordernumber = 'P200731112838901' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392762'
                WHERE ordernumber = 'P180731112953534' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404233'
                WHERE ordernumber = 'P420731113437469' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404234'
                WHERE ordernumber = 'P200731113453205' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143048'
                WHERE ordernumber = 'P200731113716645' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404237'
                WHERE ordernumber = 'P190731113931624' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376305'
                WHERE ordernumber = 'P190731114250845' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385157'
                WHERE ordernumber = 'P630731114322509' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285272'
                WHERE ordernumber = 'P180731114427389' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255438'
                WHERE ordernumber = 'P190731115005553' 
            
2024-08-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404241'
                WHERE ordernumber = 'P200731115103428' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P180731115141703' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76659'
                WHERE ordernumber = 'P420731115156507' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345765'
                WHERE ordernumber = 'P190731115230129' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354937'
                WHERE ordernumber = 'P420731115504791' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404244'
                WHERE ordernumber = 'P180731115833785' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218531'
                WHERE ordernumber = 'P180731115955826' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404216'
                WHERE ordernumber = 'P200731120139143' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404251'
                WHERE ordernumber = 'P180731120625486' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404250'
                WHERE ordernumber = 'P420731120628436' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404256'
                WHERE ordernumber = 'P180731122046285' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342097'
                WHERE ordernumber = 'P180731122318629' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255588'
                WHERE ordernumber = 'P200731123030993' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308601'
                WHERE ordernumber = 'P200731123205222' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101535'
                WHERE ordernumber = 'P190731123538735' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404261'
                WHERE ordernumber = 'P180731123542372' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300124'
                WHERE ordernumber = 'P180731124108130' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137725'
                WHERE ordernumber = 'P200731124203945' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404262'
                WHERE ordernumber = 'P180731124251278' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404263'
                WHERE ordernumber = 'P420731124350541' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251244'
                WHERE ordernumber = 'P200731124413612' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348408'
                WHERE ordernumber = 'P200731124523486' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244834'
                WHERE ordernumber = 'P200731124637375' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402042'
                WHERE ordernumber = 'P420731125329335' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313514'
                WHERE ordernumber = 'P420731125440716' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404266'
                WHERE ordernumber = 'P180731125902909' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143159'
                WHERE ordernumber = 'P200731125944568' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404267'
                WHERE ordernumber = 'P200731130045807' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389205'
                WHERE ordernumber = 'P200731130213554' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404268'
                WHERE ordernumber = 'P180731130215425' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P200731130322880' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404266'
                WHERE ordernumber = 'P180731130326872' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136257'
                WHERE ordernumber = 'P420731130333359' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398291'
                WHERE ordernumber = 'P180731130501884' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248368'
                WHERE ordernumber = 'P200731130503356' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404271'
                WHERE ordernumber = 'P200731130544853' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348622'
                WHERE ordernumber = 'P180731130903671' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404272'
                WHERE ordernumber = 'P180731131034898' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304163'
                WHERE ordernumber = 'P200731131543521' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106009'
                WHERE ordernumber = 'P200731132036634' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404274'
                WHERE ordernumber = 'P180731132201111' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337886'
                WHERE ordernumber = 'P200731132253695' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130583'
                WHERE ordernumber = 'P180731132423171' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215024'
                WHERE ordernumber = 'P200731132530113' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388401'
                WHERE ordernumber = 'P420731132800961' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395383'
                WHERE ordernumber = 'P420731132923325' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404276'
                WHERE ordernumber = 'P420731133039699' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404277'
                WHERE ordernumber = 'P200731133117298' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305366'
                WHERE ordernumber = 'P190731133136921' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384928'
                WHERE ordernumber = 'P180731133158688' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P200731133339623' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P200731133503322' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399842'
                WHERE ordernumber = 'P420731133801866' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404279'
                WHERE ordernumber = 'P200731134026525' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344013'
                WHERE ordernumber = 'P420731134308173' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404281'
                WHERE ordernumber = 'P420731134443144' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250883'
                WHERE ordernumber = 'P200731134456926' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385609'
                WHERE ordernumber = 'P420731134535565' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328786'
                WHERE ordernumber = 'P180731134644700' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100063'
                WHERE ordernumber = 'P200731134655534' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402626'
                WHERE ordernumber = 'P180731134758920' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404282'
                WHERE ordernumber = 'P200731135123178' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224644'
                WHERE ordernumber = 'P200731135351909' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334506'
                WHERE ordernumber = 'P420731135852915' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404283'
                WHERE ordernumber = 'P200731135908517' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253361'
                WHERE ordernumber = 'P180731140137176' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222004'
                WHERE ordernumber = 'P200731140830608' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404191'
                WHERE ordernumber = 'P180731141236897' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114320'
                WHERE ordernumber = 'P180731141342267' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404285'
                WHERE ordernumber = 'P180731141609216' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359192'
                WHERE ordernumber = 'P200731141627708' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254038'
                WHERE ordernumber = 'P180731142849954' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404288'
                WHERE ordernumber = 'P200731143209232' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404287'
                WHERE ordernumber = 'P180731143311960' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396097'
                WHERE ordernumber = 'P190731143441903' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383203'
                WHERE ordernumber = 'P180731143550133' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404291'
                WHERE ordernumber = 'P200731143636567' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292428'
                WHERE ordernumber = 'P180731143655122' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404273'
                WHERE ordernumber = 'P200731144605610' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330295'
                WHERE ordernumber = 'P420731145430271' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392397'
                WHERE ordernumber = 'P420731150025426' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404299'
                WHERE ordernumber = 'P180731150300782' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251950'
                WHERE ordernumber = 'P200731150309306' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404300'
                WHERE ordernumber = 'P420731150429634' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318956'
                WHERE ordernumber = 'P420731150553807' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404301'
                WHERE ordernumber = 'P180731150746151' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404301'
                WHERE ordernumber = 'P180731150819670' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403284'
                WHERE ordernumber = 'P420731151150862' 
            
2024-08-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343808'
                WHERE ordernumber = 'P200731151621372' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404303'
                WHERE ordernumber = 'P180731151745179' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238480'
                WHERE ordernumber = 'P200731151852367' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420731151943138' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '67158'
                WHERE ordernumber = 'P180731152534439' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394714'
                WHERE ordernumber = 'P180731152621785' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404307'
                WHERE ordernumber = 'P420731152827730' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279697'
                WHERE ordernumber = 'P200731153059368' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404308'
                WHERE ordernumber = 'P200731153233325' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403603'
                WHERE ordernumber = 'P420731154252151' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404311'
                WHERE ordernumber = 'P420731154822323' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328209'
                WHERE ordernumber = 'P420731154910428' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404312'
                WHERE ordernumber = 'P180731154941281' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404313'
                WHERE ordernumber = 'P420731155202819' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403784'
                WHERE ordernumber = 'P180731155711884' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241208'
                WHERE ordernumber = 'P200731155835295' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401205'
                WHERE ordernumber = 'P180731160106741' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404315'
                WHERE ordernumber = 'P200731160152834' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380190'
                WHERE ordernumber = 'P180731160827259' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366886'
                WHERE ordernumber = 'P200731161139624' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P180731161434971' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404317'
                WHERE ordernumber = 'P180731161924434' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404318'
                WHERE ordernumber = 'P180731162513725' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404320'
                WHERE ordernumber = 'P180731162852656' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404321'
                WHERE ordernumber = 'P180731163122886' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '115668'
                WHERE ordernumber = 'P180731163236143' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404322'
                WHERE ordernumber = 'P420731163245307' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404323'
                WHERE ordernumber = 'P190731163554215' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404324'
                WHERE ordernumber = 'P420731163816647' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404326'
                WHERE ordernumber = 'P200731163944449' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388901'
                WHERE ordernumber = 'P420731164008582' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404327'
                WHERE ordernumber = 'P190731164809969' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404329'
                WHERE ordernumber = 'P180731165140256' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404330'
                WHERE ordernumber = 'P180731165425650' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404331'
                WHERE ordernumber = 'P190731165512413' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343537'
                WHERE ordernumber = 'P180731165707274' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404332'
                WHERE ordernumber = 'P190731170107907' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '143596'
                WHERE ordernumber = 'P200731170119851' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '156949'
                WHERE ordernumber = 'P180731170157813' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404334'
                WHERE ordernumber = 'P180731170841215' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404336'
                WHERE ordernumber = 'P180731171016671' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404337'
                WHERE ordernumber = 'P420731171224970' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '145854'
                WHERE ordernumber = 'P200731171256705' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118329'
                WHERE ordernumber = 'P180731171930909' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295092'
                WHERE ordernumber = 'P180731172008572' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400781'
                WHERE ordernumber = 'P180731172109913' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404339'
                WHERE ordernumber = 'P420731172505644' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404340'
                WHERE ordernumber = 'P180731172912181' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118329'
                WHERE ordernumber = 'P180731172945693' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398888'
                WHERE ordernumber = 'P420731173128465' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404342'
                WHERE ordernumber = 'P180731173316732' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398888'
                WHERE ordernumber = 'P420731173434644' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338270'
                WHERE ordernumber = 'P180731173525167' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364567'
                WHERE ordernumber = 'P190731174641180' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404346'
                WHERE ordernumber = 'P180731174844180' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404345'
                WHERE ordernumber = 'P420731174857430' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404348'
                WHERE ordernumber = 'P190731174915635' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116135'
                WHERE ordernumber = 'P420731175233208' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141900'
                WHERE ordernumber = 'P420731175701535' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86802'
                WHERE ordernumber = 'P180731175732137' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141900'
                WHERE ordernumber = 'P420731175814170' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248048'
                WHERE ordernumber = 'P180731175821470' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404350'
                WHERE ordernumber = 'P180731180106256' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404352'
                WHERE ordernumber = 'P180731180843745' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404353'
                WHERE ordernumber = 'P190731180947193' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118464'
                WHERE ordernumber = 'P180731181406665' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404354'
                WHERE ordernumber = 'P190731181434634' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118464'
                WHERE ordernumber = 'P180731181513265' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377388'
                WHERE ordernumber = 'P200731181803164' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159425'
                WHERE ordernumber = 'P200731182213147' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404357'
                WHERE ordernumber = 'P180731182348511' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400102'
                WHERE ordernumber = 'P190731182400860' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395761'
                WHERE ordernumber = 'P190731182424135' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404359'
                WHERE ordernumber = 'P180731182828486' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404360'
                WHERE ordernumber = 'P180731183239671' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214008'
                WHERE ordernumber = 'P200731183724422' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381739'
                WHERE ordernumber = 'P180731183811290' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302567'
                WHERE ordernumber = 'P180731184120647' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404361'
                WHERE ordernumber = 'P180731184339962' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404364'
                WHERE ordernumber = 'P190731185133549' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404365'
                WHERE ordernumber = 'P190731185434355' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404366'
                WHERE ordernumber = 'P190731185618862' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404367'
                WHERE ordernumber = 'P190731185758502' 
            
2024-08-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334128'
                WHERE ordernumber = 'P190731185844990' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P200731185904371' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '382471'
                WHERE ordernumber = 'P190731190101669' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '388483'
                WHERE ordernumber = 'P420731190520505' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404369'
                WHERE ordernumber = 'P190731190536697' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200731191605612' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '360376'
                WHERE ordernumber = 'P190731191753456' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '162115'
                WHERE ordernumber = 'P190731191917525' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '176708'
                WHERE ordernumber = 'P200731192543124' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404370'
                WHERE ordernumber = 'P190731193117525' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404373'
                WHERE ordernumber = 'P190731193243945' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '280077'
                WHERE ordernumber = 'P190731193455873' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404375'
                WHERE ordernumber = 'P190731193659725' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400666'
                WHERE ordernumber = 'P190731193830456' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400666'
                WHERE ordernumber = 'P190731193909718' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352298'
                WHERE ordernumber = 'P190731193957508' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '104530'
                WHERE ordernumber = 'P200731194603427' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '329353'
                WHERE ordernumber = 'P190731194609883' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404377'
                WHERE ordernumber = 'P190731194744916' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '101668'
                WHERE ordernumber = 'P630731203316626' 
            
2024-08-01 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '337768'
                WHERE ordernumber = 'P630731203649435'