2025-01-22 01:00:02 -- 將會員中心id寫入data-lake
2025-01-22 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-21%';
        
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452903'
                WHERE ordernumber = 'P2501210000032' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318199'
                WHERE ordernumber = 'P2501210000034' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '40455'
                WHERE ordernumber = 'P2501210000035' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341673'
                WHERE ordernumber = 'P2501210000036' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335951'
                WHERE ordernumber = 'P2501210000038' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452765'
                WHERE ordernumber = 'P2501210000040' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452894'
                WHERE ordernumber = 'P2501210000043' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452894'
                WHERE ordernumber = 'P2501210000044' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374505'
                WHERE ordernumber = 'P2501210000045' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258479'
                WHERE ordernumber = 'P2501210000047' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374511'
                WHERE ordernumber = 'P2501210000050' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452906'
                WHERE ordernumber = 'P2501210000051' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98968'
                WHERE ordernumber = 'P2501210000052' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208752'
                WHERE ordernumber = 'P2501210000053' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102595'
                WHERE ordernumber = 'P2501210000055' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346253'
                WHERE ordernumber = 'P2501210000057' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344546'
                WHERE ordernumber = 'P2501210000058' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387378'
                WHERE ordernumber = 'P2501210000060' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209267'
                WHERE ordernumber = 'P2501210000061' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452911'
                WHERE ordernumber = 'P2501210000063' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452898'
                WHERE ordernumber = 'P2501210000065' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304909'
                WHERE ordernumber = 'P2501210000067' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94924'
                WHERE ordernumber = 'P2501210000073' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452900'
                WHERE ordernumber = 'P2501210000074' 
            
2025-01-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441547'
                WHERE ordernumber = 'P2501210000080' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110061'
                WHERE ordernumber = 'P2501210000082' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115536'
                WHERE ordernumber = 'P2501210000084' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340608'
                WHERE ordernumber = 'P2501210000087' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452915'
                WHERE ordernumber = 'P2501210000088' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452916'
                WHERE ordernumber = 'P2501210000092' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452918'
                WHERE ordernumber = 'P2501210000096' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236330'
                WHERE ordernumber = 'P2501210000100' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446656'
                WHERE ordernumber = 'P2501210000103' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452919'
                WHERE ordernumber = 'P2501210000106' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452907'
                WHERE ordernumber = 'P2501210000110' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P2501210000111' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452907'
                WHERE ordernumber = 'P2501210000113' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452921'
                WHERE ordernumber = 'P2501210000116' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452922'
                WHERE ordernumber = 'P2501210000122' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452923'
                WHERE ordernumber = 'P2501210000127' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374536'
                WHERE ordernumber = 'P2501210000130' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63111'
                WHERE ordernumber = 'P2501210000132' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143775'
                WHERE ordernumber = 'P2501210000136' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340890'
                WHERE ordernumber = 'P2501210000138' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258460'
                WHERE ordernumber = 'P2501210000139' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393821'
                WHERE ordernumber = 'P2501210000141' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452927'
                WHERE ordernumber = 'P2501210000142' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452929'
                WHERE ordernumber = 'P2501210000147' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383319'
                WHERE ordernumber = 'P2501210000149' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373741'
                WHERE ordernumber = 'P2501210000150' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374511'
                WHERE ordernumber = 'P2501210000152' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452933'
                WHERE ordernumber = 'P2501210000153' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452914'
                WHERE ordernumber = 'P2501210000154' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452936'
                WHERE ordernumber = 'P2501210000156' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P2501210000159' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452926'
                WHERE ordernumber = 'P2501210000161' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452910'
                WHERE ordernumber = 'P2501210000163' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452905'
                WHERE ordernumber = 'P2501210000166' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452905'
                WHERE ordernumber = 'P2501210000168' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380121'
                WHERE ordernumber = 'P2501210000171' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452924'
                WHERE ordernumber = 'P2501210000174' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305962'
                WHERE ordernumber = 'P2501210000175' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305962'
                WHERE ordernumber = 'P2501210000178' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335951'
                WHERE ordernumber = 'P2501210000179' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '75630'
                WHERE ordernumber = 'P2501210000180' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452938'
                WHERE ordernumber = 'P2501210000182' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452910'
                WHERE ordernumber = 'P2501210000183' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317238'
                WHERE ordernumber = 'P2501210000194' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376227'
                WHERE ordernumber = 'P2501210000198' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '449100'
                WHERE ordernumber = 'P2501210000203' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386706'
                WHERE ordernumber = 'P2501210000210' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382638'
                WHERE ordernumber = 'P2501210000215' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266327'
                WHERE ordernumber = 'P2501210000217' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261237'
                WHERE ordernumber = 'P2501210000223' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452899'
                WHERE ordernumber = 'P2501210000230' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294838'
                WHERE ordernumber = 'P2501210000241' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372212'
                WHERE ordernumber = 'P2501210000248' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452943'
                WHERE ordernumber = 'P2501210000254' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237679'
                WHERE ordernumber = 'P2501210000255' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361052'
                WHERE ordernumber = 'P2501210000256' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442792'
                WHERE ordernumber = 'P2501210000261' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440196'
                WHERE ordernumber = 'P2501210000262' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452944'
                WHERE ordernumber = 'P2501210000266' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256413'
                WHERE ordernumber = 'P2501210000271' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323769'
                WHERE ordernumber = 'P2501210000274' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '448273'
                WHERE ordernumber = 'P2501210000275' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440229'
                WHERE ordernumber = 'P2501210000276' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '447286'
                WHERE ordernumber = 'P2501210000280' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434657'
                WHERE ordernumber = 'P2501210000283' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442372'
                WHERE ordernumber = 'P2501210000291' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '451811'
                WHERE ordernumber = 'P2501210000293' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452948'
                WHERE ordernumber = 'P2501210000296' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375836'
                WHERE ordernumber = 'P2501210000298' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329441'
                WHERE ordernumber = 'P2501210000301' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452934'
                WHERE ordernumber = 'P2501210000304' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204136'
                WHERE ordernumber = 'P2501210000306' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364056'
                WHERE ordernumber = 'P2501210000311' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437266'
                WHERE ordernumber = 'P2501210000312' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376920'
                WHERE ordernumber = 'P2501210000319' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320679'
                WHERE ordernumber = 'P2501210000320' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452942'
                WHERE ordernumber = 'P2501210000324' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220135'
                WHERE ordernumber = 'P2501210000327' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420760'
                WHERE ordernumber = 'P2501210000331' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452940'
                WHERE ordernumber = 'P2501210000332' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452946'
                WHERE ordernumber = 'P2501210000333' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236957'
                WHERE ordernumber = 'P2501210000338' 
            
2025-01-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452946'
                WHERE ordernumber = 'P2501210000344' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122228'
                WHERE ordernumber = 'P2501210000346' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243431'
                WHERE ordernumber = 'P2501210000348' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452953'
                WHERE ordernumber = 'P2501210000351' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '451497'
                WHERE ordernumber = 'P2501210000356' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452945'
                WHERE ordernumber = 'P2501210000363' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452950'
                WHERE ordernumber = 'P2501210000364' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440269'
                WHERE ordernumber = 'P2501210000369' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244286'
                WHERE ordernumber = 'P2501210000370' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206863'
                WHERE ordernumber = 'P2501210000377' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399828'
                WHERE ordernumber = 'P2501210000380' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377386'
                WHERE ordernumber = 'P2501210000381' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314080'
                WHERE ordernumber = 'P2501210000388' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452955'
                WHERE ordernumber = 'P2501210000393' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329845'
                WHERE ordernumber = 'P2501210000400' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446866'
                WHERE ordernumber = 'P2501210000414' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101964'
                WHERE ordernumber = 'P2501210000419' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157839'
                WHERE ordernumber = 'P2501210000428' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452961'
                WHERE ordernumber = 'P2501210000431' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452955'
                WHERE ordernumber = 'P2501210000437' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406956'
                WHERE ordernumber = 'P2501210000439' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380807'
                WHERE ordernumber = 'P2501210000445' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348880'
                WHERE ordernumber = 'P2501210000449' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410542'
                WHERE ordernumber = 'P2501210000456' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452956'
                WHERE ordernumber = 'P2501210000457' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430592'
                WHERE ordernumber = 'P2501210000458' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P2501210000466' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452960'
                WHERE ordernumber = 'P2501210000469' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388879'
                WHERE ordernumber = 'P2501210000473' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452965'
                WHERE ordernumber = 'P2501210000477' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349921'
                WHERE ordernumber = 'P2501210000482' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452963'
                WHERE ordernumber = 'P2501210000487' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262864'
                WHERE ordernumber = 'P2501210000489' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206610'
                WHERE ordernumber = 'P2501210000490' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305769'
                WHERE ordernumber = 'P2501210000491' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434537'
                WHERE ordernumber = 'P2501210000498' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452962'
                WHERE ordernumber = 'P2501210000501' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '77841'
                WHERE ordernumber = 'P2501210000504' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423802'
                WHERE ordernumber = 'P2501210000510' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452968'
                WHERE ordernumber = 'P2501210000512' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452970'
                WHERE ordernumber = 'P2501210000525' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402552'
                WHERE ordernumber = 'P2501210000527' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452971'
                WHERE ordernumber = 'P2501210000528' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430592'
                WHERE ordernumber = 'P2501210000534' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248159'
                WHERE ordernumber = 'P2501210000539' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247088'
                WHERE ordernumber = 'P2501210000543' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284775'
                WHERE ordernumber = 'P2501210000545' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452974'
                WHERE ordernumber = 'P2501210000553' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128554'
                WHERE ordernumber = 'P2501210000559' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452978'
                WHERE ordernumber = 'P2501210000566' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452967'
                WHERE ordernumber = 'P2501210000577' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236789'
                WHERE ordernumber = 'P2501210000579' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310483'
                WHERE ordernumber = 'P2501210000593' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236404'
                WHERE ordernumber = 'P2501210000595' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312042'
                WHERE ordernumber = 'P2501210000596' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452980'
                WHERE ordernumber = 'P2501210000601' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452979'
                WHERE ordernumber = 'P2501210000604' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452981'
                WHERE ordernumber = 'P2501210000605' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295014'
                WHERE ordernumber = 'P2501210000610' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437988'
                WHERE ordernumber = 'P2501210000614' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425451'
                WHERE ordernumber = 'P2501210000620' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452983'
                WHERE ordernumber = 'P2501210000625' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376162'
                WHERE ordernumber = 'P2501210000626' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384058'
                WHERE ordernumber = 'P2501210000640' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132314'
                WHERE ordernumber = 'P2501210000648' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430251'
                WHERE ordernumber = 'P2501210000675' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430251'
                WHERE ordernumber = 'P2501210000678' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370926'
                WHERE ordernumber = 'P2501210000679' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438541'
                WHERE ordernumber = 'P2501210000680' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394741'
                WHERE ordernumber = 'P2501210000681' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452985'
                WHERE ordernumber = 'P2501210000689' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431617'
                WHERE ordernumber = 'P2501210000695' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452986'
                WHERE ordernumber = 'P2501210000700' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230365'
                WHERE ordernumber = 'P2501210000702' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452989'
                WHERE ordernumber = 'P2501210000710' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98530'
                WHERE ordernumber = 'P2501210000715' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112931'
                WHERE ordernumber = 'P2501210000722' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443274'
                WHERE ordernumber = 'P2501210000723' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152506'
                WHERE ordernumber = 'P2501210000734' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152506'
                WHERE ordernumber = 'P2501210000738' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132314'
                WHERE ordernumber = 'P2501210000745' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452991'
                WHERE ordernumber = 'P2501210000747' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '451889'
                WHERE ordernumber = 'P2501210000752' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438910'
                WHERE ordernumber = 'P2501210000754' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452993'
                WHERE ordernumber = 'P2501210000758' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452994'
                WHERE ordernumber = 'P2501210000761' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452995'
                WHERE ordernumber = 'P2501210000769' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452997'
                WHERE ordernumber = 'P2501210000775' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452996'
                WHERE ordernumber = 'P2501210000776' 
            
2025-01-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366347'
                WHERE ordernumber = 'P2501210000777' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '452994'
                WHERE ordernumber = 'P2501210000782' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343971'
                WHERE ordernumber = 'P2501210000794' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '83238'
                WHERE ordernumber = 'P2501210000795' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '446331'
                WHERE ordernumber = 'P2501210000797' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '320057'
                WHERE ordernumber = 'P2501210000807' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '448640'
                WHERE ordernumber = 'P2501210000812' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382573'
                WHERE ordernumber = 'P2501210000814' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '148024'
                WHERE ordernumber = 'P2501210000824' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P2501210000831' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410624'
                WHERE ordernumber = 'P2501210000841' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453000'
                WHERE ordernumber = 'P2501210000843' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453001'
                WHERE ordernumber = 'P2501210000860' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383095'
                WHERE ordernumber = 'P2501210000864' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '142238'
                WHERE ordernumber = 'P2501210000867' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453002'
                WHERE ordernumber = 'P2501210000869' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221944'
                WHERE ordernumber = 'P2501210000882' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287988'
                WHERE ordernumber = 'P2501210000886' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '443375'
                WHERE ordernumber = 'P2501210000889' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301150'
                WHERE ordernumber = 'P2501210000896' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313542'
                WHERE ordernumber = 'P2501210000916' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '446317'
                WHERE ordernumber = 'P2501210000917' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81760'
                WHERE ordernumber = 'P2501210000919' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442212'
                WHERE ordernumber = 'P2501210000926' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423217'
                WHERE ordernumber = 'P2501210000927' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135124'
                WHERE ordernumber = 'P2501210000939' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395564'
                WHERE ordernumber = 'P2501210000944' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385168'
                WHERE ordernumber = 'P2501210000945' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453009'
                WHERE ordernumber = 'P2501210000956' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453010'
                WHERE ordernumber = 'P2501210000957' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453011'
                WHERE ordernumber = 'P2501210000960' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377518'
                WHERE ordernumber = 'P2501210000964' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343231'
                WHERE ordernumber = 'P2501210000966' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453014'
                WHERE ordernumber = 'P2501210000970' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453016'
                WHERE ordernumber = 'P2501210000977' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '452778'
                WHERE ordernumber = 'P2501210000992' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390103'
                WHERE ordernumber = 'P2501210000996' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368755'
                WHERE ordernumber = 'P2501210001003' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '70452'
                WHERE ordernumber = 'P2501210001011' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '447357'
                WHERE ordernumber = 'P2501210001020' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '243898'
                WHERE ordernumber = 'P2501210001024' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235486'
                WHERE ordernumber = 'P2501210001029' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453024'
                WHERE ordernumber = 'P2501210001044' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '452871'
                WHERE ordernumber = 'P2501210001058' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453025'
                WHERE ordernumber = 'P2501210001070' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214860'
                WHERE ordernumber = 'P2501210001083' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '154793'
                WHERE ordernumber = 'P2501210001086' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104047'
                WHERE ordernumber = 'P2501210001089' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287023'
                WHERE ordernumber = 'P2501210001093' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453029'
                WHERE ordernumber = 'P2501210001101' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101896'
                WHERE ordernumber = 'P2501210001107' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '162907'
                WHERE ordernumber = 'P2501210001118' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P2501210001122' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419929'
                WHERE ordernumber = 'P2501210001124' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280148'
                WHERE ordernumber = 'P2501210001129' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '119221'
                WHERE ordernumber = 'P2501210001131' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442645'
                WHERE ordernumber = 'P2501210001137' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356435'
                WHERE ordernumber = 'P2501210001142' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165326'
                WHERE ordernumber = 'P2501210001145' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238896'
                WHERE ordernumber = 'P2501210001151' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453031'
                WHERE ordernumber = 'P2501210001153' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453035'
                WHERE ordernumber = 'P2501210001165' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374936'
                WHERE ordernumber = 'P2501210001169' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453036'
                WHERE ordernumber = 'P2501210001170' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324599'
                WHERE ordernumber = 'P2501210001172' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453037'
                WHERE ordernumber = 'P2501210001175' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453038'
                WHERE ordernumber = 'P2501210001180' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425698'
                WHERE ordernumber = 'P2501210001192' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360498'
                WHERE ordernumber = 'P2501210001203' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419670'
                WHERE ordernumber = 'P2501210001205' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '87789'
                WHERE ordernumber = 'P2501210001209' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453042'
                WHERE ordernumber = 'P2501210001221' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368512'
                WHERE ordernumber = 'P2501210001225' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293336'
                WHERE ordernumber = 'P2501210001229' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383225'
                WHERE ordernumber = 'P2501210001236' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222366'
                WHERE ordernumber = 'P2501210001243' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '268709'
                WHERE ordernumber = 'P2501210001264' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453046'
                WHERE ordernumber = 'P2501210001274' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453048'
                WHERE ordernumber = 'P2501210001290' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453053'
                WHERE ordernumber = 'P2501210001292' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416212'
                WHERE ordernumber = 'P2501210001306' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2501210001312' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2501210001330' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P2501210001350' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264123'
                WHERE ordernumber = 'P2501210001355' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '448684'
                WHERE ordernumber = 'P2501210001358' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '433525'
                WHERE ordernumber = 'P2501210001359' 
            
2025-01-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453059'
                WHERE ordernumber = 'P2501210001366' 
            
2025-01-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '344468'
                WHERE ordernumber = 'P2501210001370' 
            
2025-01-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '448017'
                WHERE ordernumber = 'P2501210001372'