2024-02-23 01:00:02 -- 將會員中心id寫入data-lake
2024-02-23 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-02-22%';
        
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378438'
                WHERE ordernumber = 'P200222110314634' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363153'
                WHERE ordernumber = 'P420222110519257' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378439'
                WHERE ordernumber = 'P190222110602363' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378440'
                WHERE ordernumber = 'P180222111257438' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282932'
                WHERE ordernumber = 'P420222111502510' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378441'
                WHERE ordernumber = 'P180222111635144' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118408'
                WHERE ordernumber = 'P200222111914944' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342614'
                WHERE ordernumber = 'P180222112229765' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80921'
                WHERE ordernumber = 'P200222112258386' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378442'
                WHERE ordernumber = 'P420222112547530' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378443'
                WHERE ordernumber = 'P180222112628222' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378443'
                WHERE ordernumber = 'P180222112717767' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166685'
                WHERE ordernumber = 'P180222112856225' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378444'
                WHERE ordernumber = 'P180222113040518' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378445'
                WHERE ordernumber = 'P420222113936599' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378446'
                WHERE ordernumber = 'P180222113951363' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376356'
                WHERE ordernumber = 'P180222114043866' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377353'
                WHERE ordernumber = 'P420222114345971' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100087'
                WHERE ordernumber = 'P180222115634262' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378448'
                WHERE ordernumber = 'P200222115652429' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378279'
                WHERE ordernumber = 'P420222115946993' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378449'
                WHERE ordernumber = 'P420222120554789' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335123'
                WHERE ordernumber = 'P180222120911851' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348724'
                WHERE ordernumber = 'P180222121431234' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378451'
                WHERE ordernumber = 'P180222121834165' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296943'
                WHERE ordernumber = 'P420222121906911' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378452'
                WHERE ordernumber = 'P200222121955389' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162043'
                WHERE ordernumber = 'P180222122302310' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276095'
                WHERE ordernumber = 'P200222122544580' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378455'
                WHERE ordernumber = 'P200222123002983' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160734'
                WHERE ordernumber = 'P200222123420876' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335443'
                WHERE ordernumber = 'P200222123521213' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348234'
                WHERE ordernumber = 'P420222124439124' 
            
2024-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378456'
                WHERE ordernumber = 'P200222124633547' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378457'
                WHERE ordernumber = 'P200222125024989' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378458'
                WHERE ordernumber = 'P420222125305694' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377921'
                WHERE ordernumber = 'P420222125937562' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267733'
                WHERE ordernumber = 'P180222130151556' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378459'
                WHERE ordernumber = 'P420222130158194' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378460'
                WHERE ordernumber = 'P420222130310224' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378461'
                WHERE ordernumber = 'P200222130721887' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97773'
                WHERE ordernumber = 'P200222130906459' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378462'
                WHERE ordernumber = 'P200222131146993' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378463'
                WHERE ordernumber = 'P420222131227740' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374547'
                WHERE ordernumber = 'P420222131343234' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378463'
                WHERE ordernumber = 'P420222131541273' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338424'
                WHERE ordernumber = 'P420222131724466' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378112'
                WHERE ordernumber = 'P420222131849591' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377622'
                WHERE ordernumber = 'P420222132459864' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135820'
                WHERE ordernumber = 'P420222132835909' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245652'
                WHERE ordernumber = 'P200222133128414' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377517'
                WHERE ordernumber = 'P420222133522455' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143625'
                WHERE ordernumber = 'P180222133754322' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378316'
                WHERE ordernumber = 'P420222134157794' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257130'
                WHERE ordernumber = 'P180222134248832' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276843'
                WHERE ordernumber = 'P420222134431455' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99126'
                WHERE ordernumber = 'P180222134448121' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281727'
                WHERE ordernumber = 'P420222134702986' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377579'
                WHERE ordernumber = 'P180222135627367' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99625'
                WHERE ordernumber = 'P200222135700172' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378465'
                WHERE ordernumber = 'P200222140639887' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285394'
                WHERE ordernumber = 'P180222140851629' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378466'
                WHERE ordernumber = 'P180222141124527' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74290'
                WHERE ordernumber = 'P420222141144251' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378467'
                WHERE ordernumber = 'P180222141413306' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378468'
                WHERE ordernumber = 'P180222141459776' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298400'
                WHERE ordernumber = 'P420222141601334' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378469'
                WHERE ordernumber = 'P180222141718845' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378470'
                WHERE ordernumber = 'P200222141929237' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229781'
                WHERE ordernumber = 'P200222142002113' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213212'
                WHERE ordernumber = 'P200222142235972' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378471'
                WHERE ordernumber = 'P420222142450847' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344591'
                WHERE ordernumber = 'P200222142600520' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378472'
                WHERE ordernumber = 'P180222142648216' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293529'
                WHERE ordernumber = 'P420222142704244' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293529'
                WHERE ordernumber = 'P420222142753752' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378473'
                WHERE ordernumber = 'P200222142840710' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358947'
                WHERE ordernumber = 'P420222143224679' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378474'
                WHERE ordernumber = 'P180222143610502' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378475'
                WHERE ordernumber = 'P420222143930947' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378476'
                WHERE ordernumber = 'P420222144035808' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378478'
                WHERE ordernumber = 'P180222144827142' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344671'
                WHERE ordernumber = 'P180222145008976' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349637'
                WHERE ordernumber = 'P180222145223771' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378479'
                WHERE ordernumber = 'P180222145612734' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378481'
                WHERE ordernumber = 'P180222145805754' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378481'
                WHERE ordernumber = 'P180222145833883' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87774'
                WHERE ordernumber = 'P180222150001971' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378480'
                WHERE ordernumber = 'P180222150057769' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377631'
                WHERE ordernumber = 'P180222150349490' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378483'
                WHERE ordernumber = 'P200222150427754' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378484'
                WHERE ordernumber = 'P180222150450925' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109020'
                WHERE ordernumber = 'P180222150649878' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141930'
                WHERE ordernumber = 'P200222150859587' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281790'
                WHERE ordernumber = 'P200222151022370' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304578'
                WHERE ordernumber = 'P200222151112328' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378486'
                WHERE ordernumber = 'P180222151251602' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378487'
                WHERE ordernumber = 'P180222151430769' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378488'
                WHERE ordernumber = 'P180222151558859' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304162'
                WHERE ordernumber = 'P180222151803252' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378489'
                WHERE ordernumber = 'P420222152232641' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378490'
                WHERE ordernumber = 'P180222152253645' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378490'
                WHERE ordernumber = 'P180222152330481' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378491'
                WHERE ordernumber = 'P420222152556928' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376582'
                WHERE ordernumber = 'P180222152807378' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378493'
                WHERE ordernumber = 'P200222153036600' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378494'
                WHERE ordernumber = 'P180222153230390' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378495'
                WHERE ordernumber = 'P180222153317196' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378496'
                WHERE ordernumber = 'P180222153727608' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '78136'
                WHERE ordernumber = 'P180222153837878' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297640'
                WHERE ordernumber = 'P200222153945370' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120922'
                WHERE ordernumber = 'P180222154628831' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334332'
                WHERE ordernumber = 'P420222154652131' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378060'
                WHERE ordernumber = 'P200222160112969' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362843'
                WHERE ordernumber = 'P180222160404334' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362843'
                WHERE ordernumber = 'P180222160444550' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356679'
                WHERE ordernumber = 'P180222160928943' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311842'
                WHERE ordernumber = 'P420222161327929' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180222161440639' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378042'
                WHERE ordernumber = 'P190222161521613' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81029'
                WHERE ordernumber = 'P200222161950504' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378501'
                WHERE ordernumber = 'P420222162133734' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97763'
                WHERE ordernumber = 'P180222162337913' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378502'
                WHERE ordernumber = 'P180222163004733' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378503'
                WHERE ordernumber = 'P180222163117120' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344439'
                WHERE ordernumber = 'P180222163425815' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168883'
                WHERE ordernumber = 'P180222163729345' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378504'
                WHERE ordernumber = 'P200222164103898' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378505'
                WHERE ordernumber = 'P180222164812519' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167317'
                WHERE ordernumber = 'P180222164909760' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320337'
                WHERE ordernumber = 'P180222170935615' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378507'
                WHERE ordernumber = 'P200222171221867' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350016'
                WHERE ordernumber = 'P180222171231693' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297772'
                WHERE ordernumber = 'P180222171432889' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317233'
                WHERE ordernumber = 'P180222171743464' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378508'
                WHERE ordernumber = 'P420222172602587' 
            
2024-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P180222173110406' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P180222173132545' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371102'
                WHERE ordernumber = 'P180222173433777' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377503'
                WHERE ordernumber = 'P180222174022121' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243875'
                WHERE ordernumber = 'P190222174055149' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106167'
                WHERE ordernumber = 'P190222174339633' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378512'
                WHERE ordernumber = 'P200222174444892' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241822'
                WHERE ordernumber = 'P200222174621493' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378513'
                WHERE ordernumber = 'P200222174725954' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P200222175003306' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378516'
                WHERE ordernumber = 'P180222175727264' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279244'
                WHERE ordernumber = 'P180222175812971' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378517'
                WHERE ordernumber = 'P180222175954235' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378518'
                WHERE ordernumber = 'P200222180049952' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378519'
                WHERE ordernumber = 'P180222180206508' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371977'
                WHERE ordernumber = 'P200222180304690' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378515'
                WHERE ordernumber = 'P180222180445170' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378515'
                WHERE ordernumber = 'P180222180508549' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97942'
                WHERE ordernumber = 'P200222181022966' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160964'
                WHERE ordernumber = 'P190222181107413' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378521'
                WHERE ordernumber = 'P180222181113111' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378522'
                WHERE ordernumber = 'P420222181559655' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320456'
                WHERE ordernumber = 'P200222181824239' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218735'
                WHERE ordernumber = 'P180222182109183' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378524'
                WHERE ordernumber = 'P420222182231855' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279709'
                WHERE ordernumber = 'P180222182309130' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277994'
                WHERE ordernumber = 'P200222182456935' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378101'
                WHERE ordernumber = 'P200222182628252' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305809'
                WHERE ordernumber = 'P200222182713493' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378525'
                WHERE ordernumber = 'P180222182722557' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P180222183141880' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378277'
                WHERE ordernumber = 'P200222183436801' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344782'
                WHERE ordernumber = 'P200222183552447' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312498'
                WHERE ordernumber = 'P180222183601316' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290274'
                WHERE ordernumber = 'P200222183945171' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378526'
                WHERE ordernumber = 'P180222184332860' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378527'
                WHERE ordernumber = 'P180222184518433' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119225'
                WHERE ordernumber = 'P180222184833593' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214286'
                WHERE ordernumber = 'P200222184931212' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160223'
                WHERE ordernumber = 'P200222185005453' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336480'
                WHERE ordernumber = 'P420222185237662' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378528'
                WHERE ordernumber = 'P180222185354501' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278907'
                WHERE ordernumber = 'P190222185634803' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278965'
                WHERE ordernumber = 'P200222185749249' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277171'
                WHERE ordernumber = 'P200222190005388' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302483'
                WHERE ordernumber = 'P200222190219996' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280765'
                WHERE ordernumber = 'P190222191441217' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118407'
                WHERE ordernumber = 'P190222191756292' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122746'
                WHERE ordernumber = 'P200222192254605' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378532'
                WHERE ordernumber = 'P420222192307877' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378533'
                WHERE ordernumber = 'P200222193039167' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219031'
                WHERE ordernumber = 'P200222193221571' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378534'
                WHERE ordernumber = 'P420222193528583' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115003'
                WHERE ordernumber = 'P200222193618383' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233404'
                WHERE ordernumber = 'P200222193817993' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218546'
                WHERE ordernumber = 'P200222194126232' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106289'
                WHERE ordernumber = 'P190222195232536' 
            
2024-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378535'
                WHERE ordernumber = 'P200222195615863'