From: <ba...@us...> - 2010-04-28 03:28:07
|
Revision: 3272 http://obo.svn.sourceforge.net/obo/?rev=3272&view=rev Author: balhoff Date: 2010-04-28 03:28:00 +0000 (Wed, 28 Apr 2010) Log Message: ----------- Avoiding incorrectly inferred super-ranks. Modified Paths: -------------- OBDAPI/trunk/phenoscape/views/taxon.sql Modified: OBDAPI/trunk/phenoscape/views/taxon.sql =================================================================== --- OBDAPI/trunk/phenoscape/views/taxon.sql 2010-04-28 02:10:11 UTC (rev 3271) +++ OBDAPI/trunk/phenoscape/views/taxon.sql 2010-04-28 03:28:00 UTC (rev 3272) @@ -4,15 +4,15 @@ taxon.node_id AS node_id, taxon.uid AS uid, taxon.label AS label, - has_rank_link.object_id AS rank, + has_rank_link.object_id AS rank_node_id, tagval.val AS is_extinct, - parent_link.object_id AS parent + parent_link.object_id AS parent_node_id FROM node taxon JOIN node chordata ON (chordata.uid = 'TTO:1') JOIN is_a_link ON (is_a_link.node_id = taxon.node_id AND is_a_link.object_id = chordata.node_id) JOIN node has_rank_rel ON (has_rank_rel.uid = 'has_rank') - LEFT OUTER JOIN link has_rank_link ON (has_rank_link.node_id = taxon.node_id AND has_rank_link.predicate_id = has_rank_rel.node_id) + LEFT OUTER JOIN link has_rank_link ON (has_rank_link.node_id = taxon.node_id AND has_rank_link.predicate_id = has_rank_rel.node_id AND has_rank_link.is_inferred = FALSE) JOIN node is_extinct_rel ON (is_extinct_rel.uid = 'is_extinct') LEFT OUTER JOIN tagval ON (tagval.node_id = taxon.node_id AND tagval.tag_id = is_extinct_rel.node_id) LEFT OUTER JOIN is_a_link parent_link ON (parent_link.node_id = taxon.node_id AND parent_link.is_inferred = FALSE) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |