2025-03-12 01:00:02 -- 將會員中心id寫入data-lake
2025-03-12 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-03-11%';
        
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P2503110000010' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '447665'
                WHERE ordernumber = 'P2503110000012' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133267'
                WHERE ordernumber = 'P2503110000014' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95192'
                WHERE ordernumber = 'P2503110000017' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133267'
                WHERE ordernumber = 'P2503110000021' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428917'
                WHERE ordernumber = 'P2503110000022' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460473'
                WHERE ordernumber = 'P2503110000024' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400138'
                WHERE ordernumber = 'P2503110000025' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2503110000029' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460474'
                WHERE ordernumber = 'P2503110000030' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460477'
                WHERE ordernumber = 'P2503110000035' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298128'
                WHERE ordernumber = 'P2503110000037' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460479'
                WHERE ordernumber = 'P2503110000038' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298076'
                WHERE ordernumber = 'P2503110000039' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460480'
                WHERE ordernumber = 'P2503110000043' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460481'
                WHERE ordernumber = 'P2503110000049' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460482'
                WHERE ordernumber = 'P2503110000053' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460483'
                WHERE ordernumber = 'P2503110000055' 
            
2025-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460484'
                WHERE ordernumber = 'P2503110000057' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390112'
                WHERE ordernumber = 'P2503110000059' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2503110000067' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458291'
                WHERE ordernumber = 'P2503110000070' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460486'
                WHERE ordernumber = 'P2503110000072' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245453'
                WHERE ordernumber = 'P2503110000077' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248429'
                WHERE ordernumber = 'P2503110000081' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369193'
                WHERE ordernumber = 'P2503110000083' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460487'
                WHERE ordernumber = 'P2503110000084' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460488'
                WHERE ordernumber = 'P2503110000086' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460489'
                WHERE ordernumber = 'P2503110000087' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2503110000088' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P2503110000089' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348972'
                WHERE ordernumber = 'P2503110000092' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P2503110000093' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2503110000094' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460490'
                WHERE ordernumber = 'P2503110000095' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460492'
                WHERE ordernumber = 'P2503110000098' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460493'
                WHERE ordernumber = 'P2503110000100' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457823'
                WHERE ordernumber = 'P2503110000103' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460494'
                WHERE ordernumber = 'P2503110000106' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460498'
                WHERE ordernumber = 'P2503110000108' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460495'
                WHERE ordernumber = 'P2503110000109' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299755'
                WHERE ordernumber = 'P2503110000111' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460501'
                WHERE ordernumber = 'P2503110000115' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422520'
                WHERE ordernumber = 'P2503110000122' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460503'
                WHERE ordernumber = 'P2503110000124' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364083'
                WHERE ordernumber = 'P2503110000125' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114409'
                WHERE ordernumber = 'P2503110000126' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460506'
                WHERE ordernumber = 'P2503110000130' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346827'
                WHERE ordernumber = 'P2503110000133' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460505'
                WHERE ordernumber = 'P2503110000135' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P2503110000136' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241983'
                WHERE ordernumber = 'P2503110000138' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460507'
                WHERE ordernumber = 'P2503110000140' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419589'
                WHERE ordernumber = 'P2503110000141' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404291'
                WHERE ordernumber = 'P2503110000142' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460508'
                WHERE ordernumber = 'P2503110000144' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116475'
                WHERE ordernumber = 'P2503110000149' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275910'
                WHERE ordernumber = 'P2503110000150' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460509'
                WHERE ordernumber = 'P2503110000152' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460510'
                WHERE ordernumber = 'P2503110000153' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460511'
                WHERE ordernumber = 'P2503110000154' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257894'
                WHERE ordernumber = 'P2503110000156' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458591'
                WHERE ordernumber = 'P2503110000162' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460513'
                WHERE ordernumber = 'P2503110000163' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P2503110000165' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P2503110000166' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94937'
                WHERE ordernumber = 'P2503110000169' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '28928'
                WHERE ordernumber = 'P2503110000174' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460514'
                WHERE ordernumber = 'P2503110000175' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460516'
                WHERE ordernumber = 'P2503110000177' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460518'
                WHERE ordernumber = 'P2503110000180' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460519'
                WHERE ordernumber = 'P2503110000181' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460520'
                WHERE ordernumber = 'P2503110000184' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460522'
                WHERE ordernumber = 'P2503110000188' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460523'
                WHERE ordernumber = 'P2503110000189' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309598'
                WHERE ordernumber = 'P2503110000190' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460524'
                WHERE ordernumber = 'P2503110000191' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460517'
                WHERE ordernumber = 'P2503110000194' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460526'
                WHERE ordernumber = 'P2503110000200' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P2503110000202' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105116'
                WHERE ordernumber = 'P2503110000203' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460525'
                WHERE ordernumber = 'P2503110000205' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326866'
                WHERE ordernumber = 'P2503110000207' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460528'
                WHERE ordernumber = 'P2503110000210' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460527'
                WHERE ordernumber = 'P2503110000211' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460529'
                WHERE ordernumber = 'P2503110000212' 
            
2025-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460525'
                WHERE ordernumber = 'P2503110000214' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309598'
                WHERE ordernumber = 'P2503110000215' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395721'
                WHERE ordernumber = 'P2503110000218' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428639'
                WHERE ordernumber = 'P2503110000224' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248174'
                WHERE ordernumber = 'P2503110000227' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460532'
                WHERE ordernumber = 'P2503110000233' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460530'
                WHERE ordernumber = 'P2503110000234' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97441'
                WHERE ordernumber = 'P2503110000239' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460536'
                WHERE ordernumber = 'P2503110000252' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401740'
                WHERE ordernumber = 'P2503110000253' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460538'
                WHERE ordernumber = 'P2503110000256' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460541'
                WHERE ordernumber = 'P2503110000260' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329734'
                WHERE ordernumber = 'P2503110000263' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460542'
                WHERE ordernumber = 'P2503110000264' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338630'
                WHERE ordernumber = 'P2503110000267' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421792'
                WHERE ordernumber = 'P2503110000271' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460544'
                WHERE ordernumber = 'P2503110000273' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455379'
                WHERE ordernumber = 'P2503110000274' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310527'
                WHERE ordernumber = 'P2503110000276' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459370'
                WHERE ordernumber = 'P2503110000279' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455130'
                WHERE ordernumber = 'P2503110000286' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460545'
                WHERE ordernumber = 'P2503110000287' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455630'
                WHERE ordernumber = 'P2503110000288' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460546'
                WHERE ordernumber = 'P2503110000290' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218966'
                WHERE ordernumber = 'P2503110000291' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460545'
                WHERE ordernumber = 'P2503110000294' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103010'
                WHERE ordernumber = 'P2503110000296' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460548'
                WHERE ordernumber = 'P2503110000298' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279781'
                WHERE ordernumber = 'P2503110000299' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '205060'
                WHERE ordernumber = 'P2503110000301' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380491'
                WHERE ordernumber = 'P2503110000307' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460547'
                WHERE ordernumber = 'P2503110000308' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460549'
                WHERE ordernumber = 'P2503110000309' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408833'
                WHERE ordernumber = 'P2503110000310' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460551'
                WHERE ordernumber = 'P2503110000314' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460551'
                WHERE ordernumber = 'P2503110000316' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '57631'
                WHERE ordernumber = 'P2503110000319' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460552'
                WHERE ordernumber = 'P2503110000320' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243229'
                WHERE ordernumber = 'P2503110000321' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433872'
                WHERE ordernumber = 'P2503110000323' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347375'
                WHERE ordernumber = 'P2503110000324' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332449'
                WHERE ordernumber = 'P2503110000331' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460553'
                WHERE ordernumber = 'P2503110000332' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318750'
                WHERE ordernumber = 'P2503110000336' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460554'
                WHERE ordernumber = 'P2503110000338' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458393'
                WHERE ordernumber = 'P2503110000340' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426508'
                WHERE ordernumber = 'P2503110000342' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460555'
                WHERE ordernumber = 'P2503110000343' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460556'
                WHERE ordernumber = 'P2503110000344' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460557'
                WHERE ordernumber = 'P2503110000347' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357609'
                WHERE ordernumber = 'P2503110000351' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460558'
                WHERE ordernumber = 'P2503110000353' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460554'
                WHERE ordernumber = 'P2503110000354' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128450'
                WHERE ordernumber = 'P2503110000355' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460560'
                WHERE ordernumber = 'P2503110000356' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460559'
                WHERE ordernumber = 'P2503110000357' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459870'
                WHERE ordernumber = 'P2503110000358' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136811'
                WHERE ordernumber = 'P2503110000361' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403893'
                WHERE ordernumber = 'P2503110000363' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409185'
                WHERE ordernumber = 'P2503110000365' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P2503110000386' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460563'
                WHERE ordernumber = 'P2503110000388' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460565'
                WHERE ordernumber = 'P2503110000391' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456992'
                WHERE ordernumber = 'P2503110000393' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309969'
                WHERE ordernumber = 'P2503110000394' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394836'
                WHERE ordernumber = 'P2503110000396' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383361'
                WHERE ordernumber = 'P2503110000399' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460566'
                WHERE ordernumber = 'P2503110000402' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227799'
                WHERE ordernumber = 'P2503110000404' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211017'
                WHERE ordernumber = 'P2503110000405' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345453'
                WHERE ordernumber = 'P2503110000406' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '182508'
                WHERE ordernumber = 'P2503110000407' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104036'
                WHERE ordernumber = 'P2503110000410' 
            
2025-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249106'
                WHERE ordernumber = 'P2503110000411' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460568'
                WHERE ordernumber = 'P2503110000417' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460569'
                WHERE ordernumber = 'P2503110000418' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388489'
                WHERE ordernumber = 'P2503110000422' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453281'
                WHERE ordernumber = 'P2503110000424' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460572'
                WHERE ordernumber = 'P2503110000425' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460573'
                WHERE ordernumber = 'P2503110000428' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460571'
                WHERE ordernumber = 'P2503110000434' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460571'
                WHERE ordernumber = 'P2503110000435' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459324'
                WHERE ordernumber = 'P2503110000438' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459324'
                WHERE ordernumber = 'P2503110000442' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460574'
                WHERE ordernumber = 'P2503110000445' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '427639'
                WHERE ordernumber = 'P2503110000449' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '139381'
                WHERE ordernumber = 'P2503110000451' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460575'
                WHERE ordernumber = 'P2503110000457' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '78891'
                WHERE ordernumber = 'P2503110000461' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458157'
                WHERE ordernumber = 'P2503110000469' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '52438'
                WHERE ordernumber = 'P2503110000470' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342646'
                WHERE ordernumber = 'P2503110000472' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342646'
                WHERE ordernumber = 'P2503110000473' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402182'
                WHERE ordernumber = 'P2503110000477' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314795'
                WHERE ordernumber = 'P2503110000478' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460578'
                WHERE ordernumber = 'P2503110000481' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460579'
                WHERE ordernumber = 'P2503110000482' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460580'
                WHERE ordernumber = 'P2503110000484' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277175'
                WHERE ordernumber = 'P2503110000486' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396722'
                WHERE ordernumber = 'P2503110000491' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396722'
                WHERE ordernumber = 'P2503110000494' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291414'
                WHERE ordernumber = 'P2503110000499' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460581'
                WHERE ordernumber = 'P2503110000500' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460582'
                WHERE ordernumber = 'P2503110000501' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291414'
                WHERE ordernumber = 'P2503110000503' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '262726'
                WHERE ordernumber = 'P2503110000506' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459627'
                WHERE ordernumber = 'P2503110000507' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '262726'
                WHERE ordernumber = 'P2503110000509' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348295'
                WHERE ordernumber = 'P2503110000513' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460583'
                WHERE ordernumber = 'P2503110000519' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460585'
                WHERE ordernumber = 'P2503110000523' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391529'
                WHERE ordernumber = 'P2503110000524' 
            
2025-03-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368246'
                WHERE ordernumber = 'P2503110000532'