2024-07-03 01:00:03 -- 將會員中心id寫入data-lake
2024-07-03 01:00:03 -- 
            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-07-02%';
        
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382351'
                WHERE ordernumber = 'P630702110128745' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367263'
                WHERE ordernumber = 'P190702110516945' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283649'
                WHERE ordernumber = 'P630702110603717' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100508'
                WHERE ordernumber = 'P190702110746578' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118590'
                WHERE ordernumber = 'P190702110936727' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399345'
                WHERE ordernumber = 'P180702111016657' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255502'
                WHERE ordernumber = 'P200702111041494' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312696'
                WHERE ordernumber = 'P420702111129589' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160734'
                WHERE ordernumber = 'P200702111136742' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300891'
                WHERE ordernumber = 'P420702111502363' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396178'
                WHERE ordernumber = 'P180702111502259' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396178'
                WHERE ordernumber = 'P180702111739988' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399347'
                WHERE ordernumber = 'P420702111837570' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131857'
                WHERE ordernumber = 'P190702111928500' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396154'
                WHERE ordernumber = 'P200702112253473' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399348'
                WHERE ordernumber = 'P200702112627383' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399349'
                WHERE ordernumber = 'P420702112832574' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226592'
                WHERE ordernumber = 'P180702112932531' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129219'
                WHERE ordernumber = 'P190702113152216' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399351'
                WHERE ordernumber = 'P630702113539259' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294471'
                WHERE ordernumber = 'P190702113544788' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133248'
                WHERE ordernumber = 'P200702113629136' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399353'
                WHERE ordernumber = 'P630702114053657' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399354'
                WHERE ordernumber = 'P180702114845351' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399352'
                WHERE ordernumber = 'P630702115021824' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399356'
                WHERE ordernumber = 'P180702115245717' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391327'
                WHERE ordernumber = 'P420702115333853' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399357'
                WHERE ordernumber = 'P190702120257405' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387341'
                WHERE ordernumber = 'P180702120358332' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399359'
                WHERE ordernumber = 'P420702120445203' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399355'
                WHERE ordernumber = 'P630702121133919' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395570'
                WHERE ordernumber = 'P180702121527449' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399360'
                WHERE ordernumber = 'P630702121736475' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399361'
                WHERE ordernumber = 'P180702122145247' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105740'
                WHERE ordernumber = 'P630702122214505' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398117'
                WHERE ordernumber = 'P420702122226772' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399363'
                WHERE ordernumber = 'P200702122757257' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104419'
                WHERE ordernumber = 'P180702122847845' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305825'
                WHERE ordernumber = 'P180702123018591' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399365'
                WHERE ordernumber = 'P190702123134259' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367869'
                WHERE ordernumber = 'P180702123449587' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367871'
                WHERE ordernumber = 'P180702123540875' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399367'
                WHERE ordernumber = 'P180702123701394' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121447'
                WHERE ordernumber = 'P190702123802202' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398045'
                WHERE ordernumber = 'P180702124411802' 
            
2024-07-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398045'
                WHERE ordernumber = 'P180702124444330' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399368'
                WHERE ordernumber = 'P190702124520163' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352864'
                WHERE ordernumber = 'P420702124945695' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399369'
                WHERE ordernumber = 'P630702125035177' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399370'
                WHERE ordernumber = 'P200702125229263' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399371'
                WHERE ordernumber = 'P180702125307138' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224319'
                WHERE ordernumber = 'P200702125956852' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399372'
                WHERE ordernumber = 'P200702130937540' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314650'
                WHERE ordernumber = 'P190702131206279' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399373'
                WHERE ordernumber = 'P180702131315418' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365245'
                WHERE ordernumber = 'P420702131316561' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399374'
                WHERE ordernumber = 'P190702131350239' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399376'
                WHERE ordernumber = 'P180702132522795' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399377'
                WHERE ordernumber = 'P190702132541517' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383567'
                WHERE ordernumber = 'P180702133543922' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399379'
                WHERE ordernumber = 'P630702134031924' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399380'
                WHERE ordernumber = 'P630702134245533' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398182'
                WHERE ordernumber = 'P630702134452255' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371494'
                WHERE ordernumber = 'P590702134854373' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399382'
                WHERE ordernumber = 'P630702135452486' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358789'
                WHERE ordernumber = 'P420702135559247' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382439'
                WHERE ordernumber = 'P420702135810366' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310323'
                WHERE ordernumber = 'P200702135948615' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399383'
                WHERE ordernumber = 'P420702140009880' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371494'
                WHERE ordernumber = 'P590702140108399' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399384'
                WHERE ordernumber = 'P180702140612763' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276301'
                WHERE ordernumber = 'P180702140958503' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399386'
                WHERE ordernumber = 'P180702141115437' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399388'
                WHERE ordernumber = 'P630702141126132' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399387'
                WHERE ordernumber = 'P420702141138993' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399389'
                WHERE ordernumber = 'P420702141336875' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264978'
                WHERE ordernumber = 'P200702141339200' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399391'
                WHERE ordernumber = 'P190702141840760' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399392'
                WHERE ordernumber = 'P200702142355352' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399393'
                WHERE ordernumber = 'P190702142512281' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399395'
                WHERE ordernumber = 'P190702143509238' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P180702145431615' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396615'
                WHERE ordernumber = 'P180702145927600' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399397'
                WHERE ordernumber = 'P180702151008503' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399397'
                WHERE ordernumber = 'P180702151600789' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399399'
                WHERE ordernumber = 'P630702151742879' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370512'
                WHERE ordernumber = 'P420702151751794' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352417'
                WHERE ordernumber = 'P180702152116651' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399400'
                WHERE ordernumber = 'P190702152335681' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399401'
                WHERE ordernumber = 'P190702152519146' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399403'
                WHERE ordernumber = 'P200702153501342' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394528'
                WHERE ordernumber = 'P200702153611355' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P180702154402455' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399405'
                WHERE ordernumber = 'P190702154500748' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399406'
                WHERE ordernumber = 'P180702154945737' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96157'
                WHERE ordernumber = 'P180702155106168' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96157'
                WHERE ordernumber = 'P180702155216560' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399409'
                WHERE ordernumber = 'P180702155948863' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399350'
                WHERE ordernumber = 'P180702160337954' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342764'
                WHERE ordernumber = 'P630702160344190' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399350'
                WHERE ordernumber = 'P180702160402250' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378212'
                WHERE ordernumber = 'P180702160451572' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378212'
                WHERE ordernumber = 'P180702160522558' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247869'
                WHERE ordernumber = 'P200702160540598' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399412'
                WHERE ordernumber = 'P630702161224744' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371043'
                WHERE ordernumber = 'P630702161319800' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399413'
                WHERE ordernumber = 'P180702161541425' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277764'
                WHERE ordernumber = 'P180702161656291' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399414'
                WHERE ordernumber = 'P420702162007696' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302340'
                WHERE ordernumber = 'P180702162226668' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273534'
                WHERE ordernumber = 'P200702162517122' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273534'
                WHERE ordernumber = 'P200702162706605' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399415'
                WHERE ordernumber = 'P420702162925761' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399416'
                WHERE ordernumber = 'P180702163058177' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180702163207244' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387222'
                WHERE ordernumber = 'P180702163547865' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399417'
                WHERE ordernumber = 'P200702163620843' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237298'
                WHERE ordernumber = 'P180702164049983' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399417'
                WHERE ordernumber = 'P200702164148231' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130307'
                WHERE ordernumber = 'P630702164643919' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242404'
                WHERE ordernumber = 'P180702165248863' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399419'
                WHERE ordernumber = 'P200702165306290' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390480'
                WHERE ordernumber = 'P180702165350247' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399420'
                WHERE ordernumber = 'P630702170250269' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399421'
                WHERE ordernumber = 'P630702170840777' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399422'
                WHERE ordernumber = 'P630702171045779' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397585'
                WHERE ordernumber = 'P590702171108194' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399423'
                WHERE ordernumber = 'P180702171342592' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118619'
                WHERE ordernumber = 'P180702171948768' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379109'
                WHERE ordernumber = 'P190702172038516' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118619'
                WHERE ordernumber = 'P180702172134433' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399422'
                WHERE ordernumber = 'P630702172134804' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399424'
                WHERE ordernumber = 'P190702172213907' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399424'
                WHERE ordernumber = 'P190702172257807' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241097'
                WHERE ordernumber = 'P200702172501996' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399426'
                WHERE ordernumber = 'P630702172733365' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399427'
                WHERE ordernumber = 'P190702172821224' 
            
2024-07-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399428'
                WHERE ordernumber = 'P200702172942459' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99900'
                WHERE ordernumber = 'P200702173509855' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399429'
                WHERE ordernumber = 'P630702173533883' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399430'
                WHERE ordernumber = 'P200702173633508' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398363'
                WHERE ordernumber = 'P420702174246774' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385691'
                WHERE ordernumber = 'P190702174328578' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399432'
                WHERE ordernumber = 'P180702174356461' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390142'
                WHERE ordernumber = 'P420702174616674' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '82093'
                WHERE ordernumber = 'P180702174843962' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399434'
                WHERE ordernumber = 'P420702174939794' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '82093'
                WHERE ordernumber = 'P180702174957138' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395885'
                WHERE ordernumber = 'P420702175027771' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399435'
                WHERE ordernumber = 'P190702175031254' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302731'
                WHERE ordernumber = 'P180702175148947' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159940'
                WHERE ordernumber = 'P180702175930581' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P420702180629211' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394018'
                WHERE ordernumber = 'P200702180703653' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399438'
                WHERE ordernumber = 'P180702181006424' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P630702181257529' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390008'
                WHERE ordernumber = 'P180702181933304' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377388'
                WHERE ordernumber = 'P200702182134858' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399439'
                WHERE ordernumber = 'P420702182155301' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121245'
                WHERE ordernumber = 'P180702182947264' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347940'
                WHERE ordernumber = 'P420702183004208' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249061'
                WHERE ordernumber = 'P190702183745258' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382337'
                WHERE ordernumber = 'P180702184149482' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346979'
                WHERE ordernumber = 'P420702184312321' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347665'
                WHERE ordernumber = 'P420702184414796' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399440'
                WHERE ordernumber = 'P200702184630447' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96031'
                WHERE ordernumber = 'P190702184708951' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399441'
                WHERE ordernumber = 'P200702184759160' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208319'
                WHERE ordernumber = 'P190702184843579' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391950'
                WHERE ordernumber = 'P200702185039957' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P420702185205520' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399442'
                WHERE ordernumber = 'P190702185238716' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399443'
                WHERE ordernumber = 'P200702185613795' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398519'
                WHERE ordernumber = 'P630702185901918' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399445'
                WHERE ordernumber = 'P190702190001378' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399442'
                WHERE ordernumber = 'P190702190120226' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398347'
                WHERE ordernumber = 'P200702190804625' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399448'
                WHERE ordernumber = 'P190702191400675' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '109429'
                WHERE ordernumber = 'P190702191455194' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399449'
                WHERE ordernumber = 'P190702191753777' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '109429'
                WHERE ordernumber = 'P190702192117246' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '243898'
                WHERE ordernumber = 'P200702192452832' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200702192640765' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399451'
                WHERE ordernumber = 'P190702192715378' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347171'
                WHERE ordernumber = 'P190702193022381' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390121'
                WHERE ordernumber = 'P190702193148175' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319141'
                WHERE ordernumber = 'P200702193341920' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P200702193430870' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '320057'
                WHERE ordernumber = 'P200702193829558' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307752'
                WHERE ordernumber = 'P200702194613270' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399453'
                WHERE ordernumber = 'P200702194747793' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307328'
                WHERE ordernumber = 'P200702194830816' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357946'
                WHERE ordernumber = 'P200702194934866' 
            
2024-07-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398552'
                WHERE ordernumber = 'P630702205535996'