yamti

SELECT tr.id, rFrom.titleCache as rFrom, rTo.titleCache as rTO, type.titleCache  FROM TaxonRelationship tr INNER JOIN TaxonBase rFrom ON tr.relatedfrom_id = rFrom.id INNER JOIN TaxonBase rTo ON tr.relatedto_id = rTo.id INNER JOIN DefinedTermBase type ON tr.type_id = type.id WHERE type.titleCache not like 'Congruent to'
ORDER BY tr.id DESC