User:Liangent/prcadmin2012

liangent@nightshade:~/code/gerrit/mediawiki/core$ echo select region2011.code1,region2011.code2,region2011.code3,region2011.code4,region2011.code5,region2011.attrib,region2011.name from region2011 left join region2012 on region2011.code1=region2012.code1 and region2011.code2=region2012.code2 and region2011.code3=region2012.code3 and region2011.code4=region2012.code4 and region2011.code5=region2012.code5 where region2012.name is null and region2011.code5='000' limit 10000 | mysql -hsql-s2-user u_liangent_prcadmin2 -H | php maintenance/edit.php --wiki=zhwiki_p User:Liangent/prcadmin2012/removals Saving... done liangent@nightshade:~/code/gerrit/mediawiki/core$ echo select region2012.code1,region2012.code2,region2012.code3,region2012.code4,region2012.code5,region2012.attrib,region2012.name from region2012 left join region2011 on region2011.code1=region2012.code1 and region2011.code2=region2012.code2 and region2011.code3=region2012.code3 and region2011.code4=region2012.code4 and region2011.code5=region2012.code5 where region2011.name is null and region2012.code5='000' limit 10000 | mysql -hsql-s2-user u_liangent_prcadmin2 -H | php maintenance/edit.php --wiki=zhwiki_p User:Liangent/prcadmin2012/additions Saving... done liangent@nightshade:~/code/gerrit/mediawiki/core$ echo select region2012.code1,region2012.code2,region2012.code3,region2012.code4,region2012.code5,region2011.attrib attrib2011, region2012.attrib attrib2012,region2011.name name2011, region2012.name name2012 from region2012 join region2011 on region2011.code1=region2012.code1 and region2011.code2=region2012.code2 and region2011.code3=region2012.code3 and region2011.code4=region2012.code4 and region2011.code5=region2012.code5 where $region2011.attrib\<\>region2012.attrib or region2011.name \<\>region2012.name$ and region2012.code5='000' limit 10000 | mysql -hsql-s2-user u_liangent_prcadmin2 -H | php maintenance/edit.php --wiki=zhwiki_p User:Liangent/prcadmin2012/renames Saving... done liangent@nightshade:~/code/gerrit/mediawiki/core$