2023-11-27 01:00:02 -- 將會員中心id寫入data-lake
2023-11-27 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 '2023-11-26%';
        
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349376'
                WHERE ordernumber = 'P421126103155550' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349376'
                WHERE ordernumber = 'P421126103439641' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274638'
                WHERE ordernumber = 'P421126105544466' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114984'
                WHERE ordernumber = 'P191126110214700' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349379'
                WHERE ordernumber = 'P191126110350130' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '6141'
                WHERE ordernumber = 'P201126110420605' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349379'
                WHERE ordernumber = 'P191126110424498' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206727'
                WHERE ordernumber = 'P191126110936374' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349380'
                WHERE ordernumber = 'P181126111312382' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349384'
                WHERE ordernumber = 'P191126111434705' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319756'
                WHERE ordernumber = 'P181126111542748' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349385'
                WHERE ordernumber = 'P201126111622797' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349386'
                WHERE ordernumber = 'P421126111647940' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349385'
                WHERE ordernumber = 'P201126111720573' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106438'
                WHERE ordernumber = 'P191126111823559' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102429'
                WHERE ordernumber = 'P181126111827700' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349388'
                WHERE ordernumber = 'P421126112217986' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349389'
                WHERE ordernumber = 'P421126112330562' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290185'
                WHERE ordernumber = 'P421126112503831' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349390'
                WHERE ordernumber = 'P421126112611812' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275713'
                WHERE ordernumber = 'P181126112641858' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349391'
                WHERE ordernumber = 'P421126112721730' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349393'
                WHERE ordernumber = 'P421126112913954' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349394'
                WHERE ordernumber = 'P191126113337445' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324120'
                WHERE ordernumber = 'P191126113701736' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349395'
                WHERE ordernumber = 'P191126113841153' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349396'
                WHERE ordernumber = 'P191126114111588' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '161327'
                WHERE ordernumber = 'P191126114205507' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315332'
                WHERE ordernumber = 'P181126114236540' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349397'
                WHERE ordernumber = 'P191126114350865' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349396'
                WHERE ordernumber = 'P191126114440564' 
            
2023-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P191126114559761' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349399'
                WHERE ordernumber = 'P421126115517888' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209310'
                WHERE ordernumber = 'P191126115834810' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77259'
                WHERE ordernumber = 'P201126120511196' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349402'
                WHERE ordernumber = 'P191126120646330' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221484'
                WHERE ordernumber = 'P201126120836753' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298614'
                WHERE ordernumber = 'P421126121153353' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349405'
                WHERE ordernumber = 'P421126121832623' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273198'
                WHERE ordernumber = 'P421126122106952' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349407'
                WHERE ordernumber = 'P421126122906871' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349408'
                WHERE ordernumber = 'P181126122934872' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272188'
                WHERE ordernumber = 'P421126123052855' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250271'
                WHERE ordernumber = 'P181126123235842' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349409'
                WHERE ordernumber = 'P421126123356828' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349410'
                WHERE ordernumber = 'P201126123444851' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '43010'
                WHERE ordernumber = 'P201126123532678' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349411'
                WHERE ordernumber = 'P181126124149498' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302825'
                WHERE ordernumber = 'P201126124219654' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349412'
                WHERE ordernumber = 'P421126124359535' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349413'
                WHERE ordernumber = 'P421126124615794' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215833'
                WHERE ordernumber = 'P191126124823185' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267404'
                WHERE ordernumber = 'P201126125944693' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245453'
                WHERE ordernumber = 'P421126130749308' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349415'
                WHERE ordernumber = 'P191126130906595' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349416'
                WHERE ordernumber = 'P421126130954471' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348955'
                WHERE ordernumber = 'P201126131433286' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349418'
                WHERE ordernumber = 'P421126131452418' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349419'
                WHERE ordernumber = 'P191126131618551' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349420'
                WHERE ordernumber = 'P421126131816622' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349421'
                WHERE ordernumber = 'P201126131939950' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100681'
                WHERE ordernumber = 'P201126132149579' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239475'
                WHERE ordernumber = 'P191126133119662' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278811'
                WHERE ordernumber = 'P191126133343327' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349422'
                WHERE ordernumber = 'P191126134109770' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114891'
                WHERE ordernumber = 'P181126134459201' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349403'
                WHERE ordernumber = 'P181126134548952' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349403'
                WHERE ordernumber = 'P181126134626471' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349423'
                WHERE ordernumber = 'P421126134714694' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349424'
                WHERE ordernumber = 'P191126135439171' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349425'
                WHERE ordernumber = 'P191126135552134' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349426'
                WHERE ordernumber = 'P201126135750252' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245484'
                WHERE ordernumber = 'P191126135844141' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300023'
                WHERE ordernumber = 'P191126140427761' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308366'
                WHERE ordernumber = 'P421126141801247' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281863'
                WHERE ordernumber = 'P191126141909256' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349430'
                WHERE ordernumber = 'P191126142058781' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '61402'
                WHERE ordernumber = 'P191126142326770' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349433'
                WHERE ordernumber = 'P191126142629296' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116366'
                WHERE ordernumber = 'P201126142734833' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349435'
                WHERE ordernumber = 'P191126142800721' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349435'
                WHERE ordernumber = 'P181126143248819' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349438'
                WHERE ordernumber = 'P201126143759170' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P191126143905578' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349182'
                WHERE ordernumber = 'P191126143945205' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349439'
                WHERE ordernumber = 'P201126143959219' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349182'
                WHERE ordernumber = 'P191126144033880' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349440'
                WHERE ordernumber = 'P181126144550427' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349441'
                WHERE ordernumber = 'P201126144748150' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341175'
                WHERE ordernumber = 'P191126144810563' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349442'
                WHERE ordernumber = 'P201126144948557' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P181126145112244' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300855'
                WHERE ordernumber = 'P201126145127338' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349443'
                WHERE ordernumber = 'P181126145324278' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349444'
                WHERE ordernumber = 'P421126145840842' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349445'
                WHERE ordernumber = 'P181126150040623' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '78486'
                WHERE ordernumber = 'P191126150057314' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340625'
                WHERE ordernumber = 'P191126150307200' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348903'
                WHERE ordernumber = 'P181126150307359' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349448'
                WHERE ordernumber = 'P181126150822157' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106086'
                WHERE ordernumber = 'P181126150949728' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304602'
                WHERE ordernumber = 'P201126151002523' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349450'
                WHERE ordernumber = 'P181126151146424' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349451'
                WHERE ordernumber = 'P181126151415774' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349452'
                WHERE ordernumber = 'P181126151613383' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349453'
                WHERE ordernumber = 'P181126151857504' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114727'
                WHERE ordernumber = 'P201126151906198' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349454'
                WHERE ordernumber = 'P181126152241124' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349455'
                WHERE ordernumber = 'P181126152339162' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349456'
                WHERE ordernumber = 'P181126152519388' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104347'
                WHERE ordernumber = 'P201126153141137' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315886'
                WHERE ordernumber = 'P191126153423438' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349457'
                WHERE ordernumber = 'P201126153524761' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349459'
                WHERE ordernumber = 'P191126153618385' 
            
2023-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349459'
                WHERE ordernumber = 'P191126153921119' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348451'
                WHERE ordernumber = 'P201126154035548' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349460'
                WHERE ordernumber = 'P181126154448310' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349447'
                WHERE ordernumber = 'P181126154849816' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421126154851831' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349461'
                WHERE ordernumber = 'P191126154938883' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '28872'
                WHERE ordernumber = 'P421126155222414' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279465'
                WHERE ordernumber = 'P181126155302900' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76372'
                WHERE ordernumber = 'P191126155306407' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158938'
                WHERE ordernumber = 'P191126155629886' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86919'
                WHERE ordernumber = 'P181126155653599' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349463'
                WHERE ordernumber = 'P191126155934998' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155153'
                WHERE ordernumber = 'P191126160029272' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349464'
                WHERE ordernumber = 'P421126160651197' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95695'
                WHERE ordernumber = 'P201126161043218' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349465'
                WHERE ordernumber = 'P181126161320874' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349468'
                WHERE ordernumber = 'P421126161748879' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118464'
                WHERE ordernumber = 'P191126162202666' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349469'
                WHERE ordernumber = 'P201126162322448' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349471'
                WHERE ordernumber = 'P181126162423977' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349472'
                WHERE ordernumber = 'P201126162545522' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116336'
                WHERE ordernumber = 'P191126162641971' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349473'
                WHERE ordernumber = 'P181126162903872' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268128'
                WHERE ordernumber = 'P201126163247970' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244535'
                WHERE ordernumber = 'P201126163423702' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206653'
                WHERE ordernumber = 'P181126164211485' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349477'
                WHERE ordernumber = 'P421126164310930' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P201126164700290' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342482'
                WHERE ordernumber = 'P201126164742809' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349478'
                WHERE ordernumber = 'P181126164823391' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210382'
                WHERE ordernumber = 'P201126165400313' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349479'
                WHERE ordernumber = 'P421126165424187' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349480'
                WHERE ordernumber = 'P181126165526758' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P201126170640260' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349482'
                WHERE ordernumber = 'P181126171053619' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250454'
                WHERE ordernumber = 'P191126171235519' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256534'
                WHERE ordernumber = 'P201126171519698' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348640'
                WHERE ordernumber = 'P201126172158864' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349485'
                WHERE ordernumber = 'P421126172816156' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278995'
                WHERE ordernumber = 'P421126173115378' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349486'
                WHERE ordernumber = 'P421126173616814' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349481'
                WHERE ordernumber = 'P181126173756985' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349487'
                WHERE ordernumber = 'P421126174107681' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349481'
                WHERE ordernumber = 'P181126174107336' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166785'
                WHERE ordernumber = 'P181126174349636' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346356'
                WHERE ordernumber = 'P181126174810800' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230554'
                WHERE ordernumber = 'P191126175535275' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349488'
                WHERE ordernumber = 'P181126175644234' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245839'
                WHERE ordernumber = 'P191126180553503' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349489'
                WHERE ordernumber = 'P421126180855737' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346452'
                WHERE ordernumber = 'P421126181128523' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349490'
                WHERE ordernumber = 'P421126181304501' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349491'
                WHERE ordernumber = 'P191126181923620' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349492'
                WHERE ordernumber = 'P421126182112139' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349493'
                WHERE ordernumber = 'P181126183000840' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349495'
                WHERE ordernumber = 'P191126183523821' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349496'
                WHERE ordernumber = 'P191126184100686' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349497'
                WHERE ordernumber = 'P191126184255446' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349498'
                WHERE ordernumber = 'P191126184511390' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307473'
                WHERE ordernumber = 'P191126185324440' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349501'
                WHERE ordernumber = 'P191126185513716' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349502'
                WHERE ordernumber = 'P421126185556590' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '200651'
                WHERE ordernumber = 'P201126190348766' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349504'
                WHERE ordernumber = 'P191126190527923' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349505'
                WHERE ordernumber = 'P191126190656712' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349509'
                WHERE ordernumber = 'P421126192535967' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349510'
                WHERE ordernumber = 'P201126192631183' 
            
2023-11-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295570'
                WHERE ordernumber = 'P201126193956171'