2024-06-21 01:00:02 -- 將會員中心id寫入data-lake
2024-06-21 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-06-20%';
        
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396872'
                WHERE ordernumber = 'P630620102226669' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332122'
                WHERE ordernumber = 'P630620104050494' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420620110109455' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137430'
                WHERE ordernumber = 'P200620110257945' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137430'
                WHERE ordernumber = 'P200620110359652' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396875'
                WHERE ordernumber = 'P180620110453569' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396876'
                WHERE ordernumber = 'P420620110522449' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396877'
                WHERE ordernumber = 'P200620110619423' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209274'
                WHERE ordernumber = 'P180620110636950' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209274'
                WHERE ordernumber = 'P180620110717882' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347603'
                WHERE ordernumber = 'P200620110727435' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368589'
                WHERE ordernumber = 'P420620110734413' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347603'
                WHERE ordernumber = 'P200620110855632' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '117265'
                WHERE ordernumber = 'P180620110945286' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389538'
                WHERE ordernumber = 'P420620111043919' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396879'
                WHERE ordernumber = 'P630620111110249' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396878'
                WHERE ordernumber = 'P190620111131702' 
            
2024-06-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339238'
                WHERE ordernumber = 'P190620111318729' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102227'
                WHERE ordernumber = 'P180620111531682' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396881'
                WHERE ordernumber = 'P200620111907132' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396877'
                WHERE ordernumber = 'P200620112001436' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396882'
                WHERE ordernumber = 'P420620112055386' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313761'
                WHERE ordernumber = 'P200620112130648' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109248'
                WHERE ordernumber = 'P180620112548183' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382156'
                WHERE ordernumber = 'P420620112742957' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302708'
                WHERE ordernumber = 'P190620112922784' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396884'
                WHERE ordernumber = 'P180620112929363' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396885'
                WHERE ordernumber = 'P420620113022522' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296424'
                WHERE ordernumber = 'P200620113705639' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396888'
                WHERE ordernumber = 'P180620114050432' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396887'
                WHERE ordernumber = 'P180620114334428' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396889'
                WHERE ordernumber = 'P420620114517267' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420620114901523' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396891'
                WHERE ordernumber = 'P180620115021654' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396892'
                WHERE ordernumber = 'P190620115202551' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380931'
                WHERE ordernumber = 'P180620115300654' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396894'
                WHERE ordernumber = 'P630620120012675' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396895'
                WHERE ordernumber = 'P200620120147679' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396896'
                WHERE ordernumber = 'P180620120217990' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '197429'
                WHERE ordernumber = 'P190620120311273' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296882'
                WHERE ordernumber = 'P180620120320545' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162716'
                WHERE ordernumber = 'P190620120518379' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396897'
                WHERE ordernumber = 'P200620120641888' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156313'
                WHERE ordernumber = 'P190620120902309' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231755'
                WHERE ordernumber = 'P190620120956812' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396898'
                WHERE ordernumber = 'P200620121744577' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396899'
                WHERE ordernumber = 'P420620121748516' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389004'
                WHERE ordernumber = 'P180620122132246' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396900'
                WHERE ordernumber = 'P590620122214245' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396901'
                WHERE ordernumber = 'P630620122630722' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396902'
                WHERE ordernumber = 'P780620122758748' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106080'
                WHERE ordernumber = 'P630620122810563' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396903'
                WHERE ordernumber = 'P630620123006274' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396904'
                WHERE ordernumber = 'P200620123337417' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94161'
                WHERE ordernumber = 'P180620123408319' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389934'
                WHERE ordernumber = 'P420620123837271' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396905'
                WHERE ordernumber = 'P630620124043124' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396906'
                WHERE ordernumber = 'P780620124319185' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388083'
                WHERE ordernumber = 'P180620124546406' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396907'
                WHERE ordernumber = 'P200620125220270' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396908'
                WHERE ordernumber = 'P630620125609538' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P180620125935201' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396910'
                WHERE ordernumber = 'P630620130113519' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396911'
                WHERE ordernumber = 'P200620130200156' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P180620130213973' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396912'
                WHERE ordernumber = 'P630620130431638' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396913'
                WHERE ordernumber = 'P630620130604531' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396914'
                WHERE ordernumber = 'P630620130757252' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382983'
                WHERE ordernumber = 'P180620130853479' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396915'
                WHERE ordernumber = 'P630620130915131' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396916'
                WHERE ordernumber = 'P590620131059848' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395158'
                WHERE ordernumber = 'P420620131355388' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158028'
                WHERE ordernumber = 'P180620131429351' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396918'
                WHERE ordernumber = 'P190620131456595' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396917'
                WHERE ordernumber = 'P630620131510641' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209740'
                WHERE ordernumber = 'P180620131612860' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143159'
                WHERE ordernumber = 'P200620131623865' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396919'
                WHERE ordernumber = 'P630620131647762' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388085'
                WHERE ordernumber = 'P200620131852802' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258479'
                WHERE ordernumber = 'P200620131947219' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396920'
                WHERE ordernumber = 'P180620132258593' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396922'
                WHERE ordernumber = 'P630620132427430' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396924'
                WHERE ordernumber = 'P200620132617317' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396925'
                WHERE ordernumber = 'P180620132643664' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268794'
                WHERE ordernumber = 'P200620132940225' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396926'
                WHERE ordernumber = 'P180620132946473' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171657'
                WHERE ordernumber = 'P200620133053640' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396927'
                WHERE ordernumber = 'P630620133058896' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396928'
                WHERE ordernumber = 'P180620133336899' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '24108'
                WHERE ordernumber = 'P590620133411670' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391449'
                WHERE ordernumber = 'P200620133521638' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396930'
                WHERE ordernumber = 'P180620133605699' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396931'
                WHERE ordernumber = 'P200620133641877' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115459'
                WHERE ordernumber = 'P200620133740687' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310414'
                WHERE ordernumber = 'P180620133747538' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396932'
                WHERE ordernumber = 'P780620133836355' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396933'
                WHERE ordernumber = 'P630620134428383' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396934'
                WHERE ordernumber = 'P420620134608889' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396935'
                WHERE ordernumber = 'P630620134634415' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396454'
                WHERE ordernumber = 'P180620134839135' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396936'
                WHERE ordernumber = 'P630620134955839' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396871'
                WHERE ordernumber = 'P200620135056589' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396873'
                WHERE ordernumber = 'P200620135251256' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396937'
                WHERE ordernumber = 'P630620135510395' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306059'
                WHERE ordernumber = 'P200620135534587' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396941'
                WHERE ordernumber = 'P630620135837795' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396939'
                WHERE ordernumber = 'P780620135853479' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396940'
                WHERE ordernumber = 'P420620135854917' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396942'
                WHERE ordernumber = 'P420620140114581' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396893'
                WHERE ordernumber = 'P180620140153254' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396943'
                WHERE ordernumber = 'P590620140306882' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394564'
                WHERE ordernumber = 'P420620140348116' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343509'
                WHERE ordernumber = 'P180620140947409' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159019'
                WHERE ordernumber = 'P190620141103636' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396944'
                WHERE ordernumber = 'P780620141238152' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396633'
                WHERE ordernumber = 'P190620141527582' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396946'
                WHERE ordernumber = 'P630620142037352' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349837'
                WHERE ordernumber = 'P180620142438802' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396948'
                WHERE ordernumber = 'P630620143146338' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378442'
                WHERE ordernumber = 'P420620143333196' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108873'
                WHERE ordernumber = 'P180620143401598' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396949'
                WHERE ordernumber = 'P420620143448881' 
            
2024-06-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396950'
                WHERE ordernumber = 'P200620143939219' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342303'
                WHERE ordernumber = 'P180620144127502' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396951'
                WHERE ordernumber = 'P200620144522672' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364538'
                WHERE ordernumber = 'P420620144542932' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396952'
                WHERE ordernumber = 'P200620144649979' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396954'
                WHERE ordernumber = 'P190620145249977' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396955'
                WHERE ordernumber = 'P420620145309204' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328319'
                WHERE ordernumber = 'P180620145324760' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396956'
                WHERE ordernumber = 'P420620145422726' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396957'
                WHERE ordernumber = 'P630620145621134' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158393'
                WHERE ordernumber = 'P420620150020127' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166785'
                WHERE ordernumber = 'P180620150955781' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125914'
                WHERE ordernumber = 'P190620151044634' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396959'
                WHERE ordernumber = 'P180620151252669' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135831'
                WHERE ordernumber = 'P420620151402867' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396960'
                WHERE ordernumber = 'P180620151520279' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396961'
                WHERE ordernumber = 'P630620151621880' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396962'
                WHERE ordernumber = 'P780620151926117' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387202'
                WHERE ordernumber = 'P630620151937818' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396963'
                WHERE ordernumber = 'P200620151950306' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396964'
                WHERE ordernumber = 'P420620152102606' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389153'
                WHERE ordernumber = 'P200620153305785' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396965'
                WHERE ordernumber = 'P420620153728522' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391279'
                WHERE ordernumber = 'P180620153813371' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396966'
                WHERE ordernumber = 'P590620153935696' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391279'
                WHERE ordernumber = 'P180620153937965' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216932'
                WHERE ordernumber = 'P420620154011145' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396967'
                WHERE ordernumber = 'P180620154106628' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396968'
                WHERE ordernumber = 'P180620154336473' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360140'
                WHERE ordernumber = 'P420620154339831' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250500'
                WHERE ordernumber = 'P420620154448734' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396970'
                WHERE ordernumber = 'P420620154721824' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30941'
                WHERE ordernumber = 'P180620155106222' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396971'
                WHERE ordernumber = 'P420620155256711' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315426'
                WHERE ordernumber = 'P630620155307909' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396972'
                WHERE ordernumber = 'P420620155828289' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307996'
                WHERE ordernumber = 'P180620155902599' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30941'
                WHERE ordernumber = 'P180620160049982' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396973'
                WHERE ordernumber = 'P200620160206126' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395399'
                WHERE ordernumber = 'P180620160306370' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396975'
                WHERE ordernumber = 'P180620160611322' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396974'
                WHERE ordernumber = 'P590620160723608' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396976'
                WHERE ordernumber = 'P780620160917184' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254478'
                WHERE ordernumber = 'P190620161016304' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396977'
                WHERE ordernumber = 'P420620161200222' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '83504'
                WHERE ordernumber = 'P190620161231967' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381315'
                WHERE ordernumber = 'P420620161327420' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396978'
                WHERE ordernumber = 'P590620161408111' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396979'
                WHERE ordernumber = 'P630620161441632' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396981'
                WHERE ordernumber = 'P630620161524295' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396982'
                WHERE ordernumber = 'P180620161600427' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396983'
                WHERE ordernumber = 'P420620161818569' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396985'
                WHERE ordernumber = 'P180620162015785' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134058'
                WHERE ordernumber = 'P180620162129259' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396986'
                WHERE ordernumber = 'P180620162622928' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396987'
                WHERE ordernumber = 'P780620162740886' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396884'
                WHERE ordernumber = 'P180620162911600' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396988'
                WHERE ordernumber = 'P200620163020300' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396989'
                WHERE ordernumber = 'P780620163333294' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396991'
                WHERE ordernumber = 'P180620163403915' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396992'
                WHERE ordernumber = 'P190620163431492' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396990'
                WHERE ordernumber = 'P590620163449224' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135248'
                WHERE ordernumber = 'P630620163618298' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396993'
                WHERE ordernumber = 'P190620163813187' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396994'
                WHERE ordernumber = 'P180620164036172' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396700'
                WHERE ordernumber = 'P190620164409347' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396908'
                WHERE ordernumber = 'P630620164448701' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396995'
                WHERE ordernumber = 'P200620164520139' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95037'
                WHERE ordernumber = 'P180620164710263' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389530'
                WHERE ordernumber = 'P190620164757355' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396997'
                WHERE ordernumber = 'P180620165118273' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349313'
                WHERE ordernumber = 'P200620165259941' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396998'
                WHERE ordernumber = 'P590620165529729' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233617'
                WHERE ordernumber = 'P180620165728268' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '191479'
                WHERE ordernumber = 'P180620165817740' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392504'
                WHERE ordernumber = 'P200620165908697' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382734'
                WHERE ordernumber = 'P180620170111886' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81603'
                WHERE ordernumber = 'P180620170309849' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396999'
                WHERE ordernumber = 'P420620170749622' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250457'
                WHERE ordernumber = 'P200620171316136' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221426'
                WHERE ordernumber = 'P190620171348941' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160799'
                WHERE ordernumber = 'P200620171405613' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81674'
                WHERE ordernumber = 'P180620171418951' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397000'
                WHERE ordernumber = 'P630620171438961' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360180'
                WHERE ordernumber = 'P200620171751560' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397001'
                WHERE ordernumber = 'P780620171828296' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258844'
                WHERE ordernumber = 'P180620172106285' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397002'
                WHERE ordernumber = 'P780620172145878' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301671'
                WHERE ordernumber = 'P180620172234805' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '65597'
                WHERE ordernumber = 'P200620172551757' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397003'
                WHERE ordernumber = 'P630620172653435' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218749'
                WHERE ordernumber = 'P180620172836281' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290667'
                WHERE ordernumber = 'P180620172959677' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137620'
                WHERE ordernumber = 'P180620173203352' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127298'
                WHERE ordernumber = 'P420620173249440' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397004'
                WHERE ordernumber = 'P420620173434191' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374299'
                WHERE ordernumber = 'P180620173445186' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P420620173546901' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397006'
                WHERE ordernumber = 'P190620173824668' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397006'
                WHERE ordernumber = 'P190620173933124' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397005'
                WHERE ordernumber = 'P630620174003121' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397007'
                WHERE ordernumber = 'P180620174157218' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397008'
                WHERE ordernumber = 'P200620174346257' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397010'
                WHERE ordernumber = 'P780620174709694' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397011'
                WHERE ordernumber = 'P190620174747961' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397009'
                WHERE ordernumber = 'P200620174824458' 
            
2024-06-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397009'
                WHERE ordernumber = 'P200620174827829' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397012'
                WHERE ordernumber = 'P200620175135856' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '332511'
                WHERE ordernumber = 'P190620175238279' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229200'
                WHERE ordernumber = 'P180620175347123' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397013'
                WHERE ordernumber = 'P420620175348111' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396865'
                WHERE ordernumber = 'P630620175352990' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263110'
                WHERE ordernumber = 'P200620175733458' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263110'
                WHERE ordernumber = 'P200620175811487' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389353'
                WHERE ordernumber = 'P630620180122584' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385168'
                WHERE ordernumber = 'P200620180422637' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397015'
                WHERE ordernumber = 'P630620180505783' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113109'
                WHERE ordernumber = 'P190620180623805' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347544'
                WHERE ordernumber = 'P180620180645194' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397016'
                WHERE ordernumber = 'P420620180645722' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397017'
                WHERE ordernumber = 'P200620180735618' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397018'
                WHERE ordernumber = 'P630620181315717' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '370022'
                WHERE ordernumber = 'P590620181538264' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312873'
                WHERE ordernumber = 'P200620181642784' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312873'
                WHERE ordernumber = 'P200620182125665' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395180'
                WHERE ordernumber = 'P180620182136301' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '158272'
                WHERE ordernumber = 'P420620182244864' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397019'
                WHERE ordernumber = 'P180620182509782' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397020'
                WHERE ordernumber = 'P190620182703596' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397021'
                WHERE ordernumber = 'P420620182732406' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292929'
                WHERE ordernumber = 'P200620183133757' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293690'
                WHERE ordernumber = 'P180620183237604' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381574'
                WHERE ordernumber = 'P420620183825398' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102412'
                WHERE ordernumber = 'P180620184012787' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169372'
                WHERE ordernumber = 'P180620184101226' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397023'
                WHERE ordernumber = 'P200620184141741' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397024'
                WHERE ordernumber = 'P180620184510552' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97482'
                WHERE ordernumber = 'P200620185139931' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221657'
                WHERE ordernumber = 'P630620185214388' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397025'
                WHERE ordernumber = 'P420620185318478' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397026'
                WHERE ordernumber = 'P200620185407472' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301446'
                WHERE ordernumber = 'P420620185438704' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397028'
                WHERE ordernumber = 'P200620190241485' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397029'
                WHERE ordernumber = 'P190620190345220' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302413'
                WHERE ordernumber = 'P200620190353874' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81747'
                WHERE ordernumber = 'P190620190431951' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397030'
                WHERE ordernumber = 'P190620190543903' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397031'
                WHERE ordernumber = 'P200620190703219' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397032'
                WHERE ordernumber = 'P190620190707439' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110755'
                WHERE ordernumber = 'P190620190833234' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312787'
                WHERE ordernumber = 'P780620190845480' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397033'
                WHERE ordernumber = 'P190620190953982' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96813'
                WHERE ordernumber = 'P190620191422616' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384431'
                WHERE ordernumber = 'P190620191706432' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397034'
                WHERE ordernumber = 'P630620191815998' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397035'
                WHERE ordernumber = 'P190620191818469' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397036'
                WHERE ordernumber = 'P190620191915226' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397037'
                WHERE ordernumber = 'P190620192000524' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397038'
                WHERE ordernumber = 'P630620192045510' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397039'
                WHERE ordernumber = 'P190620192054763' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397040'
                WHERE ordernumber = 'P630620192253742' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382504'
                WHERE ordernumber = 'P190620192432895' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397041'
                WHERE ordernumber = 'P200620192539207' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '139510'
                WHERE ordernumber = 'P200620192819823' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397042'
                WHERE ordernumber = 'P190620192837258' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380539'
                WHERE ordernumber = 'P780620192958623' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163647'
                WHERE ordernumber = 'P200620193028169' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311533'
                WHERE ordernumber = 'P190620193133287' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121146'
                WHERE ordernumber = 'P190620193221627' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382504'
                WHERE ordernumber = 'P190620193317921' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386833'
                WHERE ordernumber = 'P200620193359877' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397043'
                WHERE ordernumber = 'P190620193429169' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360003'
                WHERE ordernumber = 'P200620193541117' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '132818'
                WHERE ordernumber = 'P200620193920229' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397044'
                WHERE ordernumber = 'P190620194022192' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397047'
                WHERE ordernumber = 'P630620194701646' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397049'
                WHERE ordernumber = 'P190620195025926' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397050'
                WHERE ordernumber = 'P190620195222979' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '124590'
                WHERE ordernumber = 'P190620195438742' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397053'
                WHERE ordernumber = 'P630620195611364' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397055'
                WHERE ordernumber = 'P780620200145767' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397057'
                WHERE ordernumber = 'P630620201445914' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397058'
                WHERE ordernumber = 'P630620201905831' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397059'
                WHERE ordernumber = 'P630620202256820' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397060'
                WHERE ordernumber = 'P630620202940222' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '75292'
                WHERE ordernumber = 'P630620203927632' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397061'
                WHERE ordernumber = 'P630620204436933' 
            
2024-06-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397066'
                WHERE ordernumber = 'P630620213155926'