select phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, t.reference_score AS referenceScore, COUNT(*) OVER () fullRowCount from TETRAMER t inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id inner join TERM geneTerm on t.gene_id = geneTerm.id inner join TERM chemTerm on t.chem_id = chemTerm.id where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'METALS, HEAVY'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 FROM gene_disease_reference gdr, gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdr.source_cd = 'C' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id AND gdra.action_type_cd = 'm' UNION SELECT 1 FROM gene_disease_reference gdr WHERE gdr.source_cd = 'O' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm --LIMIT 50;

[ Date: 2026-08-21 13:34:34 ]

select distinct phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, t.reference_score AS referenceScore, COUNT(*) OVER () fullRowCount from TETRAMER t, TERM phenotypeTerm, TERM diseaseTerm, TERM geneTerm, TERM chemTerm where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'METALS, HEAVY'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 FROM gene_disease_reference gdr, gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdr.source_cd = 'C' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id AND gdra.action_type_cd = 'm' UNION SELECT 1 FROM gene_disease_reference gdr WHERE gdr.source_cd = 'O' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id) and t.phenotype_id = phenotypeTerm.id and t.disease_id = diseaseTerm.id and t.chem_id = chemTerm.id and t.gene_id = geneTerm.id order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:34:26 - Bind query: yes ]

select distinct phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, t.reference_score AS referenceScore, COUNT(*) OVER () fullRowCount from TETRAMER t, TERM phenotypeTerm, TERM diseaseTerm, TERM geneTerm, TERM chemTerm where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM gene_disease_reference gdr, gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdr.source_cd = 'C' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id AND gdra.action_type_cd = 'm' UNION SELECT 1 FROM gene_disease_reference gdr WHERE gdr.source_cd = 'O' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id) and t.phenotype_id = phenotypeTerm.id and t.disease_id = diseaseTerm.id and t.chem_id = chemTerm.id and t.gene_id = geneTerm.id order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 12:56:11 - Bind query: yes ]

select phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, t.reference_score AS referenceScore, COUNT(*) OVER () fullRowCount from TETRAMER t inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id inner join TERM geneTerm on t.gene_id = geneTerm.id inner join TERM chemTerm on t.chem_id = chemTerm.id where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'METALS, HEAVY'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr WHERE chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id and cdr.source_cd = 'C' and exists ( select 1 from chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdra.action_type_cd = 'm')) and EXISTS ( SELECT 1 FROM gene_disease_reference gdr WHERE gdr.gene_id = t.gene_id AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:31:02 ]

select distinct phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, t.reference_score AS referenceScore, COUNT(*) OVER () fullRowCount from TETRAMER t, TERM phenotypeTerm, TERM diseaseTerm, TERM geneTerm, TERM chemTerm where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'METALS, HEAVY'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 FROM gene_disease_reference gdr, gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdr.source_cd = 'C' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id AND gdra.action_type_cd = 'm' UNION SELECT 1 FROM gene_disease_reference gdr WHERE gdr.source_cd = 'O' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id) and t.phenotype_id = phenotypeTerm.id and t.disease_id = diseaseTerm.id and t.chem_id = chemTerm.id and t.gene_id = geneTerm.id order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:40:41 - Bind query: yes ]

select distinct phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, t.reference_score AS referenceScore, COUNT(*) OVER () fullRowCount from TETRAMER t, TERM phenotypeTerm, TERM diseaseTerm, TERM geneTerm, TERM chemTerm where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'METALS, HEAVY'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 FROM gene_disease_reference gdr, gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdr.source_cd = 'C' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id AND gdra.action_type_cd = 'm' UNION SELECT 1 FROM gene_disease_reference gdr WHERE gdr.source_cd = 'O' AND geneTerm.id = gdr.gene_id AND diseaseTerm.id = gdr.disease_id) and t.phenotype_id = phenotypeTerm.id and t.disease_id = diseaseTerm.id and t.chem_id = chemTerm.id and t.gene_id = geneTerm.id order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:39:28 - Bind query: yes ]

select phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'METALS, HEAVY'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:40:18 - Database: ctddev51 - User: qaeu - Bind query: yes ]

select phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'METALS, HEAVY'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr WHERE chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdr.source_cd = 'C' AND EXISTS ( SELECT 1 FROM chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdra.action_type_cd = 'm')) and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:49:54 - Database: ctddev51 - User: qaeu - Bind query: yes ]

select phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'METALS, HEAVY'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:43:25 - Database: ctddev51 - User: qaeu - Bind query: yes ]

select distinct # 015 phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by chemTerm.nm, t.reference_score desc, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:02:28 - Bind query: yes ]

select distinct # 015 phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by chemTerm.nm, t.reference_score desc, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:02:34 - Database: ctddev51 - User: qaeu - Bind query: yes ]

select distinct # 015 phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 12:54:51 - Database: ctddev51 - User: qaeu - Bind query: yes ]

select distinct # 015 phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 12:58:43 - Bind query: yes ]

select distinct # 015 phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:16:41 - Bind query: yes ]

select distinct phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, t.reference_score AS referenceScore, COUNT(*) OVER () fullRowCount from TETRAMER t inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id inner join TERM geneTerm on t.gene_id = geneTerm.id inner join TERM chemTerm on t.chem_id = chemTerm.id where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr WHERE chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id and cdr.source_cd = 'C' and exists ( select 1 from chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdra.action_type_cd = 'm')) and EXISTS ( SELECT 1 FROM gene_disease_reference gdr WHERE gdr.gene_id = t.gene_id AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:27:02 ]

select distinct # 015 phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:02:00 - Bind query: yes ]

select distinct # 015 phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:14:06 - Bind query: yes ]

select distinct # 015 phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:10:45 - Bind query: yes ]

select distinct # 015 phenotypeTerm.nm AS goNm # 015, phenotypeTerm.nm_html AS goNmHtml # 015, phenotypeTerm.acc_txt AS goAcc # 015, diseaseTerm.nm AS diseaseNm # 015, diseaseTerm.nm_html AS diseaseNmHtml # 015, diseaseTerm.acc_txt AS diseaseAcc # 015, diseaseTerm.acc_db_cd AS diseaseAccDbCd # 015, chemTerm.nm AS chemNm # 015, chemTerm.nm_html AS chemNmHtml # 015, chemTerm.acc_txt AS chemAcc # 015, geneTerm.nm AS geneSymbol # 015, geneTerm.nm_html AS geneSymbolHtml # 015, geneTerm.acc_txt AS geneAcc # 015, t.reference_score AS referenceScore # 015, COUNT(*) OVER () fullRowCount # 015 from TETRAMER t # 015 inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id # 015 inner join TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join TERM chemTerm on t.chem_id = chemTerm.id # 015 where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 # 015 FROM gene_disease_reference gdr # 015 WHERE gdr.gene_id = t.gene_id # 015 AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;

[ Date: 2026-08-21 13:03:00 - Bind query: yes ]

select distinct phenotypeTerm.nm AS goNm, phenotypeTerm.nm_html AS goNmHtml, phenotypeTerm.acc_txt AS goAcc, diseaseTerm.nm AS diseaseNm, diseaseTerm.nm_html AS diseaseNmHtml, diseaseTerm.acc_txt AS diseaseAcc, diseaseTerm.acc_db_cd AS diseaseAccDbCd, chemTerm.nm AS chemNm, chemTerm.nm_html AS chemNmHtml, chemTerm.acc_txt AS chemAcc, geneTerm.nm AS geneSymbol, geneTerm.nm_html AS geneSymbolHtml, geneTerm.acc_txt AS geneAcc, t.reference_score AS referenceScore, COUNT(*) OVER () fullRowCount from TETRAMER t inner join TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id inner join TERM diseaseTerm on t.disease_id = diseaseTerm.id inner join TERM geneTerm on t.gene_id = geneTerm.id inner join TERM chemTerm on t.chem_id = chemTerm.id where chem_id = ANY (ARRAY ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC'))) and EXISTS ( SELECT 1 FROM chem_disease_reference cdr, chem_disease_reference_axn cdra WHERE cdr.id = cdra.chem_disease_reference_id AND cdr.source_cd = 'C' AND chemTerm.id = cdr.chem_id AND diseaseTerm.id = cdr.disease_id AND cdra.action_type_cd = 'm') and EXISTS ( SELECT 1 FROM gene_disease_reference gdr WHERE gdr.gene_id = t.gene_id AND gdr.disease_id = t.disease_id -- BASE_GENE_DISEASE_RLTNP_FRAGMENT AND ((source_cd = 'C' -- DBConstants.CURATED_FILTER_SQL AND EXISTS ( SELECT 1 FROM gene_disease_reference_axn gdra WHERE gdr.id = gdra.gene_disease_reference_id AND gdra.action_type_cd = 'm' --GENE_DISEASE_CTD_CURATED_MARKER_RLTNP_WHERE_FRAGMENT )) OR (source_cd = 'O') -- DBConstants.OMIM_CURATED_FILTER_SQL )) order by t.reference_score desc, chemTerm.nm, geneTerm.nm, phenotypeTerm.nm, diseaseTerm.nm LIMIT 50;