2024-12-10 01:00:02 -- 將會員中心id寫入data-lake
2024-12-10 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 '2024-12-09%';
        
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276730'
                WHERE ordernumber = 'P2412090000199' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434214'
                WHERE ordernumber = 'P2412090000225' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434216'
                WHERE ordernumber = 'P2412090000491' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P2412090000571' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2412090000659' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434217'
                WHERE ordernumber = 'P2412090000740' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251872'
                WHERE ordernumber = 'P2412090001093' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245116'
                WHERE ordernumber = 'P2412090001321' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431858'
                WHERE ordernumber = 'P2412090001588' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111148'
                WHERE ordernumber = 'P2412090001772' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258282'
                WHERE ordernumber = 'P2412090001897' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111148'
                WHERE ordernumber = 'P2412090001980' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258282'
                WHERE ordernumber = 'P2412090002191' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434221'
                WHERE ordernumber = 'P2412090002487' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434222'
                WHERE ordernumber = 'P2412090002523' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P2412090002659' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397802'
                WHERE ordernumber = 'P2412090002914' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434224'
                WHERE ordernumber = 'P2412090003092' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296784'
                WHERE ordernumber = 'P2412090003173' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434230'
                WHERE ordernumber = 'P2412090003292' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434226'
                WHERE ordernumber = 'P2412090003370' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434231'
                WHERE ordernumber = 'P2412090003547' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414529'
                WHERE ordernumber = 'P2412090004077' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434234'
                WHERE ordernumber = 'P2412090004486' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302798'
                WHERE ordernumber = 'P2412090004661' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434236'
                WHERE ordernumber = 'P2412090004778' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434237'
                WHERE ordernumber = 'P2412090004898' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434235'
                WHERE ordernumber = 'P2412090004932' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289355'
                WHERE ordernumber = 'P2412090005032' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434238'
                WHERE ordernumber = 'P2412090005171' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '29434'
                WHERE ordernumber = 'P2412090005246' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421919'
                WHERE ordernumber = 'P2412090005315' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342844'
                WHERE ordernumber = 'P2412090005440' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434239'
                WHERE ordernumber = 'P2412090005564' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162229'
                WHERE ordernumber = 'P2412090005766' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162229'
                WHERE ordernumber = 'P2412090005820' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315852'
                WHERE ordernumber = 'P2412090005930' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434241'
                WHERE ordernumber = 'P2412090006254' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434243'
                WHERE ordernumber = 'P2412090006350' 
            
2024-12-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417811'
                WHERE ordernumber = 'P2412090006457' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434244'
                WHERE ordernumber = 'P2412090006512' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434245'
                WHERE ordernumber = 'P2412090006715' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404754'
                WHERE ordernumber = 'P2412090006870' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402518'
                WHERE ordernumber = 'P2412090006936' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144007'
                WHERE ordernumber = 'P2412090007081' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92631'
                WHERE ordernumber = 'P2412090007198' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434248'
                WHERE ordernumber = 'P2412090007315' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104898'
                WHERE ordernumber = 'P2412090007571' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428572'
                WHERE ordernumber = 'P2412090007675' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434250'
                WHERE ordernumber = 'P2412090007752' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52558'
                WHERE ordernumber = 'P2412090007851' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221616'
                WHERE ordernumber = 'P2412090007927' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434255'
                WHERE ordernumber = 'P2412090009215' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273181'
                WHERE ordernumber = 'P2412090009328' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428293'
                WHERE ordernumber = 'P2412090009526' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434258'
                WHERE ordernumber = 'P2412090009962' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434261'
                WHERE ordernumber = 'P2412090010253' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434262'
                WHERE ordernumber = 'P2412090010557' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433418'
                WHERE ordernumber = 'P2412090011016' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412493'
                WHERE ordernumber = 'P2412090011187' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268774'
                WHERE ordernumber = 'P2412090011223' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357924'
                WHERE ordernumber = 'P2412090011716' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281382'
                WHERE ordernumber = 'P2412090011828' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434267'
                WHERE ordernumber = 'P2412090011922' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434268'
                WHERE ordernumber = 'P2412090012164' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434269'
                WHERE ordernumber = 'P2412090012250' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434270'
                WHERE ordernumber = 'P2412090012342' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345715'
                WHERE ordernumber = 'P2412090012416' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P2412090012641' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434273'
                WHERE ordernumber = 'P2412090012861' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434274'
                WHERE ordernumber = 'P2412090013031' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312978'
                WHERE ordernumber = 'P2412090013249' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434275'
                WHERE ordernumber = 'P2412090013338' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110416'
                WHERE ordernumber = 'P2412090013474' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434278'
                WHERE ordernumber = 'P2412090013540' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348897'
                WHERE ordernumber = 'P2412090013682' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301943'
                WHERE ordernumber = 'P2412090013788' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434276'
                WHERE ordernumber = 'P2412090013840' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '43401'
                WHERE ordernumber = 'P2412090013948' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340663'
                WHERE ordernumber = 'P2412090014113' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434283'
                WHERE ordernumber = 'P2412090014335' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434284'
                WHERE ordernumber = 'P2412090014567' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434285'
                WHERE ordernumber = 'P2412090014618' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230861'
                WHERE ordernumber = 'P2412090014828' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434288'
                WHERE ordernumber = 'P2412090014995' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434290'
                WHERE ordernumber = 'P2412090015097' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434281'
                WHERE ordernumber = 'P2412090015134' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434289'
                WHERE ordernumber = 'P2412090015326' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434277'
                WHERE ordernumber = 'P2412090015423' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434291'
                WHERE ordernumber = 'P2412090015635' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432421'
                WHERE ordernumber = 'P2412090015765' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433374'
                WHERE ordernumber = 'P2412090015881' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379868'
                WHERE ordernumber = 'P2412090016057' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411469'
                WHERE ordernumber = 'P2412090016160' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434292'
                WHERE ordernumber = 'P2412090016391' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434302'
                WHERE ordernumber = 'P2412090016443' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434294'
                WHERE ordernumber = 'P2412090016620' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434298'
                WHERE ordernumber = 'P2412090016892' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434300'
                WHERE ordernumber = 'P2412090016923' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434305'
                WHERE ordernumber = 'P2412090017061' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434306'
                WHERE ordernumber = 'P2412090017159' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434306'
                WHERE ordernumber = 'P2412090017228' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74753'
                WHERE ordernumber = 'P2412090017351' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334332'
                WHERE ordernumber = 'P2412090017473' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96922'
                WHERE ordernumber = 'P2412090017591' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434309'
                WHERE ordernumber = 'P2412090017736' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384130'
                WHERE ordernumber = 'P2412090017853' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206405'
                WHERE ordernumber = 'P2412090018097' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430351'
                WHERE ordernumber = 'P2412090018159' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392888'
                WHERE ordernumber = 'P2412090018275' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434313'
                WHERE ordernumber = 'P2412090018498' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351997'
                WHERE ordernumber = 'P2412090018627' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425106'
                WHERE ordernumber = 'P2412090018824' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434315'
                WHERE ordernumber = 'P2412090018929' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429060'
                WHERE ordernumber = 'P2412090019059' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434315'
                WHERE ordernumber = 'P2412090019119' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110093'
                WHERE ordernumber = 'P2412090019243' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351009'
                WHERE ordernumber = 'P2412090019360' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2412090019513' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434318'
                WHERE ordernumber = 'P2412090019936' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353333'
                WHERE ordernumber = 'P2412090020620' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217626'
                WHERE ordernumber = 'P2412090020710' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424291'
                WHERE ordernumber = 'P2412090020859' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430660'
                WHERE ordernumber = 'P2412090020920' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77954'
                WHERE ordernumber = 'P2412090021138' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P2412090021256' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127955'
                WHERE ordernumber = 'P2412090021459' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431989'
                WHERE ordernumber = 'P2412090021622' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434070'
                WHERE ordernumber = 'P2412090021723' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434112'
                WHERE ordernumber = 'P2412090021931' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104451'
                WHERE ordernumber = 'P2412090022223' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434323'
                WHERE ordernumber = 'P2412090022337' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434325'
                WHERE ordernumber = 'P2412090022490' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434326'
                WHERE ordernumber = 'P2412090022511' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248384'
                WHERE ordernumber = 'P2412090022711' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434328'
                WHERE ordernumber = 'P2412090022840' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434329'
                WHERE ordernumber = 'P2412090022926' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294656'
                WHERE ordernumber = 'P2412090023055' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434330'
                WHERE ordernumber = 'P2412090023129' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434330'
                WHERE ordernumber = 'P2412090023271' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434331'
                WHERE ordernumber = 'P2412090023386' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434332'
                WHERE ordernumber = 'P2412090023469' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341791'
                WHERE ordernumber = 'P2412090023549' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341057'
                WHERE ordernumber = 'P2412090023693' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257951'
                WHERE ordernumber = 'P2412090023732' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P2412090024258' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434337'
                WHERE ordernumber = 'P2412090024327' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135049'
                WHERE ordernumber = 'P2412090024510' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434341'
                WHERE ordernumber = 'P2412090024662' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434342'
                WHERE ordernumber = 'P2412090024991' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62713'
                WHERE ordernumber = 'P2412090025269' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434350'
                WHERE ordernumber = 'P2412090025655' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434348'
                WHERE ordernumber = 'P2412090025792' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221131'
                WHERE ordernumber = 'P2412090025899' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241583'
                WHERE ordernumber = 'P2412090026029' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433219'
                WHERE ordernumber = 'P2412090026281' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238000'
                WHERE ordernumber = 'P2412090026317' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434353'
                WHERE ordernumber = 'P2412090026576' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349116'
                WHERE ordernumber = 'P2412090026687' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122395'
                WHERE ordernumber = 'P2412090026957' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149491'
                WHERE ordernumber = 'P2412090027069' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434358'
                WHERE ordernumber = 'P2412090027275' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434360'
                WHERE ordernumber = 'P2412090027331' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434359'
                WHERE ordernumber = 'P2412090027485' 
            
2024-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408735'
                WHERE ordernumber = 'P2412090027725' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239096'
                WHERE ordernumber = 'P2412090027978' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434361'
                WHERE ordernumber = 'P2412090028297' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434362'
                WHERE ordernumber = 'P2412090028332' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166939'
                WHERE ordernumber = 'P2412090028814' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434364'
                WHERE ordernumber = 'P2412090028925' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166939'
                WHERE ordernumber = 'P2412090029039' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434365'
                WHERE ordernumber = 'P2412090029483' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105404'
                WHERE ordernumber = 'P2412090029510' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434372'
                WHERE ordernumber = 'P2412090030052' 
            
2024-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314044'
                WHERE ordernumber = 'P2412090030135'