Edit

SELECT n1.FullNameCache,n2.FullNameCache, r.Notes, n1.notes, n2.notes, pt1.notes, r.* 
 FROM RelPTaxon AS r 
       INNER JOIN v_cdm_exp_taxaDirect AS a ON r.PTNameFk2 = a.PTNameFk AND r.PTRefFk2 = a.PTRefFk 
       INNER JOIN PTaxon As pt1 ON pt1.PTNameFk = r.PTNameFk1 AND pt1.PTRefFk = r.PTRefFk1 
       INNER JOIN Name n1 ON n1.NameId = r.PTNameFk1
       INNER JOIN Name n2 ON n2.NameId = r.PTNameFk2
WHERE r.RelPTaxonID NOT IN (1874890,1874959,1874932,1874793,1874956,1874971,1874902,1874696)
   AND NOT (pt1.PTRefFk = 8000000 AND pt1.publishFlag = 0)
   AND r.Notes IS NOT NULL AND r.Notes like '%non %'
ORDER BY r.Notes,PTRefFk1;