2024-08-24 01:00:02 -- 將會員中心id寫入data-lake
2024-08-24 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-08-23%';
        
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412483'
                WHERE ordernumber = 'P420823110410193' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412482'
                WHERE ordernumber = 'P200823110436272' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412484'
                WHERE ordernumber = 'P180823110503223' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340934'
                WHERE ordernumber = 'P190823110503853' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221996'
                WHERE ordernumber = 'P420823110547834' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412481'
                WHERE ordernumber = 'P190823110628948' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406809'
                WHERE ordernumber = 'P180823110650324' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380031'
                WHERE ordernumber = 'P200823110925256' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412480'
                WHERE ordernumber = 'P180823111035470' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412491'
                WHERE ordernumber = 'P180823111133182' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420823111319851' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412493'
                WHERE ordernumber = 'P200823111446690' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165646'
                WHERE ordernumber = 'P200823111618784' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412499'
                WHERE ordernumber = 'P200823111911685' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98396'
                WHERE ordernumber = 'P200823112109990' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412502'
                WHERE ordernumber = 'P180823112120508' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378584'
                WHERE ordernumber = 'P420823112345111' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220631'
                WHERE ordernumber = 'P420823112420881' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412504'
                WHERE ordernumber = 'P180823112428612' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412506'
                WHERE ordernumber = 'P180823112649573' 
            
2024-08-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403614'
                WHERE ordernumber = 'P180823112809484' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316185'
                WHERE ordernumber = 'P420823112809635' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412507'
                WHERE ordernumber = 'P200823112948291' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412508'
                WHERE ordernumber = 'P180823112959477' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412512'
                WHERE ordernumber = 'P200823113619915' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412513'
                WHERE ordernumber = 'P200823113944680' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412515'
                WHERE ordernumber = 'P200823114057289' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410124'
                WHERE ordernumber = 'P200823114159229' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327941'
                WHERE ordernumber = 'P180823114224209' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204136'
                WHERE ordernumber = 'P200823114509898' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166925'
                WHERE ordernumber = 'P180823114618871' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96954'
                WHERE ordernumber = 'P190823114721731' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273093'
                WHERE ordernumber = 'P420823114738245' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166925'
                WHERE ordernumber = 'P180823115011860' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407624'
                WHERE ordernumber = 'P180823115200356' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412517'
                WHERE ordernumber = 'P200823115256434' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412516'
                WHERE ordernumber = 'P420823115315552' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412521'
                WHERE ordernumber = 'P420823115532301' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242282'
                WHERE ordernumber = 'P180823120054879' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398219'
                WHERE ordernumber = 'P420823120438874' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409250'
                WHERE ordernumber = 'P180823120503376' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409250'
                WHERE ordernumber = 'P180823120710950' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412532'
                WHERE ordernumber = 'P420823121124489' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412535'
                WHERE ordernumber = 'P420823121323909' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412521'
                WHERE ordernumber = 'P420823121554303' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385363'
                WHERE ordernumber = 'P420823121752510' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392573'
                WHERE ordernumber = 'P200823121945406' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412543'
                WHERE ordernumber = 'P420823122325194' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412544'
                WHERE ordernumber = 'P630823122644231' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73653'
                WHERE ordernumber = 'P200823123103336' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166671'
                WHERE ordernumber = 'P420823123308133' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272744'
                WHERE ordernumber = 'P200823123401467' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412546'
                WHERE ordernumber = 'P420823123434794' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157212'
                WHERE ordernumber = 'P200823123438931' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412545'
                WHERE ordernumber = 'P200823123507253' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412548'
                WHERE ordernumber = 'P420823123642178' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261666'
                WHERE ordernumber = 'P420823123809792' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97359'
                WHERE ordernumber = 'P200823123814440' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412554'
                WHERE ordernumber = 'P200823124358410' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118257'
                WHERE ordernumber = 'P200823124531601' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118257'
                WHERE ordernumber = 'P200823124606500' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411772'
                WHERE ordernumber = 'P180823124804651' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411772'
                WHERE ordernumber = 'P180823124839872' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180823125359289' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '170749'
                WHERE ordernumber = 'P180823125439724' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121766'
                WHERE ordernumber = 'P180823130209617' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412569'
                WHERE ordernumber = 'P180823131355402' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406727'
                WHERE ordernumber = 'P190823131540126' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407601'
                WHERE ordernumber = 'P200823131645263' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412573'
                WHERE ordernumber = 'P420823132303570' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412576'
                WHERE ordernumber = 'P420823132707250' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412578'
                WHERE ordernumber = 'P180823133040515' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400032'
                WHERE ordernumber = 'P180823133650820' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309849'
                WHERE ordernumber = 'P180823133939253' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397457'
                WHERE ordernumber = 'P630823134044375' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400032'
                WHERE ordernumber = 'P180823135309793' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306285'
                WHERE ordernumber = 'P180823135514550' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299703'
                WHERE ordernumber = 'P200823135524134' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412593'
                WHERE ordernumber = 'P180823135649451' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412594'
                WHERE ordernumber = 'P180823140219488' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412595'
                WHERE ordernumber = 'P420823140257458' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260324'
                WHERE ordernumber = 'P200823140717522' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272252'
                WHERE ordernumber = 'P180823140810912' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303066'
                WHERE ordernumber = 'P590823140823933' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87789'
                WHERE ordernumber = 'P180823140924630' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392726'
                WHERE ordernumber = 'P200823140932316' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412597'
                WHERE ordernumber = 'P200823141033507' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412588'
                WHERE ordernumber = 'P420823141100249' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412598'
                WHERE ordernumber = 'P420823141238759' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412601'
                WHERE ordernumber = 'P180823141342858' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412602'
                WHERE ordernumber = 'P180823141619785' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412603'
                WHERE ordernumber = 'P180823141815728' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411335'
                WHERE ordernumber = 'P180823141957932' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114545'
                WHERE ordernumber = 'P180823142039453' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412606'
                WHERE ordernumber = 'P200823142225989' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296137'
                WHERE ordernumber = 'P180823142423595' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412610'
                WHERE ordernumber = 'P200823142821541' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108785'
                WHERE ordernumber = 'P180823142837782' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412618'
                WHERE ordernumber = 'P180823143739132' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412623'
                WHERE ordernumber = 'P180823144406634' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412627'
                WHERE ordernumber = 'P180823144753689' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412629'
                WHERE ordernumber = 'P200823145058166' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412630'
                WHERE ordernumber = 'P180823145127949' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233392'
                WHERE ordernumber = 'P190823145500910' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412631'
                WHERE ordernumber = 'P180823145518556' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412632'
                WHERE ordernumber = 'P180823145649868' 
            
2024-08-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243069'
                WHERE ordernumber = 'P180823145804329' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293407'
                WHERE ordernumber = 'P190823145810524' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119574'
                WHERE ordernumber = 'P200823145923122' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412636'
                WHERE ordernumber = 'P180823150330528' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412638'
                WHERE ordernumber = 'P180823150545239' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410512'
                WHERE ordernumber = 'P180823150742309' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412640'
                WHERE ordernumber = 'P180823150943559' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221129'
                WHERE ordernumber = 'P180823151025562' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412016'
                WHERE ordernumber = 'P180823151408903' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274955'
                WHERE ordernumber = 'P180823151721451' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200823152412538' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412104'
                WHERE ordernumber = 'P180823153134807' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412653'
                WHERE ordernumber = 'P180823153443655' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385749'
                WHERE ordernumber = 'P190823153603608' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412654'
                WHERE ordernumber = 'P180823153604738' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '182906'
                WHERE ordernumber = 'P190823153654940' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254509'
                WHERE ordernumber = 'P180823153710195' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412659'
                WHERE ordernumber = 'P420823154309720' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412657'
                WHERE ordernumber = 'P630823154347310' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412662'
                WHERE ordernumber = 'P420823154726952' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99845'
                WHERE ordernumber = 'P180823154834440' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412663'
                WHERE ordernumber = 'P200823154909526' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P180823154916833' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412665'
                WHERE ordernumber = 'P180823155240971' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '171626'
                WHERE ordernumber = 'P180823155438383' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97778'
                WHERE ordernumber = 'P180823155558602' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140490'
                WHERE ordernumber = 'P180823155700491' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412402'
                WHERE ordernumber = 'P200823155709167' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86775'
                WHERE ordernumber = 'P190823160730297' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374516'
                WHERE ordernumber = 'P200823161035688' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378096'
                WHERE ordernumber = 'P180823161107640' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412675'
                WHERE ordernumber = 'P180823161226794' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317333'
                WHERE ordernumber = 'P200823161558334' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412679'
                WHERE ordernumber = 'P190823162034944' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412681'
                WHERE ordernumber = 'P420823162204373' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155013'
                WHERE ordernumber = 'P420823162355625' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412686'
                WHERE ordernumber = 'P200823162655513' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412689'
                WHERE ordernumber = 'P200823162938606' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287554'
                WHERE ordernumber = 'P180823163233390' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P420823163629901' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390658'
                WHERE ordernumber = 'P200823163808588' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412695'
                WHERE ordernumber = 'P420823163913272' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411262'
                WHERE ordernumber = 'P420823164427616' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285872'
                WHERE ordernumber = 'P200823164959807' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278743'
                WHERE ordernumber = 'P200823165104404' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412700'
                WHERE ordernumber = 'P420823165139601' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412703'
                WHERE ordernumber = 'P200823165956222' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409782'
                WHERE ordernumber = 'P190823170042780' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412706'
                WHERE ordernumber = 'P420823170342910' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412707'
                WHERE ordernumber = 'P180823170353694' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412708'
                WHERE ordernumber = 'P420823170540865' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412710'
                WHERE ordernumber = 'P200823170612555' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339050'
                WHERE ordernumber = 'P180823170813988' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272804'
                WHERE ordernumber = 'P420823170814319' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301307'
                WHERE ordernumber = 'P190823171314977' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412714'
                WHERE ordernumber = 'P200823171629491' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412715'
                WHERE ordernumber = 'P420823171835226' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412718'
                WHERE ordernumber = 'P420823172041240' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287217'
                WHERE ordernumber = 'P200823172410871' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105699'
                WHERE ordernumber = 'P200823172752963' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104744'
                WHERE ordernumber = 'P200823172844446' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412721'
                WHERE ordernumber = 'P200823173005126' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412723'
                WHERE ordernumber = 'P420823173108230' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349415'
                WHERE ordernumber = 'P180823173136390' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412724'
                WHERE ordernumber = 'P420823173303555' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412725'
                WHERE ordernumber = 'P200823173340927' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384789'
                WHERE ordernumber = 'P420823173507532' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412727'
                WHERE ordernumber = 'P420823173706997' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412728'
                WHERE ordernumber = 'P180823173750417' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P420823173820219' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412729'
                WHERE ordernumber = 'P200823173837845' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404337'
                WHERE ordernumber = 'P420823173925925' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141588'
                WHERE ordernumber = 'P200823174350864' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412731'
                WHERE ordernumber = 'P180823174741883' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403838'
                WHERE ordernumber = 'P190823174813516' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '145656'
                WHERE ordernumber = 'P630823174914252' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227178'
                WHERE ordernumber = 'P180823174920392' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284600'
                WHERE ordernumber = 'P180823175031219' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P190823175037383' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P190823175219137' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412735'
                WHERE ordernumber = 'P200823175343941' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412737'
                WHERE ordernumber = 'P200823175548837' 
            
2024-08-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412738'
                WHERE ordernumber = 'P420823175754574' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412736'
                WHERE ordernumber = 'P180823175819722' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412741'
                WHERE ordernumber = 'P420823175915835' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296488'
                WHERE ordernumber = 'P200823180234729' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '203511'
                WHERE ordernumber = 'P180823180357777' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279506'
                WHERE ordernumber = 'P190823180601611' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402184'
                WHERE ordernumber = 'P200823180707813' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404113'
                WHERE ordernumber = 'P180823181331829' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98538'
                WHERE ordernumber = 'P180823181826990' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281302'
                WHERE ordernumber = 'P180823181918428' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412749'
                WHERE ordernumber = 'P200823182043450' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411973'
                WHERE ordernumber = 'P420823182052833' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412750'
                WHERE ordernumber = 'P180823182128286' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412752'
                WHERE ordernumber = 'P180823182254853' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '153110'
                WHERE ordernumber = 'P180823182329424' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412753'
                WHERE ordernumber = 'P420823182415622' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95356'
                WHERE ordernumber = 'P200823182543172' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412756'
                WHERE ordernumber = 'P180823182559606' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412757'
                WHERE ordernumber = 'P180823182754177' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308125'
                WHERE ordernumber = 'P180823182941796' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412759'
                WHERE ordernumber = 'P190823183134778' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412761'
                WHERE ordernumber = 'P420823183142769' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412762'
                WHERE ordernumber = 'P200823183350312' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412763'
                WHERE ordernumber = 'P200823183447838' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412767'
                WHERE ordernumber = 'P180823183923594' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412768'
                WHERE ordernumber = 'P420823183942611' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412772'
                WHERE ordernumber = 'P420823184159409' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288128'
                WHERE ordernumber = 'P180823184213534' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '89714'
                WHERE ordernumber = 'P180823184347702' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318982'
                WHERE ordernumber = 'P180823184530982' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412774'
                WHERE ordernumber = 'P180823184702998' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412775'
                WHERE ordernumber = 'P180823184729282' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318982'
                WHERE ordernumber = 'P180823184917863' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412779'
                WHERE ordernumber = 'P420823185428819' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381547'
                WHERE ordernumber = 'P420823185546470' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102264'
                WHERE ordernumber = 'P190823185700366' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98694'
                WHERE ordernumber = 'P420823185902250' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98694'
                WHERE ordernumber = 'P420823190254205' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412783'
                WHERE ordernumber = 'P190823190338941' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412783'
                WHERE ordernumber = 'P190823190537320' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160054'
                WHERE ordernumber = 'P200823190944741' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341122'
                WHERE ordernumber = 'P200823191310194' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412787'
                WHERE ordernumber = 'P200823191419264' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '134240'
                WHERE ordernumber = 'P190823191442865' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412791'
                WHERE ordernumber = 'P200823192301616' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408021'
                WHERE ordernumber = 'P200823192509872' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P190823193051156' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212356'
                WHERE ordernumber = 'P190823194256492' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '216274'
                WHERE ordernumber = 'P190823194339665' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412798'
                WHERE ordernumber = 'P190823194743725' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412215'
                WHERE ordernumber = 'P200823195106591' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392518'
                WHERE ordernumber = 'P200823195153998' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358902'
                WHERE ordernumber = 'P190823195342649' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P590823200016608' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367406'
                WHERE ordernumber = 'P630823205725457' 
            
2024-08-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412238'
                WHERE ordernumber = 'P590823212244777'