2024-07-23 01:00:03 -- 將會員中心id寫入data-lake
2024-07-23 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-22%';
        
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242519'
                WHERE ordernumber = 'P200722110255674' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330144'
                WHERE ordernumber = 'P190722110624733' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211077'
                WHERE ordernumber = 'P180722110733950' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348622'
                WHERE ordernumber = 'P190722110737230' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402506'
                WHERE ordernumber = 'P180722111439557' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402507'
                WHERE ordernumber = 'P190722111601860' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402509'
                WHERE ordernumber = 'P180722111709763' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402511'
                WHERE ordernumber = 'P190722111741684' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314089'
                WHERE ordernumber = 'P420722112033130' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313331'
                WHERE ordernumber = 'P180722112306964' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97842'
                WHERE ordernumber = 'P180722112605317' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288667'
                WHERE ordernumber = 'P200722112802382' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402313'
                WHERE ordernumber = 'P190722112841291' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222004'
                WHERE ordernumber = 'P200722113346283' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402515'
                WHERE ordernumber = 'P190722113953412' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133830'
                WHERE ordernumber = 'P190722114149580' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402518'
                WHERE ordernumber = 'P420722114301898' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312010'
                WHERE ordernumber = 'P190722114540301' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377419'
                WHERE ordernumber = 'P190722114644325' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223893'
                WHERE ordernumber = 'P190722114734875' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133368'
                WHERE ordernumber = 'P630722115248487' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402521'
                WHERE ordernumber = 'P200722120834261' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402522'
                WHERE ordernumber = 'P180722121120695' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216025'
                WHERE ordernumber = 'P180722121637654' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356795'
                WHERE ordernumber = 'P630722121739921' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P420722121821457' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356795'
                WHERE ordernumber = 'P630722121931843' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402523'
                WHERE ordernumber = 'P180722122128271' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310126'
                WHERE ordernumber = 'P180722122357158' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103462'
                WHERE ordernumber = 'P200722123128415' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402525'
                WHERE ordernumber = 'P200722123239999' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133270'
                WHERE ordernumber = 'P590722123845478' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402528'
                WHERE ordernumber = 'P420722124513289' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402529'
                WHERE ordernumber = 'P180722124630597' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402531'
                WHERE ordernumber = 'P200722125920932' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357924'
                WHERE ordernumber = 'P200722130158414' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402532'
                WHERE ordernumber = 'P200722130515751' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402534'
                WHERE ordernumber = 'P180722131545849' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254022'
                WHERE ordernumber = 'P180722133852619' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342637'
                WHERE ordernumber = 'P420722134148302' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120228'
                WHERE ordernumber = 'P590722134152300' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402311'
                WHERE ordernumber = 'P420722134836320' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254022'
                WHERE ordernumber = 'P180722140209561' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297429'
                WHERE ordernumber = 'P420722140343792' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402543'
                WHERE ordernumber = 'P420722140706399' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254022'
                WHERE ordernumber = 'P180722140729278' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402544'
                WHERE ordernumber = 'P420722141311349' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384979'
                WHERE ordernumber = 'P200722141548196' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402545'
                WHERE ordernumber = 'P420722141819381' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402547'
                WHERE ordernumber = 'P180722142330597' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295092'
                WHERE ordernumber = 'P180722142456201' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402549'
                WHERE ordernumber = 'P420722142506614' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258017'
                WHERE ordernumber = 'P180722142724721' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387808'
                WHERE ordernumber = 'P420722142910843' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386982'
                WHERE ordernumber = 'P420722142949398' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369819'
                WHERE ordernumber = 'P190722143711238' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '70205'
                WHERE ordernumber = 'P180722143807131' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402551'
                WHERE ordernumber = 'P420722143954930' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99520'
                WHERE ordernumber = 'P180722144214934' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402552'
                WHERE ordernumber = 'P420722144740287' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P180722145108159' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390816'
                WHERE ordernumber = 'P200722145155863' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402555'
                WHERE ordernumber = 'P180722145359197' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402556'
                WHERE ordernumber = 'P200722145402943' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402044'
                WHERE ordernumber = 'P180722150418361' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402557'
                WHERE ordernumber = 'P420722150535368' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180722150626743' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402558'
                WHERE ordernumber = 'P200722150859351' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P590722151005288' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402559'
                WHERE ordernumber = 'P180722151520762' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401818'
                WHERE ordernumber = 'P180722152202322' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402561'
                WHERE ordernumber = 'P200722152441285' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402563'
                WHERE ordernumber = 'P180722153137271' 
            
2024-07-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281172'
                WHERE ordernumber = 'P200722153306977' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402564'
                WHERE ordernumber = 'P180722153430474' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '69563'
                WHERE ordernumber = 'P200722153432303' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '115040'
                WHERE ordernumber = 'P180722153737572' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402566'
                WHERE ordernumber = 'P200722153758494' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402567'
                WHERE ordernumber = 'P180722154013463' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402568'
                WHERE ordernumber = 'P180722154124350' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282596'
                WHERE ordernumber = 'P190722154128842' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282596'
                WHERE ordernumber = 'P190722154211825' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402570'
                WHERE ordernumber = 'P200722154631837' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402571'
                WHERE ordernumber = 'P180722154911806' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401592'
                WHERE ordernumber = 'P200722154959426' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402572'
                WHERE ordernumber = 'P180722155147780' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402574'
                WHERE ordernumber = 'P420722155414490' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402575'
                WHERE ordernumber = 'P180722155652404' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402576'
                WHERE ordernumber = 'P200722155801614' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402060'
                WHERE ordernumber = 'P190722160056412' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402579'
                WHERE ordernumber = 'P180722160259843' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402578'
                WHERE ordernumber = 'P200722160314341' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395515'
                WHERE ordernumber = 'P180722160451404' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402580'
                WHERE ordernumber = 'P420722160542222' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402581'
                WHERE ordernumber = 'P180722161213317' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401740'
                WHERE ordernumber = 'P200722161330177' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402582'
                WHERE ordernumber = 'P180722161409424' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226007'
                WHERE ordernumber = 'P200722161509544' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113702'
                WHERE ordernumber = 'P180722161510937' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254168'
                WHERE ordernumber = 'P180722162404408' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402584'
                WHERE ordernumber = 'P420722162829184' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99692'
                WHERE ordernumber = 'P200722162911700' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402587'
                WHERE ordernumber = 'P420722163219441' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '168576'
                WHERE ordernumber = 'P200722163353404' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402587'
                WHERE ordernumber = 'P420722163357506' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402589'
                WHERE ordernumber = 'P180722163653842' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402592'
                WHERE ordernumber = 'P180722164523632' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402579'
                WHERE ordernumber = 'P190722165152794' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380535'
                WHERE ordernumber = 'P420722165255647' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402595'
                WHERE ordernumber = 'P180722165341971' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398262'
                WHERE ordernumber = 'P190722165621266' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402596'
                WHERE ordernumber = 'P420722165649649' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402597'
                WHERE ordernumber = 'P420722170214697' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402598'
                WHERE ordernumber = 'P180722170804472' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402599'
                WHERE ordernumber = 'P190722170852242' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402600'
                WHERE ordernumber = 'P420722170935718' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130987'
                WHERE ordernumber = 'P180722171042746' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222005'
                WHERE ordernumber = 'P190722171103773' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130987'
                WHERE ordernumber = 'P180722171138194' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130987'
                WHERE ordernumber = 'P180722171235647' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317820'
                WHERE ordernumber = 'P200722172112693' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340933'
                WHERE ordernumber = 'P420722172135114' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402601'
                WHERE ordernumber = 'P420722172938796' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '89263'
                WHERE ordernumber = 'P200722172954889' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100719'
                WHERE ordernumber = 'P420722173404938' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397997'
                WHERE ordernumber = 'P180722173716271' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397997'
                WHERE ordernumber = 'P180722174138817' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402605'
                WHERE ordernumber = 'P420722174741811' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402606'
                WHERE ordernumber = 'P420722175112354' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393336'
                WHERE ordernumber = 'P200722175230658' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '124325'
                WHERE ordernumber = 'P180722175241524' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '112842'
                WHERE ordernumber = 'P200722175749249' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402608'
                WHERE ordernumber = 'P420722175751178' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402609'
                WHERE ordernumber = 'P420722175915832' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402610'
                WHERE ordernumber = 'P180722180332935' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402611'
                WHERE ordernumber = 'P420722180445942' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402613'
                WHERE ordernumber = 'P420722181110424' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402614'
                WHERE ordernumber = 'P180722181224982' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382151'
                WHERE ordernumber = 'P190722181228337' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '244627'
                WHERE ordernumber = 'P180722181313397' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402478'
                WHERE ordernumber = 'P200722181630500' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '82328'
                WHERE ordernumber = 'P180722181726309' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400558'
                WHERE ordernumber = 'P420722181810321' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351860'
                WHERE ordernumber = 'P180722181905143' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219358'
                WHERE ordernumber = 'P180722182005484' 
            
2024-07-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402617'
                WHERE ordernumber = 'P180722182234600' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '101405'
                WHERE ordernumber = 'P180722182332964' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '219358'
                WHERE ordernumber = 'P180722182444932' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '95013'
                WHERE ordernumber = 'P190722182518822' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '6411'
                WHERE ordernumber = 'P180722182711827' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402618'
                WHERE ordernumber = 'P180722182924328' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '284709'
                WHERE ordernumber = 'P180722183005618' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402619'
                WHERE ordernumber = 'P420722183048877' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402621'
                WHERE ordernumber = 'P420722183402763' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '306209'
                WHERE ordernumber = 'P180722183423241' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402622'
                WHERE ordernumber = 'P180722183709959' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402624'
                WHERE ordernumber = 'P420722183935409' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402623'
                WHERE ordernumber = 'P200722183942326' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402623'
                WHERE ordernumber = 'P200722184029738' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '390498'
                WHERE ordernumber = 'P200722184149835' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402627'
                WHERE ordernumber = 'P200722184330154' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402620'
                WHERE ordernumber = 'P590722184410953' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '247102'
                WHERE ordernumber = 'P180722184629295' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '244090'
                WHERE ordernumber = 'P190722184703739' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '154270'
                WHERE ordernumber = 'P200722184950838' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401812'
                WHERE ordernumber = 'P420722185020719' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402629'
                WHERE ordernumber = 'P200722185157247' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '340095'
                WHERE ordernumber = 'P190722185813480' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402553'
                WHERE ordernumber = 'P190722190157387' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402630'
                WHERE ordernumber = 'P200722190224490' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '380916'
                WHERE ordernumber = 'P420722190427323' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '217089'
                WHERE ordernumber = 'P190722190517124' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402631'
                WHERE ordernumber = 'P420722190539988' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '242153'
                WHERE ordernumber = 'P200722191617778' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '100003'
                WHERE ordernumber = 'P190722191623194' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401952'
                WHERE ordernumber = 'P200722192113514' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402634'
                WHERE ordernumber = 'P190722192603704' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402635'
                WHERE ordernumber = 'P200722192938757' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402636'
                WHERE ordernumber = 'P200722193040358' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353827'
                WHERE ordernumber = 'P200722193501324' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '374079'
                WHERE ordernumber = 'P190722193923837' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '363039'
                WHERE ordernumber = 'P190722194257119' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '378763'
                WHERE ordernumber = 'P200722194443722' 
            
2024-07-23 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '103395'
                WHERE ordernumber = 'P200722195007162'