2024-09-06 01:00:02 -- 將會員中心id寫入data-lake
2024-09-06 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-09-05%';
        
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378306'
                WHERE ordernumber = 'P180905110107413' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '67081'
                WHERE ordernumber = 'P200905110236615' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340529'
                WHERE ordernumber = 'P200905110453824' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98810'
                WHERE ordernumber = 'P200905110557716' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419276'
                WHERE ordernumber = 'P420905110646365' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316660'
                WHERE ordernumber = 'P200905110724214' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98396'
                WHERE ordernumber = 'P200905110836808' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289355'
                WHERE ordernumber = 'P420905110904196' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363039'
                WHERE ordernumber = 'P180905110941632' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415603'
                WHERE ordernumber = 'P190905110956995' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390242'
                WHERE ordernumber = 'P200905111149334' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419270'
                WHERE ordernumber = 'P180905111408325' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168576'
                WHERE ordernumber = 'P200905111437999' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104129'
                WHERE ordernumber = 'P200905111538973' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '153596'
                WHERE ordernumber = 'P200905111630856' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278832'
                WHERE ordernumber = 'P190905111713356' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415697'
                WHERE ordernumber = 'P190905111900182' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228218'
                WHERE ordernumber = 'P190905112124793' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419280'
                WHERE ordernumber = 'P200905112329403' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '172612'
                WHERE ordernumber = 'P190905112454444' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406903'
                WHERE ordernumber = 'P420905112528293' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419282'
                WHERE ordernumber = 'P200905112651536' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419283'
                WHERE ordernumber = 'P420905112822610' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '84215'
                WHERE ordernumber = 'P190905112905484' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400853'
                WHERE ordernumber = 'P200905112956208' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418927'
                WHERE ordernumber = 'P200905113324268' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314514'
                WHERE ordernumber = 'P190905113602453' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340773'
                WHERE ordernumber = 'P180905113647891' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315390'
                WHERE ordernumber = 'P190905113657895' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180905113759221' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374145'
                WHERE ordernumber = 'P190905113944530' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419287'
                WHERE ordernumber = 'P420905114029584' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414626'
                WHERE ordernumber = 'P180905114043470' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407323'
                WHERE ordernumber = 'P190905114240638' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412049'
                WHERE ordernumber = 'P190905114558661' 
            
2024-09-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99312'
                WHERE ordernumber = 'P200905114704561' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231303'
                WHERE ordernumber = 'P190905114800712' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390936'
                WHERE ordernumber = 'P200905115007778' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242415'
                WHERE ordernumber = 'P200905115141766' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P200905115247897' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386285'
                WHERE ordernumber = 'P630905115418183' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418684'
                WHERE ordernumber = 'P200905115620973' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418684'
                WHERE ordernumber = 'P200905115628899' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339823'
                WHERE ordernumber = 'P420905115901945' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391669'
                WHERE ordernumber = 'P420905120234437' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '151148'
                WHERE ordernumber = 'P200905120437529' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232318'
                WHERE ordernumber = 'P180905120558656' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281418'
                WHERE ordernumber = 'P180905120846945' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '200983'
                WHERE ordernumber = 'P200905120907156' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339872'
                WHERE ordernumber = 'P420905121044713' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415422'
                WHERE ordernumber = 'P630905121214175' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419303'
                WHERE ordernumber = 'P420905121329755' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419304'
                WHERE ordernumber = 'P420905121712243' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99941'
                WHERE ordernumber = 'P180905121802550' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97583'
                WHERE ordernumber = 'P630905121840496' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419305'
                WHERE ordernumber = 'P420905121857244' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415422'
                WHERE ordernumber = 'P630905121940469' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338194'
                WHERE ordernumber = 'P180905122210150' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114438'
                WHERE ordernumber = 'P180905122457431' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415085'
                WHERE ordernumber = 'P200905122852125' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381303'
                WHERE ordernumber = 'P420905122942789' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419310'
                WHERE ordernumber = 'P190905123224530' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98922'
                WHERE ordernumber = 'P200905123615889' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314320'
                WHERE ordernumber = 'P420905123808516' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P180905124011668' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124990'
                WHERE ordernumber = 'P190905124029445' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419312'
                WHERE ordernumber = 'P180905124716720' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275443'
                WHERE ordernumber = 'P200905125135422' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299398'
                WHERE ordernumber = 'P200905125402174' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403535'
                WHERE ordernumber = 'P630905125435420' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419314'
                WHERE ordernumber = 'P420905125635788' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252077'
                WHERE ordernumber = 'P180905125719554' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419314'
                WHERE ordernumber = 'P420905125724577' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418789'
                WHERE ordernumber = 'P420905125845215' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135801'
                WHERE ordernumber = 'P630905125855768' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142533'
                WHERE ordernumber = 'P200905130127532' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216512'
                WHERE ordernumber = 'P180905130240525' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319058'
                WHERE ordernumber = 'P180905130538292' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319058'
                WHERE ordernumber = 'P180905130653651' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211080'
                WHERE ordernumber = 'P200905130751756' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296814'
                WHERE ordernumber = 'P420905130916929' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P180905130920717' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297808'
                WHERE ordernumber = 'P420905131251452' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399767'
                WHERE ordernumber = 'P200905131311576' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419323'
                WHERE ordernumber = 'P420905131509387' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419322'
                WHERE ordernumber = 'P200905131532338' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401915'
                WHERE ordernumber = 'P420905131739594' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307820'
                WHERE ordernumber = 'P190905131943395' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419326'
                WHERE ordernumber = 'P200905131951228' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419327'
                WHERE ordernumber = 'P420905132013720' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395211'
                WHERE ordernumber = 'P630905132039476' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379324'
                WHERE ordernumber = 'P180905132120369' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417690'
                WHERE ordernumber = 'P420905132152958' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290225'
                WHERE ordernumber = 'P200905132506653' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419328'
                WHERE ordernumber = 'P200905132626161' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290225'
                WHERE ordernumber = 'P200905132707544' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419036'
                WHERE ordernumber = 'P180905132711285' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419036'
                WHERE ordernumber = 'P180905132746788' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419329'
                WHERE ordernumber = 'P180905132933614' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397150'
                WHERE ordernumber = 'P420905133024888' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419330'
                WHERE ordernumber = 'P420905133229963' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419332'
                WHERE ordernumber = 'P200905133319534' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394120'
                WHERE ordernumber = 'P630905133421546' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419334'
                WHERE ordernumber = 'P420905134254562' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387378'
                WHERE ordernumber = 'P200905134257998' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231828'
                WHERE ordernumber = 'P200905134413353' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96139'
                WHERE ordernumber = 'P180905134508171' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419336'
                WHERE ordernumber = 'P420905134532991' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160121'
                WHERE ordernumber = 'P200905134628487' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412593'
                WHERE ordernumber = 'P180905134654237' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418876'
                WHERE ordernumber = 'P420905134704225' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '55170'
                WHERE ordernumber = 'P200905134755407' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419338'
                WHERE ordernumber = 'P200905134919676' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419338'
                WHERE ordernumber = 'P200905135008970' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419338'
                WHERE ordernumber = 'P200905135115768' 
            
2024-09-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395211'
                WHERE ordernumber = 'P420905135149896' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419341'
                WHERE ordernumber = 'P200905135241904' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417736'
                WHERE ordernumber = 'P200905135449575' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271889'
                WHERE ordernumber = 'P200905135554700' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257894'
                WHERE ordernumber = 'P180905135636357' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395211'
                WHERE ordernumber = 'P420905135642349' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419343'
                WHERE ordernumber = 'P200905135656865' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168576'
                WHERE ordernumber = 'P200905135948525' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293946'
                WHERE ordernumber = 'P180905140048143' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419345'
                WHERE ordernumber = 'P420905140155310' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384645'
                WHERE ordernumber = 'P420905140232974' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419346'
                WHERE ordernumber = 'P420905140336511' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417472'
                WHERE ordernumber = 'P180905140621565' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419347'
                WHERE ordernumber = 'P200905140803546' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399570'
                WHERE ordernumber = 'P180905140858313' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285926'
                WHERE ordernumber = 'P200905140930188' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359022'
                WHERE ordernumber = 'P180905141430749' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94991'
                WHERE ordernumber = 'P200905142348434' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P420905142731709' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P420905142811512' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386742'
                WHERE ordernumber = 'P180905142856514' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419353'
                WHERE ordernumber = 'P180905143327758' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419347'
                WHERE ordernumber = 'P200905143448767' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419355'
                WHERE ordernumber = 'P420905143503406' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419356'
                WHERE ordernumber = 'P420905143740800' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419358'
                WHERE ordernumber = 'P420905143850363' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305700'
                WHERE ordernumber = 'P180905144103707' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237548'
                WHERE ordernumber = 'P200905144234474' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419361'
                WHERE ordernumber = 'P420905144343493' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345486'
                WHERE ordernumber = 'P180905144408735' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385923'
                WHERE ordernumber = 'P180905144458228' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419362'
                WHERE ordernumber = 'P420905144611334' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224223'
                WHERE ordernumber = 'P180905144614735' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399288'
                WHERE ordernumber = 'P200905144831645' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419363'
                WHERE ordernumber = 'P420905144909362' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404969'
                WHERE ordernumber = 'P630905144959799' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419364'
                WHERE ordernumber = 'P420905145250891' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257807'
                WHERE ordernumber = 'P200905145316476' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419357'
                WHERE ordernumber = 'P180905145425973' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419366'
                WHERE ordernumber = 'P420905145526930' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419367'
                WHERE ordernumber = 'P420905145655372' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415053'
                WHERE ordernumber = 'P420905145836861' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419368'
                WHERE ordernumber = 'P420905150300470' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273096'
                WHERE ordernumber = 'P180905150315227' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404969'
                WHERE ordernumber = 'P630905150330285' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419370'
                WHERE ordernumber = 'P420905150715363' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419371'
                WHERE ordernumber = 'P420905150922632' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387520'
                WHERE ordernumber = 'P180905150931317' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408481'
                WHERE ordernumber = 'P420905150956901' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387520'
                WHERE ordernumber = 'P180905151013285' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232504'
                WHERE ordernumber = 'P200905151223592' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419317'
                WHERE ordernumber = 'P180905151325938' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419366'
                WHERE ordernumber = 'P420905151709236' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311867'
                WHERE ordernumber = 'P200905151747832' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307686'
                WHERE ordernumber = 'P200905151851848' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127600'
                WHERE ordernumber = 'P190905152025295' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380077'
                WHERE ordernumber = 'P200905152418946' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417433'
                WHERE ordernumber = 'P180905153225419' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415804'
                WHERE ordernumber = 'P190905153409826' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358901'
                WHERE ordernumber = 'P200905153410440' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387808'
                WHERE ordernumber = 'P420905153710432' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329752'
                WHERE ordernumber = 'P200905153926348' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419378'
                WHERE ordernumber = 'P420905153932640' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304198'
                WHERE ordernumber = 'P200905154045472' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399804'
                WHERE ordernumber = 'P180905154053243' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416431'
                WHERE ordernumber = 'P420905154828964' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414854'
                WHERE ordernumber = 'P200905154920207' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228555'
                WHERE ordernumber = 'P180905155047619' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123880'
                WHERE ordernumber = 'P180905155210992' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108215'
                WHERE ordernumber = 'P190905155352492' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419263'
                WHERE ordernumber = 'P420905155450187' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271495'
                WHERE ordernumber = 'P190905155456304' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418324'
                WHERE ordernumber = 'P180905155710452' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273677'
                WHERE ordernumber = 'P200905160533277' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90212'
                WHERE ordernumber = 'P200905160714661' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180905160856636' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160121'
                WHERE ordernumber = 'P200905161045942' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419385'
                WHERE ordernumber = 'P420905161316325' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350293'
                WHERE ordernumber = 'P190905161431170' 
            
2024-09-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277324'
                WHERE ordernumber = 'P200905161444461' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141429'
                WHERE ordernumber = 'P200905161543720' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '153110'
                WHERE ordernumber = 'P190905161748667' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419388'
                WHERE ordernumber = 'P420905161837825' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419389'
                WHERE ordernumber = 'P200905161945462' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419391'
                WHERE ordernumber = 'P200905162246841' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420905162346847' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368130'
                WHERE ordernumber = 'P200905162842492' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412733'
                WHERE ordernumber = 'P200905163326626' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419393'
                WHERE ordernumber = 'P420905163622309' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121918'
                WHERE ordernumber = 'P180905163724805' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407204'
                WHERE ordernumber = 'P190905163822522' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407204'
                WHERE ordernumber = 'P190905163906795' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419396'
                WHERE ordernumber = 'P420905164053889' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418958'
                WHERE ordernumber = 'P420905164216819' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '233524'
                WHERE ordernumber = 'P180905164249591' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418958'
                WHERE ordernumber = 'P420905164344279' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418958'
                WHERE ordernumber = 'P420905164417544' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341049'
                WHERE ordernumber = 'P190905164657854' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419398'
                WHERE ordernumber = 'P420905164903424' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419397'
                WHERE ordernumber = 'P190905164906685' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102241'
                WHERE ordernumber = 'P180905165027280' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419039'
                WHERE ordernumber = 'P190905165411735' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419399'
                WHERE ordernumber = 'P420905165456796' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276883'
                WHERE ordernumber = 'P190905165553619' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419400'
                WHERE ordernumber = 'P200905165708743' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297456'
                WHERE ordernumber = 'P420905165846392' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351525'
                WHERE ordernumber = 'P190905165857114' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228035'
                WHERE ordernumber = 'P190905170019721' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419405'
                WHERE ordernumber = 'P420905170202129' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419407'
                WHERE ordernumber = 'P420905170449314' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419408'
                WHERE ordernumber = 'P200905170824429' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419410'
                WHERE ordernumber = 'P180905171251441' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318659'
                WHERE ordernumber = 'P180905171657666' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419411'
                WHERE ordernumber = 'P200905171833810' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '119508'
                WHERE ordernumber = 'P190905172601709' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419414'
                WHERE ordernumber = 'P420905172901266' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396508'
                WHERE ordernumber = 'P180905173051970' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102422'
                WHERE ordernumber = 'P200905173426415' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419415'
                WHERE ordernumber = 'P200905173515485' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419416'
                WHERE ordernumber = 'P420905173654318' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419417'
                WHERE ordernumber = 'P420905173811714' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98291'
                WHERE ordernumber = 'P190905174020685' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419419'
                WHERE ordernumber = 'P420905174234654' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95093'
                WHERE ordernumber = 'P200905174326638' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419421'
                WHERE ordernumber = 'P420905174742574' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419422'
                WHERE ordernumber = 'P200905175043660' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419116'
                WHERE ordernumber = 'P420905175052359' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419116'
                WHERE ordernumber = 'P420905175136337' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419423'
                WHERE ordernumber = 'P200905175211189' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419424'
                WHERE ordernumber = 'P200905175352671' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418269'
                WHERE ordernumber = 'P420905175456464' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418269'
                WHERE ordernumber = 'P420905175536489' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419425'
                WHERE ordernumber = 'P200905175657519' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415037'
                WHERE ordernumber = 'P420905175924530' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415717'
                WHERE ordernumber = 'P420905180023285' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350554'
                WHERE ordernumber = 'P200905180037433' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415499'
                WHERE ordernumber = 'P180905180138435' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419427'
                WHERE ordernumber = 'P190905180321216' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418644'
                WHERE ordernumber = 'P200905180335874' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419428'
                WHERE ordernumber = 'P200905180554444' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419429'
                WHERE ordernumber = 'P420905180712320' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372909'
                WHERE ordernumber = 'P200905180925279' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419432'
                WHERE ordernumber = 'P200905181159839' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419418'
                WHERE ordernumber = 'P180905181245182' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340529'
                WHERE ordernumber = 'P200905181414387' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372909'
                WHERE ordernumber = 'P200905181605422' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419433'
                WHERE ordernumber = 'P420905181613375' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218992'
                WHERE ordernumber = 'P420905181704688' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232297'
                WHERE ordernumber = 'P200905181714891' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416835'
                WHERE ordernumber = 'P190905182317941' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248042'
                WHERE ordernumber = 'P200905182743969' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248042'
                WHERE ordernumber = 'P200905182807188' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414017'
                WHERE ordernumber = 'P190905182853453' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81124'
                WHERE ordernumber = 'P420905182920793' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239944'
                WHERE ordernumber = 'P180905183102504' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413149'
                WHERE ordernumber = 'P200905183134252' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337422'
                WHERE ordernumber = 'P180905183254822' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419442'
                WHERE ordernumber = 'P200905183626634' 
            
2024-09-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270515'
                WHERE ordernumber = 'P200905183817179' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '244459'
                WHERE ordernumber = 'P200905183915336' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '228218'
                WHERE ordernumber = 'P180905184013757' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '413775'
                WHERE ordernumber = 'P180905184113949' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '311243'
                WHERE ordernumber = 'P200905184436120' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419235'
                WHERE ordernumber = 'P190905184557870' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '286628'
                WHERE ordernumber = 'P200905184705777' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '38895'
                WHERE ordernumber = 'P190905184834769' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419447'
                WHERE ordernumber = 'P200905184940937' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '280171'
                WHERE ordernumber = 'P200905185214590' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '236690'
                WHERE ordernumber = 'P180905185536251' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '286421'
                WHERE ordernumber = 'P180905185645707' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419437'
                WHERE ordernumber = 'P200905185917300' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '362699'
                WHERE ordernumber = 'P200905190229482' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '408368'
                WHERE ordernumber = 'P420905190305736' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '407882'
                WHERE ordernumber = 'P200905190416175' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419450'
                WHERE ordernumber = 'P420905190548142' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '385507'
                WHERE ordernumber = 'P630905190616113' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419451'
                WHERE ordernumber = 'P200905190750507' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381523'
                WHERE ordernumber = 'P200905191140772' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '307752'
                WHERE ordernumber = 'P200905191944625' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '215448'
                WHERE ordernumber = 'P180905192418276' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '132907'
                WHERE ordernumber = 'P200905192527518' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '132907'
                WHERE ordernumber = 'P200905192629480' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '132907'
                WHERE ordernumber = 'P200905192733220' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419452'
                WHERE ordernumber = 'P200905193006426' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419453'
                WHERE ordernumber = 'P200905193136557' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '268618'
                WHERE ordernumber = 'P200905193257773' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '344600'
                WHERE ordernumber = 'P200905193401237' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '250073'
                WHERE ordernumber = 'P180905194507271' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '219358'
                WHERE ordernumber = 'P180905194636489' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '233221'
                WHERE ordernumber = 'P190905194639236' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403141'
                WHERE ordernumber = 'P180905195339546' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P190905195351607' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '412174'
                WHERE ordernumber = 'P200905195454681' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P190905195553672' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P190905195838347' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419458'
                WHERE ordernumber = 'P200905200059461' 
            
2024-09-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '380401'
                WHERE ordernumber = 'P630905204523194'