2025-01-02 01:00:02 -- 將會員中心id寫入data-lake
2025-01-02 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 '2025-01-01%';
        
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442316'
                WHERE ordernumber = 'P2501010000011' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442299'
                WHERE ordernumber = 'P2501010000012' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442317'
                WHERE ordernumber = 'P2501010000013' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137273'
                WHERE ordernumber = 'P2501010000014' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372713'
                WHERE ordernumber = 'P2501010000015' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442320'
                WHERE ordernumber = 'P2501010000017' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211100'
                WHERE ordernumber = 'P2501010000019' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442319'
                WHERE ordernumber = 'P2501010000020' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407516'
                WHERE ordernumber = 'P2501010000022' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '330561'
                WHERE ordernumber = 'P2501010000024' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442323'
                WHERE ordernumber = 'P2501010000025' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442325'
                WHERE ordernumber = 'P2501010000028' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296732'
                WHERE ordernumber = 'P2501010000029' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442330'
                WHERE ordernumber = 'P2501010000034' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441749'
                WHERE ordernumber = 'P2501010000040' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442331'
                WHERE ordernumber = 'P2501010000041' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442332'
                WHERE ordernumber = 'P2501010000043' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442333'
                WHERE ordernumber = 'P2501010000045' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417962'
                WHERE ordernumber = 'P2501010000046' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442336'
                WHERE ordernumber = 'P2501010000049' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442337'
                WHERE ordernumber = 'P2501010000050' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255632'
                WHERE ordernumber = 'P2501010000053' 
            
2025-01-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442338'
                WHERE ordernumber = 'P2501010000054' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266251'
                WHERE ordernumber = 'P2501010000057' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434179'
                WHERE ordernumber = 'P2501010000064' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346789'
                WHERE ordernumber = 'P2501010000071' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266251'
                WHERE ordernumber = 'P2501010000072' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346789'
                WHERE ordernumber = 'P2501010000073' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94715'
                WHERE ordernumber = 'P2501010000085' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264756'
                WHERE ordernumber = 'P2501010000087' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383797'
                WHERE ordernumber = 'P2501010000089' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442344'
                WHERE ordernumber = 'P2501010000091' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244638'
                WHERE ordernumber = 'P2501010000093' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381679'
                WHERE ordernumber = 'P2501010000095' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442349'
                WHERE ordernumber = 'P2501010000096' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442349'
                WHERE ordernumber = 'P2501010000104' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438312'
                WHERE ordernumber = 'P2501010000112' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357631'
                WHERE ordernumber = 'P2501010000115' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241311'
                WHERE ordernumber = 'P2501010000116' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442358'
                WHERE ordernumber = 'P2501010000118' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442363'
                WHERE ordernumber = 'P2501010000122' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442367'
                WHERE ordernumber = 'P2501010000126' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '201582'
                WHERE ordernumber = 'P2501010000128' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380242'
                WHERE ordernumber = 'P2501010000134' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431970'
                WHERE ordernumber = 'P2501010000136' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310419'
                WHERE ordernumber = 'P2501010000141' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92267'
                WHERE ordernumber = 'P2501010000145' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76193'
                WHERE ordernumber = 'P2501010000147' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432458'
                WHERE ordernumber = 'P2501010000150' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280357'
                WHERE ordernumber = 'P2501010000151' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259402'
                WHERE ordernumber = 'P2501010000154' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431780'
                WHERE ordernumber = 'P2501010000158' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312752'
                WHERE ordernumber = 'P2501010000170' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P2501010000173' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340137'
                WHERE ordernumber = 'P2501010000177' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331942'
                WHERE ordernumber = 'P2501010000183' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218558'
                WHERE ordernumber = 'P2501010000185' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442362'
                WHERE ordernumber = 'P2501010000191' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442384'
                WHERE ordernumber = 'P2501010000199' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442386'
                WHERE ordernumber = 'P2501010000202' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92045'
                WHERE ordernumber = 'P2501010000203' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '43472'
                WHERE ordernumber = 'P2501010000205' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442385'
                WHERE ordernumber = 'P2501010000206' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442389'
                WHERE ordernumber = 'P2501010000208' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263785'
                WHERE ordernumber = 'P2501010000210' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442392'
                WHERE ordernumber = 'P2501010000213' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442393'
                WHERE ordernumber = 'P2501010000217' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442394'
                WHERE ordernumber = 'P2501010000219' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442395'
                WHERE ordernumber = 'P2501010000224' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442402'
                WHERE ordernumber = 'P2501010000238' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323173'
                WHERE ordernumber = 'P2501010000242' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442405'
                WHERE ordernumber = 'P2501010000244' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442406'
                WHERE ordernumber = 'P2501010000246' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442409'
                WHERE ordernumber = 'P2501010000253' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442408'
                WHERE ordernumber = 'P2501010000254' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439147'
                WHERE ordernumber = 'P2501010000257' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268330'
                WHERE ordernumber = 'P2501010000258' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442412'
                WHERE ordernumber = 'P2501010000261' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442411'
                WHERE ordernumber = 'P2501010000269' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442410'
                WHERE ordernumber = 'P2501010000270' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442413'
                WHERE ordernumber = 'P2501010000271' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440492'
                WHERE ordernumber = 'P2501010000278' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442414'
                WHERE ordernumber = 'P2501010000280' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442415'
                WHERE ordernumber = 'P2501010000283' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442417'
                WHERE ordernumber = 'P2501010000285' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294490'
                WHERE ordernumber = 'P2501010000288' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440845'
                WHERE ordernumber = 'P2501010000292' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440845'
                WHERE ordernumber = 'P2501010000294' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442421'
                WHERE ordernumber = 'P2501010000296' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442422'
                WHERE ordernumber = 'P2501010000302' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442425'
                WHERE ordernumber = 'P2501010000304' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424522'
                WHERE ordernumber = 'P2501010000308' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442427'
                WHERE ordernumber = 'P2501010000310' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442430'
                WHERE ordernumber = 'P2501010000315' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442433'
                WHERE ordernumber = 'P2501010000317' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442432'
                WHERE ordernumber = 'P2501010000318' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405858'
                WHERE ordernumber = 'P2501010000321' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442435'
                WHERE ordernumber = 'P2501010000324' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425537'
                WHERE ordernumber = 'P2501010000325' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442436'
                WHERE ordernumber = 'P2501010000326' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442432'
                WHERE ordernumber = 'P2501010000328' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442437'
                WHERE ordernumber = 'P2501010000329' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442439'
                WHERE ordernumber = 'P2501010000330' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442440'
                WHERE ordernumber = 'P2501010000331' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162008'
                WHERE ordernumber = 'P2501010000337' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442442'
                WHERE ordernumber = 'P2501010000338' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442436'
                WHERE ordernumber = 'P2501010000342' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442445'
                WHERE ordernumber = 'P2501010000344' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442447'
                WHERE ordernumber = 'P2501010000346' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442448'
                WHERE ordernumber = 'P2501010000347' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206989'
                WHERE ordernumber = 'P2501010000351' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396076'
                WHERE ordernumber = 'P2501010000352' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442451'
                WHERE ordernumber = 'P2501010000355' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442454'
                WHERE ordernumber = 'P2501010000360' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442455'
                WHERE ordernumber = 'P2501010000362' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441069'
                WHERE ordernumber = 'P2501010000363' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148275'
                WHERE ordernumber = 'P2501010000368' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364715'
                WHERE ordernumber = 'P2501010000371' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275413'
                WHERE ordernumber = 'P2501010000373' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442457'
                WHERE ordernumber = 'P2501010000374' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289394'
                WHERE ordernumber = 'P2501010000378' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318094'
                WHERE ordernumber = 'P2501010000380' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442459'
                WHERE ordernumber = 'P2501010000384' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442461'
                WHERE ordernumber = 'P2501010000388' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125957'
                WHERE ordernumber = 'P2501010000390' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269382'
                WHERE ordernumber = 'P2501010000395' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442464'
                WHERE ordernumber = 'P2501010000396' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442467'
                WHERE ordernumber = 'P2501010000399' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311108'
                WHERE ordernumber = 'P2501010000403' 
            
2025-01-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404818'
                WHERE ordernumber = 'P2501010000406' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403893'
                WHERE ordernumber = 'P2501010000408' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P2501010000410' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340315'
                WHERE ordernumber = 'P2501010000416' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442474'
                WHERE ordernumber = 'P2501010000418' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442477'
                WHERE ordernumber = 'P2501010000419' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442478'
                WHERE ordernumber = 'P2501010000423' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271903'
                WHERE ordernumber = 'P2501010000425' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439784'
                WHERE ordernumber = 'P2501010000436' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442484'
                WHERE ordernumber = 'P2501010000439' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '196511'
                WHERE ordernumber = 'P2501010000444' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442487'
                WHERE ordernumber = 'P2501010000446' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402693'
                WHERE ordernumber = 'P2501010000449' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442490'
                WHERE ordernumber = 'P2501010000457' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442491'
                WHERE ordernumber = 'P2501010000462' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354460'
                WHERE ordernumber = 'P2501010000465' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290827'
                WHERE ordernumber = 'P2501010000466' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441746'
                WHERE ordernumber = 'P2501010000468' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442493'
                WHERE ordernumber = 'P2501010000470' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385057'
                WHERE ordernumber = 'P2501010000473' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442494'
                WHERE ordernumber = 'P2501010000476' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429545'
                WHERE ordernumber = 'P2501010000479' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442495'
                WHERE ordernumber = 'P2501010000481' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149813'
                WHERE ordernumber = 'P2501010000483' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249879'
                WHERE ordernumber = 'P2501010000489' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288433'
                WHERE ordernumber = 'P2501010000495' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442497'
                WHERE ordernumber = 'P2501010000499' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166490'
                WHERE ordernumber = 'P2501010000501' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236141'
                WHERE ordernumber = 'P2501010000508' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424047'
                WHERE ordernumber = 'P2501010000509' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236627'
                WHERE ordernumber = 'P2501010000510' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429060'
                WHERE ordernumber = 'P2501010000512' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442500'
                WHERE ordernumber = 'P2501010000514' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442501'
                WHERE ordernumber = 'P2501010000515' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442504'
                WHERE ordernumber = 'P2501010000517' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442503'
                WHERE ordernumber = 'P2501010000518' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442505'
                WHERE ordernumber = 'P2501010000520' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442506'
                WHERE ordernumber = 'P2501010000522' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442507'
                WHERE ordernumber = 'P2501010000524' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357538'
                WHERE ordernumber = 'P2501010000526' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342518'
                WHERE ordernumber = 'P2501010000527' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442510'
                WHERE ordernumber = 'P2501010000528' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442511'
                WHERE ordernumber = 'P2501010000530' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249878'
                WHERE ordernumber = 'P2501010000532' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287142'
                WHERE ordernumber = 'P2501010000533' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442514'
                WHERE ordernumber = 'P2501010000536' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275713'
                WHERE ordernumber = 'P2501010000539' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377794'
                WHERE ordernumber = 'P2501010000540' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286089'
                WHERE ordernumber = 'P2501010000542' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442299'
                WHERE ordernumber = 'P2501010000012' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372713'
                WHERE ordernumber = 'P2501010000015' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442519'
                WHERE ordernumber = 'P2501010000560' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432086'
                WHERE ordernumber = 'P2501010000561' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442320'
                WHERE ordernumber = 'P2501010000017' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407516'
                WHERE ordernumber = 'P2501010000022' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442325'
                WHERE ordernumber = 'P2501010000028' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253569'
                WHERE ordernumber = 'P2501010000567' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442518'
                WHERE ordernumber = 'P2501010000571' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442333'
                WHERE ordernumber = 'P2501010000045' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442518'
                WHERE ordernumber = 'P2501010000572' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442522'
                WHERE ordernumber = 'P2501010000575' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417962'
                WHERE ordernumber = 'P2501010000046' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442523'
                WHERE ordernumber = 'P2501010000585' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429412'
                WHERE ordernumber = 'P2501010000586' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225903'
                WHERE ordernumber = 'P2501010000587' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442527'
                WHERE ordernumber = 'P2501010000589' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442527'
                WHERE ordernumber = 'P2501010000590' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P2501010000591' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429412'
                WHERE ordernumber = 'P2501010000592' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442527'
                WHERE ordernumber = 'P2501010000596' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389190'
                WHERE ordernumber = 'P2501010000598' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P2501010000600' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207859'
                WHERE ordernumber = 'P2501010000602' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81850'
                WHERE ordernumber = 'P2501010000622' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442534'
                WHERE ordernumber = 'P2501010000627' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136864'
                WHERE ordernumber = 'P2501010000628' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442535'
                WHERE ordernumber = 'P2501010000635' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442536'
                WHERE ordernumber = 'P2501010000637' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356799'
                WHERE ordernumber = 'P2501010000640' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442538'
                WHERE ordernumber = 'P2501010000643' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431177'
                WHERE ordernumber = 'P2501010000644' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431177'
                WHERE ordernumber = 'P2501010000645' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431177'
                WHERE ordernumber = 'P2501010000649' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P2501010000652' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442542'
                WHERE ordernumber = 'P2501010000654' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442544'
                WHERE ordernumber = 'P2501010000656' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272486'
                WHERE ordernumber = 'P2501010000659' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442546'
                WHERE ordernumber = 'P2501010000661' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321904'
                WHERE ordernumber = 'P2501010000666' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439620'
                WHERE ordernumber = 'P2501010000671' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347465'
                WHERE ordernumber = 'P2501010000675' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '199750'
                WHERE ordernumber = 'P2501010000676' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442550'
                WHERE ordernumber = 'P2501010000678' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400730'
                WHERE ordernumber = 'P2501010000681' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442552'
                WHERE ordernumber = 'P2501010000684' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439620'
                WHERE ordernumber = 'P2501010000686' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305769'
                WHERE ordernumber = 'P2501010000693' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241318'
                WHERE ordernumber = 'P2501010000698' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442557'
                WHERE ordernumber = 'P2501010000699' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442560'
                WHERE ordernumber = 'P2501010000705' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432473'
                WHERE ordernumber = 'P2501010000706' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442561'
                WHERE ordernumber = 'P2501010000711' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211888'
                WHERE ordernumber = 'P2501010000714' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290405'
                WHERE ordernumber = 'P2501010000719' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257872'
                WHERE ordernumber = 'P2501010000736' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442574'
                WHERE ordernumber = 'P2501010000739' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '145774'
                WHERE ordernumber = 'P2501010000740' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442576'
                WHERE ordernumber = 'P2501010000743' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397161'
                WHERE ordernumber = 'P2501010000745' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298460'
                WHERE ordernumber = 'P2501010000748' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345313'
                WHERE ordernumber = 'P2501010000756' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229332'
                WHERE ordernumber = 'P2501010000784' 
            
2025-01-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442588'
                WHERE ordernumber = 'P2501010000788' 
            
2025-01-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442590'
                WHERE ordernumber = 'P2501010000800' 
            
2025-01-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '370643'
                WHERE ordernumber = 'P2501010000806' 
            
2025-01-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '370643'
                WHERE ordernumber = 'P2501010000808' 
            
2025-01-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375944'
                WHERE ordernumber = 'P2501010000813' 
            
2025-01-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228414'
                WHERE ordernumber = 'P2501010000815'