EDIT

bug #6938

Updated by Andreas Müller almost 6 years ago

Not yet complete  

 * run [s_em_MoveCommonNames] to move common names to structured common names 

 === 

 remove duplicate parent relationships 

 ~~~ sql 
 SELECT *  
 FROM ( 
    SELECT COUNT(PTaxon_1.RIdentifier) AS HowMany, PTaxon.PTNameFk, PTaxon.PTRefFk , Name.FullNameCache 
    FROM PTaxon  
      INNER JOIN RelPTaxon ON PTaxon.PTNameFk = RelPTaxon.PTNameFk1 AND PTaxon.PTRefFk = RelPTaxon.PTRefFk1  
      INNER JOIN PTaxon PTaxon_1 ON RelPTaxon.PTNameFk2 = PTaxon_1.PTNameFk AND RelPTaxon.PTRefFk2 = PTaxon_1.PTRefFk  
      INNER JOIN Name ON PTaxon.PTNameFk = Name.NameID  
    WHERE (RelPTaxon.RelQualifierFk = 1) AND (PTaxon.PTRefFk % 100000 = 0) AND (PTaxon.PTRefFk >= 7000000)  
    GROUP BY PTaxon.RIdentifier, PTaxon.PTNameFk, PTaxon.PTRefFk, Name.FullNameCache) AS DuplicateParentRelation  
 WHERE HowMany > 1  
 ORDER BY HowMany DESC; 
 ~~~ 

 ~~~ sql 
 SELECT n2.fullNameCache, rel.* 
 FROM PTaxon pt 
      INNER JOIN RelPTaxon rel ON pt.PTNameFk = rel.PTNameFk1 AND pt.PTRefFk = rel.PTRefFk1  
	  INNER JOIN Name n2 ON rel.PTNameFk2 = n2.NameId 
 WHERE rel.PTNameFk1 = xxx AND rel.PTRefFk1 = 7xxx 
 ~~~

Back