2025-02-26 01:00:01 -- 將會員中心id寫入data-lake
2025-02-26 01:00:01 -- 
            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 '2025-02-25%';
        
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365514'
                WHERE ordernumber = 'P2502250000008' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '453233'
                WHERE ordernumber = 'P2502250000010' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '75232'
                WHERE ordernumber = 'P2502250000011' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '75232'
                WHERE ordernumber = 'P2502250000013' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139459'
                WHERE ordernumber = 'P2502250000018' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458035'
                WHERE ordernumber = 'P2502250000019' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458034'
                WHERE ordernumber = 'P2502250000021' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458037'
                WHERE ordernumber = 'P2502250000022' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458036'
                WHERE ordernumber = 'P2502250000023' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340803'
                WHERE ordernumber = 'P2502250000024' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458038'
                WHERE ordernumber = 'P2502250000029' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303332'
                WHERE ordernumber = 'P2502250000031' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458040'
                WHERE ordernumber = 'P2502250000034' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458039'
                WHERE ordernumber = 'P2502250000035' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458041'
                WHERE ordernumber = 'P2502250000037' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288614'
                WHERE ordernumber = 'P2502250000039' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139459'
                WHERE ordernumber = 'P2502250000044' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458042'
                WHERE ordernumber = 'P2502250000045' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299849'
                WHERE ordernumber = 'P2502250000046' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458044'
                WHERE ordernumber = 'P2502250000047' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458045'
                WHERE ordernumber = 'P2502250000049' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2502250000052' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340551'
                WHERE ordernumber = 'P2502250000053' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456281'
                WHERE ordernumber = 'P2502250000057' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458048'
                WHERE ordernumber = 'P2502250000060' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458051'
                WHERE ordernumber = 'P2502250000063' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458052'
                WHERE ordernumber = 'P2502250000066' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381581'
                WHERE ordernumber = 'P2502250000067' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102656'
                WHERE ordernumber = 'P2502250000069' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430128'
                WHERE ordernumber = 'P2502250000072' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270641'
                WHERE ordernumber = 'P2502250000076' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378099'
                WHERE ordernumber = 'P2502250000080' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378099'
                WHERE ordernumber = 'P2502250000082' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '453170'
                WHERE ordernumber = 'P2502250000087' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2502250000091' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430128'
                WHERE ordernumber = 'P2502250000096' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458054'
                WHERE ordernumber = 'P2502250000100' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '7968'
                WHERE ordernumber = 'P2502250000106' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346334'
                WHERE ordernumber = 'P2502250000107' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458055'
                WHERE ordernumber = 'P2502250000108' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224874'
                WHERE ordernumber = 'P2502250000109' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454763'
                WHERE ordernumber = 'P2502250000110' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458056'
                WHERE ordernumber = 'P2502250000111' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458059'
                WHERE ordernumber = 'P2502250000116' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458061'
                WHERE ordernumber = 'P2502250000119' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395660'
                WHERE ordernumber = 'P2502250000120' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395831'
                WHERE ordernumber = 'P2502250000121' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455443'
                WHERE ordernumber = 'P2502250000122' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458063'
                WHERE ordernumber = 'P2502250000123' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395660'
                WHERE ordernumber = 'P2502250000126' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458065'
                WHERE ordernumber = 'P2502250000132' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224624'
                WHERE ordernumber = 'P2502250000134' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458066'
                WHERE ordernumber = 'P2502250000136' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458065'
                WHERE ordernumber = 'P2502250000139' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458068'
                WHERE ordernumber = 'P2502250000140' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380028'
                WHERE ordernumber = 'P2502250000144' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348922'
                WHERE ordernumber = 'P2502250000145' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320057'
                WHERE ordernumber = 'P2502250000146' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314960'
                WHERE ordernumber = 'P2502250000148' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458073'
                WHERE ordernumber = 'P2502250000149' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442464'
                WHERE ordernumber = 'P2502250000150' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458072'
                WHERE ordernumber = 'P2502250000151' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431994'
                WHERE ordernumber = 'P2502250000153' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455366'
                WHERE ordernumber = 'P2502250000154' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426997'
                WHERE ordernumber = 'P2502250000156' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '260398'
                WHERE ordernumber = 'P2502250000172' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211353'
                WHERE ordernumber = 'P2502250000173' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456825'
                WHERE ordernumber = 'P2502250000174' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P2502250000175' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415119'
                WHERE ordernumber = 'P2502250000177' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P2502250000178' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415119'
                WHERE ordernumber = 'P2502250000179' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458075'
                WHERE ordernumber = 'P2502250000180' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396356'
                WHERE ordernumber = 'P2502250000184' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272810'
                WHERE ordernumber = 'P2502250000185' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P2502250000189' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458076'
                WHERE ordernumber = 'P2502250000190' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457906'
                WHERE ordernumber = 'P2502250000192' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266880'
                WHERE ordernumber = 'P2502250000194' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458079'
                WHERE ordernumber = 'P2502250000196' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458078'
                WHERE ordernumber = 'P2502250000197' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456815'
                WHERE ordernumber = 'P2502250000198' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120521'
                WHERE ordernumber = 'P2502250000203' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432341'
                WHERE ordernumber = 'P2502250000205' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458081'
                WHERE ordernumber = 'P2502250000206' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238078'
                WHERE ordernumber = 'P2502250000208' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '446276'
                WHERE ordernumber = 'P2502250000209' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384130'
                WHERE ordernumber = 'P2502250000211' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458083'
                WHERE ordernumber = 'P2502250000212' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458084'
                WHERE ordernumber = 'P2502250000214' 
            
2025-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455662'
                WHERE ordernumber = 'P2502250000219' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458087'
                WHERE ordernumber = 'P2502250000230' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430755'
                WHERE ordernumber = 'P2502250000231' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287801'
                WHERE ordernumber = 'P2502250000233' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458088'
                WHERE ordernumber = 'P2502250000235' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458089'
                WHERE ordernumber = 'P2502250000238' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431742'
                WHERE ordernumber = 'P2502250000239' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428788'
                WHERE ordernumber = 'P2502250000240' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458090'
                WHERE ordernumber = 'P2502250000242' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458091'
                WHERE ordernumber = 'P2502250000245' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221252'
                WHERE ordernumber = 'P2502250000246' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313523'
                WHERE ordernumber = 'P2502250000248' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458092'
                WHERE ordernumber = 'P2502250000249' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458095'
                WHERE ordernumber = 'P2502250000257' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458096'
                WHERE ordernumber = 'P2502250000259' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379940'
                WHERE ordernumber = 'P2502250000262' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P2502250000263' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458097'
                WHERE ordernumber = 'P2502250000265' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111022'
                WHERE ordernumber = 'P2502250000267' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328370'
                WHERE ordernumber = 'P2502250000270' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421618'
                WHERE ordernumber = 'P2502250000273' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457559'
                WHERE ordernumber = 'P2502250000274' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351584'
                WHERE ordernumber = 'P2502250000276' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227698'
                WHERE ordernumber = 'P2502250000278' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458099'
                WHERE ordernumber = 'P2502250000280' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458100'
                WHERE ordernumber = 'P2502250000282' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458101'
                WHERE ordernumber = 'P2502250000285' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458102'
                WHERE ordernumber = 'P2502250000287' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102422'
                WHERE ordernumber = 'P2502250000290' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458103'
                WHERE ordernumber = 'P2502250000292' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458104'
                WHERE ordernumber = 'P2502250000293' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104898'
                WHERE ordernumber = 'P2502250000298' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109542'
                WHERE ordernumber = 'P2502250000301' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458105'
                WHERE ordernumber = 'P2502250000302' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109542'
                WHERE ordernumber = 'P2502250000304' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458106'
                WHERE ordernumber = 'P2502250000305' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251950'
                WHERE ordernumber = 'P2502250000307' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457398'
                WHERE ordernumber = 'P2502250000313' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457167'
                WHERE ordernumber = 'P2502250000319' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458108'
                WHERE ordernumber = 'P2502250000321' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238374'
                WHERE ordernumber = 'P2502250000324' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458109'
                WHERE ordernumber = 'P2502250000325' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457904'
                WHERE ordernumber = 'P2502250000329' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458111'
                WHERE ordernumber = 'P2502250000330' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458112'
                WHERE ordernumber = 'P2502250000333' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458109'
                WHERE ordernumber = 'P2502250000334' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458112'
                WHERE ordernumber = 'P2502250000336' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142556'
                WHERE ordernumber = 'P2502250000340' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458113'
                WHERE ordernumber = 'P2502250000341' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458114'
                WHERE ordernumber = 'P2502250000342' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458115'
                WHERE ordernumber = 'P2502250000348' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458116'
                WHERE ordernumber = 'P2502250000353' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379460'
                WHERE ordernumber = 'P2502250000354' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458115'
                WHERE ordernumber = 'P2502250000355' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458117'
                WHERE ordernumber = 'P2502250000360' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423017'
                WHERE ordernumber = 'P2502250000370' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458117'
                WHERE ordernumber = 'P2502250000372' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458118'
                WHERE ordernumber = 'P2502250000374' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217292'
                WHERE ordernumber = 'P2502250000375' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405973'
                WHERE ordernumber = 'P2502250000377' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383581'
                WHERE ordernumber = 'P2502250000379' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458120'
                WHERE ordernumber = 'P2502250000382' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433040'
                WHERE ordernumber = 'P2502250000383' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457935'
                WHERE ordernumber = 'P2502250000384' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457935'
                WHERE ordernumber = 'P2502250000386' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458119'
                WHERE ordernumber = 'P2502250000387' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457473'
                WHERE ordernumber = 'P2502250000388' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458121'
                WHERE ordernumber = 'P2502250000390' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458122'
                WHERE ordernumber = 'P2502250000391' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162980'
                WHERE ordernumber = 'P2502250000396' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406408'
                WHERE ordernumber = 'P2502250000397' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457385'
                WHERE ordernumber = 'P2502250000400' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458124'
                WHERE ordernumber = 'P2502250000401' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458123'
                WHERE ordernumber = 'P2502250000403' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458121'
                WHERE ordernumber = 'P2502250000405' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458125'
                WHERE ordernumber = 'P2502250000410' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458126'
                WHERE ordernumber = 'P2502250000411' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458127'
                WHERE ordernumber = 'P2502250000412' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417187'
                WHERE ordernumber = 'P2502250000413' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457385'
                WHERE ordernumber = 'P2502250000416' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455723'
                WHERE ordernumber = 'P2502250000424' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268158'
                WHERE ordernumber = 'P2502250000425' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458129'
                WHERE ordernumber = 'P2502250000429' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458130'
                WHERE ordernumber = 'P2502250000430' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458131'
                WHERE ordernumber = 'P2502250000435' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455485'
                WHERE ordernumber = 'P2502250000437' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458132'
                WHERE ordernumber = 'P2502250000439' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458133'
                WHERE ordernumber = 'P2502250000443' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458135'
                WHERE ordernumber = 'P2502250000445' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458137'
                WHERE ordernumber = 'P2502250000447' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458138'
                WHERE ordernumber = 'P2502250000450' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458139'
                WHERE ordernumber = 'P2502250000452' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263285'
                WHERE ordernumber = 'P2502250000453' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341702'
                WHERE ordernumber = 'P2502250000458' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458136'
                WHERE ordernumber = 'P2502250000459' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139551'
                WHERE ordernumber = 'P2502250000460' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458142'
                WHERE ordernumber = 'P2502250000461' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '190612'
                WHERE ordernumber = 'P2502250000463' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455037'
                WHERE ordernumber = 'P2502250000467' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113696'
                WHERE ordernumber = 'P2502250000470' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454638'
                WHERE ordernumber = 'P2502250000471' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P2502250000472' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442199'
                WHERE ordernumber = 'P2502250000474' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442344'
                WHERE ordernumber = 'P2502250000477' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457945'
                WHERE ordernumber = 'P2502250000482' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283780'
                WHERE ordernumber = 'P2502250000483' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291101'
                WHERE ordernumber = 'P2502250000484' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458144'
                WHERE ordernumber = 'P2502250000489' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339162'
                WHERE ordernumber = 'P2502250000490' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458146'
                WHERE ordernumber = 'P2502250000492' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458147'
                WHERE ordernumber = 'P2502250000493' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455575'
                WHERE ordernumber = 'P2502250000494' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458149'
                WHERE ordernumber = 'P2502250000496' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452192'
                WHERE ordernumber = 'P2502250000498' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458150'
                WHERE ordernumber = 'P2502250000499' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452192'
                WHERE ordernumber = 'P2502250000500' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458154'
                WHERE ordernumber = 'P2502250000502' 
            
2025-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458156'
                WHERE ordernumber = 'P2502250000503' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458155'
                WHERE ordernumber = 'P2502250000505' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98135'
                WHERE ordernumber = 'P2502250000506' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458151'
                WHERE ordernumber = 'P2502250000507' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458152'
                WHERE ordernumber = 'P2502250000508' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458157'
                WHERE ordernumber = 'P2502250000509' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457381'
                WHERE ordernumber = 'P2502250000511' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458158'
                WHERE ordernumber = 'P2502250000512' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244638'
                WHERE ordernumber = 'P2502250000517' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283578'
                WHERE ordernumber = 'P2502250000522' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458160'
                WHERE ordernumber = 'P2502250000523' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458161'
                WHERE ordernumber = 'P2502250000526' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458162'
                WHERE ordernumber = 'P2502250000527' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234659'
                WHERE ordernumber = 'P2502250000528' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242285'
                WHERE ordernumber = 'P2502250000533' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458163'
                WHERE ordernumber = 'P2502250000534' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458164'
                WHERE ordernumber = 'P2502250000537' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458165'
                WHERE ordernumber = 'P2502250000538' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99470'
                WHERE ordernumber = 'P2502250000541' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458166'
                WHERE ordernumber = 'P2502250000542' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458167'
                WHERE ordernumber = 'P2502250000545' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458168'
                WHERE ordernumber = 'P2502250000551' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359678'
                WHERE ordernumber = 'P2502250000556' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458170'
                WHERE ordernumber = 'P2502250000557' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416510'
                WHERE ordernumber = 'P2502250000558' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317218'
                WHERE ordernumber = 'P2502250000559' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389472'
                WHERE ordernumber = 'P2502250000560' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301862'
                WHERE ordernumber = 'P2502250000565' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458171'
                WHERE ordernumber = 'P2502250000569' 
            
2025-02-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458171'
                WHERE ordernumber = 'P2502250000572'