/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();

[ Date: 2026-09-02 00:09:22 - Database: ctdprd51 - User: pubc - Application: psql ]

COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;

[ Date: 2026-09-02 10:06:55 - Database: ctdprd51 - User: postgres - Application: pg_dump ]

COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;

[ Date: 2026-09-02 06:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]

COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;

[ Date: 2026-09-02 18:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]

COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;

[ Date: 2026-09-02 14:06:53 - Database: ctdprd51 - User: postgres - Application: pg_dump ]

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY chem_conc_id ), reference_groups AS ( SELECT cc.chem_id, cc.chem_conc, cc.chem_conc_uom_nm, cc.taxon_id, cc.disease_id, cc.chem_conc_exp_route_nm, cc.ixn_qualifier_nm, cc.action_type_cd, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) AS anatomy_ids, string_agg(DISTINCT r.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc.reference_id) AS referenceCount FROM chem_conc cc LEFT JOIN anatomy a ON a.chem_conc_id = cc.id LEFT JOIN reference r ON r.id = cc.reference_id GROUP BY cc.chem_id, cc.chem_conc, cc.chem_conc_uom_nm, cc.taxon_id, cc.disease_id, cc.chem_conc_exp_route_nm, cc.ixn_qualifier_nm, cc.action_type_cd, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) ), deduplicated_cc AS ( SELECT cc.*, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) AS anatomy_ids, a.anatomyTerms, ROW_NUMBER() OVER (PARTITION BY cc.chem_id, cc.chem_conc, cc.chem_conc_uom_nm, cc.taxon_id, cc.disease_id, cc.chem_conc_exp_route_nm, cc.ixn_qualifier_nm, cc.action_type_cd, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) ORDER BY cc.id) AS rn FROM chem_conc cc LEFT JOIN anatomy a ON a.chem_conc_id = cc.id WHERE EXISTS ( SELECT 1 FROM chem_conc cc_ref LEFT JOIN anatomy a_ref ON a_ref.chem_conc_id = cc_ref.id WHERE cc_ref.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc_ref.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc_ref.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc_ref.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc_ref.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc_ref.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc_ref.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc_ref.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND COALESCE(a_ref.anatomy_ids, ARRAY[]::integer[]) = COALESCE(a.anatomy_ids, ARRAY[]::integer[]))) SELECT /* ChemConcentrationDao */ cc.chem_id AS chem_id, t.nm AS chem, t.nm_html AS chemNmHtml, t.acc_txt AS chemAcc, t.secondary_nm AS casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration, cc.ixn_qualifier_nm AS vivoVitro, cc.chem_conc_exp_route_nm AS expRoute, cc.taxon_nm_html AS organism, cc.anatomyTerms AS anatomyTerms, cc.anatomyTerms AS anatomyTermsSort, cc.action_type_cd AS directEvidence, cc.action_type_cd AS directEvidenceSort, d.nm AS diseasenm, d.acc_txt AS diseaseacc, d.acc_db_cd AS diseaseaccdbcd, d.id AS diseaseid, tx.nm AS taxonnm, tx.secondary_nm AS taxoncomnm, tx.id AS taxonid, tx.acc_txt AS taxonacc, rg.refAcc, rg.referenceCount, COUNT(*) OVER () fullRowCount FROM deduplicated_cc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN reference_groups rg ON rg.chem_id IS NOT DISTINCT FROM cc.chem_id AND rg.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND rg.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND rg.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND rg.disease_id IS NOT DISTINCT FROM cc.disease_id AND rg.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND rg.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND rg.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND rg.anatomy_ids = cc.anatomy_ids WHERE cc.rn = 1 AND t.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1419818') ORDER BY organism LIMIT 50;

[ Date: 2026-09-02 07:25:08 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY chem_conc_id ), reference_groups AS ( SELECT cc.chem_id, cc.chem_conc, cc.chem_conc_uom_nm, cc.taxon_id, cc.disease_id, cc.chem_conc_exp_route_nm, cc.ixn_qualifier_nm, cc.action_type_cd, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) AS anatomy_ids, string_agg(DISTINCT r.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc.reference_id) AS referenceCount FROM chem_conc cc LEFT JOIN anatomy a ON a.chem_conc_id = cc.id LEFT JOIN reference r ON r.id = cc.reference_id GROUP BY cc.chem_id, cc.chem_conc, cc.chem_conc_uom_nm, cc.taxon_id, cc.disease_id, cc.chem_conc_exp_route_nm, cc.ixn_qualifier_nm, cc.action_type_cd, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) ), deduplicated_cc AS ( SELECT cc.*, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) AS anatomy_ids, a.anatomyTerms, ROW_NUMBER() OVER (PARTITION BY cc.chem_id, cc.chem_conc, cc.chem_conc_uom_nm, cc.taxon_id, cc.disease_id, cc.chem_conc_exp_route_nm, cc.ixn_qualifier_nm, cc.action_type_cd, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) ORDER BY cc.id) AS rn FROM chem_conc cc LEFT JOIN anatomy a ON a.chem_conc_id = cc.id WHERE EXISTS ( SELECT 1 FROM chem_conc cc_ref LEFT JOIN anatomy a_ref ON a_ref.chem_conc_id = cc_ref.id WHERE cc_ref.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc_ref.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc_ref.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc_ref.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc_ref.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc_ref.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc_ref.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc_ref.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND COALESCE(a_ref.anatomy_ids, ARRAY[]::integer[]) = COALESCE(a.anatomy_ids, ARRAY[]::integer[]))) SELECT /* ChemConcentrationDao */ cc.chem_id AS chem_id, t.nm AS chem, t.nm_html AS chemNmHtml, t.acc_txt AS chemAcc, t.secondary_nm AS casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration, cc.ixn_qualifier_nm AS vivoVitro, cc.chem_conc_exp_route_nm AS expRoute, cc.taxon_nm_html AS organism, cc.anatomyTerms AS anatomyTerms, cc.anatomyTerms AS anatomyTermsSort, cc.action_type_cd AS directEvidence, cc.action_type_cd AS directEvidenceSort, d.nm AS diseasenm, d.acc_txt AS diseaseacc, d.acc_db_cd AS diseaseaccdbcd, d.id AS diseaseid, tx.nm AS taxonnm, tx.secondary_nm AS taxoncomnm, tx.id AS taxonid, tx.acc_txt AS taxonacc, rg.refAcc, rg.referenceCount, COUNT(*) OVER () fullRowCount FROM deduplicated_cc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN reference_groups rg ON rg.chem_id IS NOT DISTINCT FROM cc.chem_id AND rg.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND rg.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND rg.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND rg.disease_id IS NOT DISTINCT FROM cc.disease_id AND rg.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND rg.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND rg.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND rg.anatomy_ids = cc.anatomy_ids WHERE cc.rn = 1 AND t.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1419818') ORDER BY organism;

[ Date: 2026-09-02 07:27:52 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html || '^' || anatomy_acc_txt || '^' || position_seq || '^' || anatomy_acc_db_id || '^' || anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY chem_conc_id ), reference_groups AS ( SELECT cc.chem_id, cc.chem_conc, cc.chem_conc_uom_nm, cc.taxon_id, cc.disease_id, cc.chem_conc_exp_route_nm, cc.ixn_qualifier_nm, cc.action_type_cd, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) AS anatomy_ids, string_agg(DISTINCT r.acc_txt, '|') AS refAcc, COUNT(DISTINCT cc.reference_id) AS referenceCount FROM chem_conc cc LEFT JOIN anatomy a ON a.chem_conc_id = cc.id LEFT JOIN reference r ON r.id = cc.reference_id GROUP BY cc.chem_id, cc.chem_conc, cc.chem_conc_uom_nm, cc.taxon_id, cc.disease_id, cc.chem_conc_exp_route_nm, cc.ixn_qualifier_nm, cc.action_type_cd, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) ), deduplicated_cc AS ( SELECT cc.*, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) AS anatomy_ids, a.anatomyTerms, ROW_NUMBER() OVER (PARTITION BY cc.chem_id, cc.chem_conc, cc.chem_conc_uom_nm, cc.taxon_id, cc.disease_id, cc.chem_conc_exp_route_nm, cc.ixn_qualifier_nm, cc.action_type_cd, COALESCE(a.anatomy_ids, ARRAY[]::integer[]) ORDER BY cc.id) AS rn FROM chem_conc cc LEFT JOIN anatomy a ON a.chem_conc_id = cc.id WHERE EXISTS ( SELECT 1 FROM chem_conc cc_ref LEFT JOIN anatomy a_ref ON a_ref.chem_conc_id = cc_ref.id WHERE cc_ref.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc_ref.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc_ref.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc_ref.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc_ref.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc_ref.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc_ref.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc_ref.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND COALESCE(a_ref.anatomy_ids, ARRAY[]::integer[]) = COALESCE(a.anatomy_ids, ARRAY[]::integer[]))) SELECT /* ChemConcentrationDao */ cc.chem_id AS chem_id, t.nm AS chem, t.nm_html AS chemNmHtml, t.acc_txt AS chemAcc, t.secondary_nm AS casRN, cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration, cc.ixn_qualifier_nm AS vivoVitro, cc.chem_conc_exp_route_nm AS expRoute, cc.taxon_nm_html AS organism, cc.anatomyTerms AS anatomyTerms, cc.anatomyTerms AS anatomyTermsSort, cc.action_type_cd AS directEvidence, cc.action_type_cd AS directEvidenceSort, d.nm AS diseasenm, d.acc_txt AS diseaseacc, d.acc_db_cd AS diseaseaccdbcd, d.id AS diseaseid, tx.nm AS taxonnm, tx.secondary_nm AS taxoncomnm, tx.id AS taxonid, tx.acc_txt AS taxonacc, rg.refAcc, rg.referenceCount, COUNT(*) OVER () fullRowCount FROM deduplicated_cc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN reference_groups rg ON rg.chem_id IS NOT DISTINCT FROM cc.chem_id AND rg.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND rg.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND rg.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND rg.disease_id IS NOT DISTINCT FROM cc.disease_id AND rg.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND rg.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND rg.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND rg.anatomy_ids = cc.anatomy_ids WHERE cc.rn = 1 AND t.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1531906') ORDER BY organism LIMIT 50;

[ Date: 2026-09-02 07:31:02 - Database: ctdprd51 - User: pubeu - 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 disease_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 = 3 and upper(baseTerm.nm) LIKE 'LIVER DISEASES'))) 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-09-02 09:39:14 - Database: ctdprd51 - User: pubeu - 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 disease_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 = 3 and upper(baseTerm.nm) LIKE 'LIVER DISEASES'))) 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 1000;

[ Date: 2026-09-02 09:40:43 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2198383') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 4635350;

[ Date: 2026-09-02 02:06:47 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2198383') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 4635350;

[ Date: 2026-09-02 02:06:58 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2198383') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;

[ Date: 2026-09-02 02:03:07 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2198383') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 4635350;

[ Date: 2026-09-02 02:06:41 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;

[ Date: 2026-09-02 06:07:19 ]

COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;

[ Date: 2026-09-02 10:07:19 ]

COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;

[ Date: 2026-09-02 14:07:17 ]

COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;

[ Date: 2026-09-02 18:07:18 ]

COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;

[ Date: 2026-09-02 10:00:22 - Database: ctdprd51 - User: postgres - Application: pg_dump ]

COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;

[ Date: 2026-09-02 14:00:22 - Database: ctdprd51 - User: postgres - Application: pg_dump ]