2025-01-09 01:00:02 -- 將會員中心id寫入data-lake
2025-01-09 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-08%';
        
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118908'
                WHERE ordernumber = 'P2501080000011' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '20559'
                WHERE ordernumber = 'P2501080000015' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245652'
                WHERE ordernumber = 'P2501080000016' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283840'
                WHERE ordernumber = 'P2501080000018' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121148'
                WHERE ordernumber = 'P2501080000020' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112525'
                WHERE ordernumber = 'P2501080000021' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128165'
                WHERE ordernumber = 'P2501080000022' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164539'
                WHERE ordernumber = 'P2501080000025' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445778'
                WHERE ordernumber = 'P2501080000026' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '446159'
                WHERE ordernumber = 'P2501080000027' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228234'
                WHERE ordernumber = 'P2501080000029' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '91346'
                WHERE ordernumber = 'P2501080000030' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93822'
                WHERE ordernumber = 'P2501080000032' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445389'
                WHERE ordernumber = 'P2501080000037' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436804'
                WHERE ordernumber = 'P2501080000039' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '443586'
                WHERE ordernumber = 'P2501080000040' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2501080000043' 
            
2025-01-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103940'
                WHERE ordernumber = 'P2501080000044' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321160'
                WHERE ordernumber = 'P2501080000045' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2501080000048' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446166'
                WHERE ordernumber = 'P2501080000049' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209810'
                WHERE ordernumber = 'P2501080000051' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112525'
                WHERE ordernumber = 'P2501080000052' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292980'
                WHERE ordernumber = 'P2501080000054' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446167'
                WHERE ordernumber = 'P2501080000055' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424923'
                WHERE ordernumber = 'P2501080000057' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445116'
                WHERE ordernumber = 'P2501080000058' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331933'
                WHERE ordernumber = 'P2501080000062' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217809'
                WHERE ordernumber = 'P2501080000067' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125233'
                WHERE ordernumber = 'P2501080000071' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98691'
                WHERE ordernumber = 'P2501080000073' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309303'
                WHERE ordernumber = 'P2501080000074' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443303'
                WHERE ordernumber = 'P2501080000075' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367850'
                WHERE ordernumber = 'P2501080000079' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P2501080000080' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406996'
                WHERE ordernumber = 'P2501080000083' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93826'
                WHERE ordernumber = 'P2501080000084' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369716'
                WHERE ordernumber = 'P2501080000087' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270147'
                WHERE ordernumber = 'P2501080000091' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429723'
                WHERE ordernumber = 'P2501080000093' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432880'
                WHERE ordernumber = 'P2501080000106' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446192'
                WHERE ordernumber = 'P2501080000107' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446193'
                WHERE ordernumber = 'P2501080000108' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372429'
                WHERE ordernumber = 'P2501080000111' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84309'
                WHERE ordernumber = 'P2501080000112' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266330'
                WHERE ordernumber = 'P2501080000127' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306488'
                WHERE ordernumber = 'P2501080000128' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428619'
                WHERE ordernumber = 'P2501080000130' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305666'
                WHERE ordernumber = 'P2501080000131' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446203'
                WHERE ordernumber = 'P2501080000133' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366063'
                WHERE ordernumber = 'P2501080000135' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446205'
                WHERE ordernumber = 'P2501080000136' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406940'
                WHERE ordernumber = 'P2501080000141' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441078'
                WHERE ordernumber = 'P2501080000144' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416454'
                WHERE ordernumber = 'P2501080000145' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67052'
                WHERE ordernumber = 'P2501080000148' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429455'
                WHERE ordernumber = 'P2501080000150' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380214'
                WHERE ordernumber = 'P2501080000153' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446196'
                WHERE ordernumber = 'P2501080000158' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2501080000160' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446216'
                WHERE ordernumber = 'P2501080000161' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403123'
                WHERE ordernumber = 'P2501080000162' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362264'
                WHERE ordernumber = 'P2501080000163' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440131'
                WHERE ordernumber = 'P2501080000166' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421825'
                WHERE ordernumber = 'P2501080000171' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374721'
                WHERE ordernumber = 'P2501080000174' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446223'
                WHERE ordernumber = 'P2501080000175' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267133'
                WHERE ordernumber = 'P2501080000178' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446227'
                WHERE ordernumber = 'P2501080000181' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434916'
                WHERE ordernumber = 'P2501080000188' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446231'
                WHERE ordernumber = 'P2501080000190' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P2501080000197' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P2501080000198' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446235'
                WHERE ordernumber = 'P2501080000202' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96181'
                WHERE ordernumber = 'P2501080000203' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96181'
                WHERE ordernumber = 'P2501080000204' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308224'
                WHERE ordernumber = 'P2501080000208' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '28408'
                WHERE ordernumber = 'P2501080000209' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446239'
                WHERE ordernumber = 'P2501080000211' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446240'
                WHERE ordernumber = 'P2501080000213' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39552'
                WHERE ordernumber = 'P2501080000214' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268882'
                WHERE ordernumber = 'P2501080000216' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100912'
                WHERE ordernumber = 'P2501080000223' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446243'
                WHERE ordernumber = 'P2501080000224' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110093'
                WHERE ordernumber = 'P2501080000225' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315067'
                WHERE ordernumber = 'P2501080000230' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98143'
                WHERE ordernumber = 'P2501080000239' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427018'
                WHERE ordernumber = 'P2501080000241' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431154'
                WHERE ordernumber = 'P2501080000242' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435188'
                WHERE ordernumber = 'P2501080000253' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446251'
                WHERE ordernumber = 'P2501080000256' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P2501080000260' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293741'
                WHERE ordernumber = 'P2501080000263' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433202'
                WHERE ordernumber = 'P2501080000264' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107098'
                WHERE ordernumber = 'P2501080000267' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224573'
                WHERE ordernumber = 'P2501080000269' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436190'
                WHERE ordernumber = 'P2501080000270' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393726'
                WHERE ordernumber = 'P2501080000271' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136987'
                WHERE ordernumber = 'P2501080000274' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423518'
                WHERE ordernumber = 'P2501080000275' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338630'
                WHERE ordernumber = 'P2501080000277' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271544'
                WHERE ordernumber = 'P2501080000278' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429495'
                WHERE ordernumber = 'P2501080000279' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446268'
                WHERE ordernumber = 'P2501080000282' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438521'
                WHERE ordernumber = 'P2501080000284' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446272'
                WHERE ordernumber = 'P2501080000287' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446274'
                WHERE ordernumber = 'P2501080000289' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79636'
                WHERE ordernumber = 'P2501080000290' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446276'
                WHERE ordernumber = 'P2501080000294' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356223'
                WHERE ordernumber = 'P2501080000296' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92619'
                WHERE ordernumber = 'P2501080000297' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431070'
                WHERE ordernumber = 'P2501080000305' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275260'
                WHERE ordernumber = 'P2501080000307' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278555'
                WHERE ordernumber = 'P2501080000308' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138472'
                WHERE ordernumber = 'P2501080000310' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306735'
                WHERE ordernumber = 'P2501080000312' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364701'
                WHERE ordernumber = 'P2501080000314' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79636'
                WHERE ordernumber = 'P2501080000318' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446287'
                WHERE ordernumber = 'P2501080000329' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446287'
                WHERE ordernumber = 'P2501080000330' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421647'
                WHERE ordernumber = 'P2501080000332' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232847'
                WHERE ordernumber = 'P2501080000333' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446286'
                WHERE ordernumber = 'P2501080000334' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240470'
                WHERE ordernumber = 'P2501080000341' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380346'
                WHERE ordernumber = 'P2501080000346' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160932'
                WHERE ordernumber = 'P2501080000362' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446298'
                WHERE ordernumber = 'P2501080000364' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431916'
                WHERE ordernumber = 'P2501080000367' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125914'
                WHERE ordernumber = 'P2501080000368' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297229'
                WHERE ordernumber = 'P2501080000369' 
            
2025-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446305'
                WHERE ordernumber = 'P2501080000370' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327626'
                WHERE ordernumber = 'P2501080000374' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397939'
                WHERE ordernumber = 'P2501080000376' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311612'
                WHERE ordernumber = 'P2501080000378' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403479'
                WHERE ordernumber = 'P2501080000379' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102258'
                WHERE ordernumber = 'P2501080000381' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446307'
                WHERE ordernumber = 'P2501080000385' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442990'
                WHERE ordernumber = 'P2501080000389' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387508'
                WHERE ordernumber = 'P2501080000391' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272989'
                WHERE ordernumber = 'P2501080000395' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '194776'
                WHERE ordernumber = 'P2501080000397' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353726'
                WHERE ordernumber = 'P2501080000398' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435090'
                WHERE ordernumber = 'P2501080000399' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446312'
                WHERE ordernumber = 'P2501080000404' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394487'
                WHERE ordernumber = 'P2501080000405' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95037'
                WHERE ordernumber = 'P2501080000408' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446314'
                WHERE ordernumber = 'P2501080000410' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108999'
                WHERE ordernumber = 'P2501080000412' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330853'
                WHERE ordernumber = 'P2501080000417' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446315'
                WHERE ordernumber = 'P2501080000420' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252377'
                WHERE ordernumber = 'P2501080000422' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132597'
                WHERE ordernumber = 'P2501080000429' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437852'
                WHERE ordernumber = 'P2501080000433' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96089'
                WHERE ordernumber = 'P2501080000435' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446321'
                WHERE ordernumber = 'P2501080000436' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96089'
                WHERE ordernumber = 'P2501080000437' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446323'
                WHERE ordernumber = 'P2501080000444' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407516'
                WHERE ordernumber = 'P2501080000447' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '201629'
                WHERE ordernumber = 'P2501080000455' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96012'
                WHERE ordernumber = 'P2501080000457' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446328'
                WHERE ordernumber = 'P2501080000461' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446326'
                WHERE ordernumber = 'P2501080000462' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446331'
                WHERE ordernumber = 'P2501080000463' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259275'
                WHERE ordernumber = 'P2501080000468' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286847'
                WHERE ordernumber = 'P2501080000469' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173533'
                WHERE ordernumber = 'P2501080000475' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269590'
                WHERE ordernumber = 'P2501080000476' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297053'
                WHERE ordernumber = 'P2501080000480' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217445'
                WHERE ordernumber = 'P2501080000482' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446342'
                WHERE ordernumber = 'P2501080000494' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446339'
                WHERE ordernumber = 'P2501080000495' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105869'
                WHERE ordernumber = 'P2501080000504' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346312'
                WHERE ordernumber = 'P2501080000506' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138433'
                WHERE ordernumber = 'P2501080000514' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441376'
                WHERE ordernumber = 'P2501080000516' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446345'
                WHERE ordernumber = 'P2501080000518' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446349'
                WHERE ordernumber = 'P2501080000527' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439990'
                WHERE ordernumber = 'P2501080000528' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272857'
                WHERE ordernumber = 'P2501080000531' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439331'
                WHERE ordernumber = 'P2501080000534' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '16439'
                WHERE ordernumber = 'P2501080000536' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441993'
                WHERE ordernumber = 'P2501080000540' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306320'
                WHERE ordernumber = 'P2501080000542' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446352'
                WHERE ordernumber = 'P2501080000543' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301938'
                WHERE ordernumber = 'P2501080000546' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446353'
                WHERE ordernumber = 'P2501080000547' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354790'
                WHERE ordernumber = 'P2501080000551' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93423'
                WHERE ordernumber = 'P2501080000556' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374706'
                WHERE ordernumber = 'P2501080000562' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446358'
                WHERE ordernumber = 'P2501080000564' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442146'
                WHERE ordernumber = 'P2501080000565' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446359'
                WHERE ordernumber = 'P2501080000566' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232498'
                WHERE ordernumber = 'P2501080000568' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97768'
                WHERE ordernumber = 'P2501080000572' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446360'
                WHERE ordernumber = 'P2501080000575' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299626'
                WHERE ordernumber = 'P2501080000580' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446367'
                WHERE ordernumber = 'P2501080000581' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376827'
                WHERE ordernumber = 'P2501080000582' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446368'
                WHERE ordernumber = 'P2501080000583' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446371'
                WHERE ordernumber = 'P2501080000586' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280432'
                WHERE ordernumber = 'P2501080000588' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446273'
                WHERE ordernumber = 'P2501080000589' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446375'
                WHERE ordernumber = 'P2501080000593' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446379'
                WHERE ordernumber = 'P2501080000600' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160799'
                WHERE ordernumber = 'P2501080000603' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446380'
                WHERE ordernumber = 'P2501080000605' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380886'
                WHERE ordernumber = 'P2501080000612' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384019'
                WHERE ordernumber = 'P2501080000614' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P2501080000615' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379086'
                WHERE ordernumber = 'P2501080000616' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278762'
                WHERE ordernumber = 'P2501080000617' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446384'
                WHERE ordernumber = 'P2501080000618' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305804'
                WHERE ordernumber = 'P2501080000619' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446389'
                WHERE ordernumber = 'P2501080000634' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165412'
                WHERE ordernumber = 'P2501080000635' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266547'
                WHERE ordernumber = 'P2501080000639' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245514'
                WHERE ordernumber = 'P2501080000640' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314813'
                WHERE ordernumber = 'P2501080000641' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446392'
                WHERE ordernumber = 'P2501080000642' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446396'
                WHERE ordernumber = 'P2501080000645' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446399'
                WHERE ordernumber = 'P2501080000655' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314813'
                WHERE ordernumber = 'P2501080000657' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446398'
                WHERE ordernumber = 'P2501080000659' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285070'
                WHERE ordernumber = 'P2501080000667' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446402'
                WHERE ordernumber = 'P2501080000669' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446404'
                WHERE ordernumber = 'P2501080000672' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296741'
                WHERE ordernumber = 'P2501080000674' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446405'
                WHERE ordernumber = 'P2501080000676' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353594'
                WHERE ordernumber = 'P2501080000678' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102863'
                WHERE ordernumber = 'P2501080000679' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247091'
                WHERE ordernumber = 'P2501080000688' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386162'
                WHERE ordernumber = 'P2501080000694' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446415'
                WHERE ordernumber = 'P2501080000696' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357129'
                WHERE ordernumber = 'P2501080000697' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446417'
                WHERE ordernumber = 'P2501080000700' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446418'
                WHERE ordernumber = 'P2501080000701' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421825'
                WHERE ordernumber = 'P2501080000713' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446423'
                WHERE ordernumber = 'P2501080000723' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436266'
                WHERE ordernumber = 'P2501080000726' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396684'
                WHERE ordernumber = 'P2501080000727' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446425'
                WHERE ordernumber = 'P2501080000728' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352798'
                WHERE ordernumber = 'P2501080000729' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436942'
                WHERE ordernumber = 'P2501080000730' 
            
2025-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353594'
                WHERE ordernumber = 'P2501080000732' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375109'
                WHERE ordernumber = 'P2501080000737' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445847'
                WHERE ordernumber = 'P2501080000740' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350243'
                WHERE ordernumber = 'P2501080000741' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430235'
                WHERE ordernumber = 'P2501080000743' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445877'
                WHERE ordernumber = 'P2501080000744' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167359'
                WHERE ordernumber = 'P2501080000747' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '446433'
                WHERE ordernumber = 'P2501080000748' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437471'
                WHERE ordernumber = 'P2501080000749' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211568'
                WHERE ordernumber = 'P2501080000753' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '446436'
                WHERE ordernumber = 'P2501080000755' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '438077'
                WHERE ordernumber = 'P2501080000758' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213825'
                WHERE ordernumber = 'P2501080000760' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415478'
                WHERE ordernumber = 'P2501080000775' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '85633'
                WHERE ordernumber = 'P2501080000783' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279446'
                WHERE ordernumber = 'P2501080000792' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364719'
                WHERE ordernumber = 'P2501080000794' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '446444'
                WHERE ordernumber = 'P2501080000795' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173328'
                WHERE ordernumber = 'P2501080000797' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346687'
                WHERE ordernumber = 'P2501080000800' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '49345'
                WHERE ordernumber = 'P2501080000802' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '446445'
                WHERE ordernumber = 'P2501080000806' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '446446'
                WHERE ordernumber = 'P2501080000808' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255173'
                WHERE ordernumber = 'P2501080000809' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '446447'
                WHERE ordernumber = 'P2501080000811' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '446449'
                WHERE ordernumber = 'P2501080000815' 
            
2025-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298268'
                WHERE ordernumber = 'P2501080000829'