1.6以前注销的用户同步删除portal

1.主站以前的cas库注销的432条（portal只有232条）

10421,24666,24910,106735,111579,149474,179811,181971,188725,189835,206783,208259,240392,245754,246680,248864,267601,368851,390957,419490,434673,437557,494229,514825,592640,608768,623584,637740,637937,649486,651551,670239,677721,698731,727803,728356,763355,764326,769325,796553,809327,820012,829322,839930,880660,894067,894570,894880,901711,916612,925257,925404,931651,932279,932346,933567,933598,934516,934614,937963,938153,941663,942260,943800,945419,948816,949374,949428,951060,951197,952249,952291,952426,953407,953506,955309,956663,958403,959726,960249,961589,961753,962019,962255,962347,963111,963671,963673,963674,963681,964067,964179,964193,964194,964198,964199,964201,964204,964276,964277,964279,964280,964283,964284,964285,964286,964288,964289,964290,964295,964298,964308,964335,965213,965214,965215,965216,965217,965218,965219,965220,965221,965222,965223,966069,966359,966454,966462,966466,966472,966474,966475,966570,966736,967529,967531,968076,968219,968652,968729,968730,968732,969068,969119,969353,969534,969864,970621,970796,970798,971134,971703,971857,972391,972392,972394,972397,972401,972405,972408,972413,972415,972416,972417,972419,972421,972446,972448,972464,972468,972481,972484,972486,972513,972524,972526,972527,972542,972566,972597,972623,972647,972654,972659,972693,972699,972702,972738,972739,972755,972800,972858,972904,973021,973075,973122,973160,973166,973193,973227,973261,973281,973296,973300,973459,973482,973536,973596,973645,973677,973705,973710,973736,973759,973813,973828,973909,973964,973978,973993,974091,974170,974217,974249,974294,974416,974458,974510,974689,974766,974825,974911,974968,975011,975265,975266,975293,975364,975392,975468,975500,975585,975590,975620,975629,975683,975762,975796,975837,975920,976227,976428,977090,977142,977193,977223,977294,977376,977396,977470,977500,977567,977626,977685,977759,977892,977951,978042,978056,978153,978177,978210,978317,978350,978437,978544,978703,978763,978843,978897,978898,978949,979315,979466,979502,979733,979886,980024,980054,980158,980248,980261,980383,980454,980522,980551,980560,980601,980660,980668,980673,980733,980795,980809,980979,980987,981056,981219,981480,981519,981657,981852,981912,981974,982008,982025,982043,982117,982121,982183,982323,982463,982522,982532,982863,982890,982948,983227,983384,983442,983471,983484,983798,983890,983928,983975,984005,984092,984224,984303,984468,984758,984798,984936,985176,985301,985360,985370,985606,985662,985673,985842,985985,986018,986088,986169,986173,986233,986275,986366,986458,986495,986541,986611,986701,986780,986851,986906,986997,987055,987089,987150,987154,987240,987314,987394,987428,987471,987515,987542,987612,987716,987800,987812,987840,987927,988088,988203,988310,988510,988554,988612,988678,988722,988935,989035,989143,989186,989270,989347,989398,989424,989583,989613,989661,989702,989746,989820,990017,990140,990199,990201,990204,990267,990293,990383,990427,990471,990532,990605,990656,990711,990843,990920,990927,991320,991686,992468,992784,992871,993178,994274,994302,994610,994625,995442,995728,995849,996368,996485,997181,997185,997268,998181,998196,998197,998480,998715,998731,999151,999152,999237,999518,1000351,1000663,1001129,1001164,1001168,1001256,1001283,1001645,1002703,1002840,1003256,1003925,1004285,1004321,1006447,1007582,1008573,1008588,1008612,1008815,1008893,1009249,1009574,1010304,1011028,1011320,1011337,1011388,1012451,1013013,1013418,1013448,1014060,1014319,1015062,1015414,1016312,1016391,1016498,1016962

'10421','24666','24910','106735','111579','149474','179811','181971','188725','189835','206783','208259','240392','245754','246680','248864','267601','368851','390957','419490','434673','437557','494229','514825','592640','608768','623584','637740','637937','649486','651551','670239','677721','698731','727803','728356','763355','764326','769325','796553','809327','820012','829322','839930','880660','894067','894570','894880','901711','916612','925257','925404','931651','932279','932346','933567','933598','934516','934614','937963','938153','941663','942260','943800','945419','948816','949374','949428','951060','951197','952249','952291','952426','953407','953506','955309','956663','958403','959726','960249','961589','961753','962019','962255','962347','963111','963671','963673','963674','963681','964067','964179','964193','964194','964198','964199','964201','964204','964276','964277','964279','964280','964283','964284','964285','964286','964288','964289','964290','964295','964298','964308','964335','965213','965214','965215','965216','965217','965218','965219','965220','965221','965222','965223','966069','966359','966454','966462','966466','966472','966474','966475','966570','966736','967529','967531','968076','968219','968652','968729','968730','968732','969068','969119','969353','969534','969864','970621','970796','970798','971134','971703','971857','972391','972392','972394','972397','972401','972405','972408','972413','972415','972416','972417','972419','972421','972446','972448','972464','972468','972481','972484','972486','972513','972524','972526','972527','972542','972566','972597','972623','972647','972654','972659','972693','972699','972702','972738','972739','972755','972800','972858','972904','973021','973075','973122','973160','973166','973193','973227','973261','973281','973296','973300','973459','973482','973536','973596','973645','973677','973705','973710','973736','973759','973813','973828','973909','973964','973978','973993','974091','974170','974217','974249','974294','974416','974458','974510','974689','974766','974825','974911','974968','975011','975265','975266','975293','975364','975392','975468','975500','975585','975590','975620','975629','975683','975762','975796','975837','975920','976227','976428','977090','977142','977193','977223','977294','977376','977396','977470','977500','977567','977626','977685','977759','977892','977951','978042','978056','978153','978177','978210','978317','978350','978437','978544','978703','978763','978843','978897','978898','978949','979315','979466','979502','979733','979886','980024','980054','980158','980248','980261','980383','980454','980522','980551','980560','980601','980660','980668','980673','980733','980795','980809','980979','980987','981056','981219','981480','981519','981657','981852','981912','981974','982008','982025','982043','982117','982121','982183','982323','982463','982522','982532','982863','982890','982948','983227','983384','983442','983471','983484','983798','983890','983928','983975','984005','984092','984224','984303','984468','984758','984798','984936','985176','985301','985360','985370','985606','985662','985673','985842','985985','986018','986088','986169','986173','986233','986275','986366','986458','986495','986541','986611','986701','986780','986851','986906','986997','987055','987089','987150','987154','987240','987314','987394','987428','987471','987515','987542','987612','987716','987800','987812','987840','987927','988088','988203','988310','988510','988554','988612','988678','988722','988935','989035','989143','989186','989270','989347','989398','989424','989583','989613','989661','989702','989746','989820','990017','990140','990199','990201','990204','990267','990293','990383','990427','990471','990532','990605','990656','990711','990843','990920','990927','991320','991686','992468','992784','992871','993178','994274','994302','994610','994625','995442','995728','995849','996368','996485','997181','997185','997268','998181','998196','998197','998480','998715','998731','999151','999152','999237','999518','1000351','1000663','1001129','1001164','1001168','1001256','1001283','1001645','1002703','1002840','1003256','1003925','1004285','1004321','1006447','1007582','1008573','1008588','1008612','1008815','1008893','1009249','1009574','1010304','1011028','1011320','1011337','1011388','1012451','1013013','1013418','1013448','1014060','1014319','1015062','1015414','1016312','1016391','1016498','1016962'

2.现在sso库注销的 114条（portal只有100条）

25037,43472,103792,168640,192322,204752,244509,248018,263299,326677,429343,550261,560375,633406,646364,646703,648276,650153,670889,678208,701088,712786,741012,773797,782061,846908,847010,930218,931155,931491,932136,934171,934307,938215,940815,941259,942325,943778,945414,946866,947945,949264,951512,956263,957622,957683,957723,958920,960491,961056,961835,962759,964120,964299,970925,973535,977263,980216,980553,981417,982901,983463,985273,986047,988020,990497,992580,993805,995851,996667,999385,999551,1000136,1000182,1004227,1004742,1007847,1007929,1008187,1008247,1010302,1011068,1011953,1013684,1014533,1015183,1015185,1015233,1017066,1019416,1019553,1020050,1020613,1022177,1022665,1022743,1022953,1027260,1029134,1029167,1029246,1029316,1029320,1029321,1029948,1030322,1030484,1030567,1031086,1031292,1031491,1031689,1033003,1033074

'25037','43472','103792','168640','192322','204752','244509','248018','263299','326677','429343','550261','560375','633406','646364','646703','648276','650153','670889','678208','701088','712786','741012','773797','782061','846908','847010','930218','931155','931491','932136','934171','934307','938215','940815','941259','942325','943778','945414','946866','947945','949264','951512','956263','957622','957683','957723','958920','960491','961056','961835','962759','964120','964299','970925','973535','977263','980216','980553','981417','982901','983463','985273','986047','988020','990497','992580','993805','995851','996667','999385','999551','1000136','1000182','1004227','1004742','1007847','1007929','1008187','1008247','1010302','1011068','1011953','1013684','1014533','1015183','1015185','1015233','1017066','1019416','1019553','1020050','1020613','1022177','1022665','1022743','1022953','1027260','1029134','1029167','1029246','1029316','1029320','1029321','1029948','1030322','1030484','1030567','1031086','1031292','1031491','1031689','1033003','1033074'

3.主站portal昵称相同184条

334632,339278,414007,441034,541364,655307,667038,673271,678212,687573,705742,711002,716420,752471,775431,925029,926668,929964,492741,920007,935885,946357,946610,935756,950795,934392,951745,964195,965312,965748,967024,968680,968681,968715,968719,969739,969684,973575,973794,479572,975795,976752,973442,978947,322868,980211,980389,980725,981166,981211,981795,981966,982346,931910,982726,982770,983158,983662,984800,985835,897527,986279,986720,987263,987275,686134,987623,987885,987979,988412,988856,969489,989384,989814,990270,958681,990796,770706,950778,947057,991668,992165,992362,992444,992902,975442,993553,993704,994119,995598,995903,996298,996533,996622,996631,996902,997179,997283,997405,997482,997587,998218,998283,998518,998750,683103,998996,999636,999960,1001024,1002483,1003253,1005009,1005042,1005096,1006646,1006847,1007451,1008011,1008518,1009325,1009410,1009432,1009604,1009925,1010134,1010377,1010624,1010891,1011300,1012081,832329,1012452,1013255,1013759,1014001,1014397,1014583,1015692,1016882,1017028,1017029,1017032,1017033,1017219,1017244,1017702,1018356,1018358,1018684,10487,1018742,1018884,1020806,1022065,1022090,1022672,1022677,1022681,1022691,1022758,1022764,1022774,1022812,1022798,1022820,1022869,1022883,1022908,1022949,1022970,1022977,1022986,1022994,1023034,1023042,1023045,1023058,1023081,1023105,1023129,1023133,1023166,1023182,1023188,1023200,1023215,1023227,1023270,1023304,1023311,1023327,1023331,1023394,1023406,1023407,1023420,1023445,1023452,1023453,1023488,1023489,1023543,1023548,1023550,1023579,1023603,1023605,1023631,1023633,1023695,1023817,1023820,1023827,1023877,1023883,1023887,1023905,1023929,1023959,1023963,1023977,1024010,1024015,1024025,1024030,1024042,1024090,1024123,1024143,1024150,1024162,1024166,1024169,1024194,1024211,1024263,1024315,1024348,1024373,1024398,1024404,1024429,1024444,1024493,1024502,1024507,1024568,1024585,1024595,1024689,1024798,1024842,1024989,1025027,1025038,1025071,1025074,1025177,1025206,1025263,1025265,1025266,1025269,1025273,1025332,1025335,1025747,1025792,1026506,1026521,1029356,1029367,1031960,1032674,

4.主站portal邮箱相同87条

24296,10968,48483,25163,10082,24485,24986,25094,437913,441562,25457,25507,548164,253438,449733,632231,656061,635221,663449,663715,38794,689588,702579,702760,711006,671294,741537,742352,764481,778360,866118,876187,642027,712788,890442,925036,926186,745055,930225,931452,82148,933366,933439,884071,936657,735855,940553,943762,938059,948116,178915,895052,872257,246864,228619,246343,151648,948108,764570,952196,211658,954857,174527,838194,228632,150280,247825,247812,963201,167891,964195,965402,968680,968681,968715,968719,968757,214776,934265,987065,984121,351660,943085,998482,1005790,979324,1017028,1017029,1017032,1022681,1022687

5.删除portal注销用户

更新后最后同步数据库昵称和邮箱

select * from user_infos WHERE nickname in ( SELECT nickname FROM user_infos where nickname is not null and nickname != '' GROUP BY nickname HAVING count(*) > 1) and (name REGEXP '[^0-9]') = 0