/* * 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: 2024-08-18 00:16:36 ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUND') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 21:31:28 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'gene'))) AND gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUND') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 20:54:36 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUND') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 21:32:13 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUND') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 21:33:05 - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUN') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 20:43:58 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUND') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 21:30:14 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'gene'))) AND gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUND') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 20:54:55 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUND') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 21:34:06 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUN') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 20:43:42 - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUN') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 20:43:57 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUN') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 21:28:49 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUN') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 20:52:23 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUN') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 20:18:44 - Database: ctdprd51 - User: pubeu - Bind query: yes ]

SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id WHERE /* CIQH.getIxnWhereCore */ gcr.gene_id = ANY (ARRAY (( SELECT /* CIQH.getIxnGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'JUN') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;

[ Date: 2024-08-18 20:17:40 - Bind query: yes ]

SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'AORTIC & SMOOTH & MUSCLE% & AND & 3971=CONVERT & INT) UNION SELECT 'reference' ,r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english',' AORTIC & SMOOTH & MUSCLE % & AND & 3971 = CONVERT & INT) OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AORTIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMOOTH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MUSCLE%' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3971=CONVERT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INT,' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SELECT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '118' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '112' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '112' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR', $19 = '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SELECT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'WHEN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3971=3971' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'THEN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '49' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ELSE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '48' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'END' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '120' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '118' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '112' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '%' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '=' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AORTIC')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'SMOOTH' OR upper(l.acc_txt) LIKE 'MUSCLE%' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE '3971=CONVERT' OR upper(l.acc_txt) LIKE 'INT,' OR upper(l.acc_txt) LIKE 'SELECT' OR upper(l.acc_txt) LIKE 'CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '118' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '112' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '112' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE '+' OR upper(l.acc_txt) LIKE 'SELECT' OR upper(l.acc_txt) LIKE 'CASE' OR upper(l.acc_txt) LIKE 'WHEN' OR upper(l.acc_txt) LIKE '3971=3971' OR upper(l.acc_txt) LIKE 'THEN' OR upper(l.acc_txt) LIKE 'CHAR' OR upper(l.acc_txt) LIKE '49' OR upper(l.acc_txt) LIKE 'ELSE' OR upper(l.acc_txt) LIKE 'CHAR' OR upper(l.acc_txt) LIKE '48' OR upper(l.acc_txt) LIKE 'END' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '120' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '118' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '112' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE '%' OR upper(l.acc_txt) LIKE '=' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd;

[ Date: 2024-08-18 15:23:30 - Bind query: yes ]

SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'AORTIC & SMOOTH & MUSCLE% & AND & 3971=CONVERT & INT) UNION SELECT 'reference' ,r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english',' AORTIC & SMOOTH & MUSCLE % & AND & 3971 = CONVERT & INT) OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AORTIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMOOTH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MUSCLE%' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3971=CONVERT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INT,' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SELECT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '118' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '112' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '112' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR', $19 = '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SELECT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'WHEN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3971=3971' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'THEN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '49' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ELSE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '48' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'END' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '120' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '118' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '112' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '%' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '=' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AORTIC')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'SMOOTH' OR upper(l.acc_txt) LIKE 'MUSCLE%' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE '3971=CONVERT' OR upper(l.acc_txt) LIKE 'INT,' OR upper(l.acc_txt) LIKE 'SELECT' OR upper(l.acc_txt) LIKE 'CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '118' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '112' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '112' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE '+' OR upper(l.acc_txt) LIKE 'SELECT' OR upper(l.acc_txt) LIKE 'CASE' OR upper(l.acc_txt) LIKE 'WHEN' OR upper(l.acc_txt) LIKE '3971=3971' OR upper(l.acc_txt) LIKE 'THEN' OR upper(l.acc_txt) LIKE 'CHAR' OR upper(l.acc_txt) LIKE '49' OR upper(l.acc_txt) LIKE 'ELSE' OR upper(l.acc_txt) LIKE 'CHAR' OR upper(l.acc_txt) LIKE '48' OR upper(l.acc_txt) LIKE 'END' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '120' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '118' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '112' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE '%' OR upper(l.acc_txt) LIKE '=' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd;

[ Date: 2024-08-18 15:24:30 - Bind query: yes ]

SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'AORTIC & SMOOTH & MUSCLE% & AND & 3971=CONVERT & INT) UNION SELECT 'reference' ,r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english',' AORTIC & SMOOTH & MUSCLE % & AND & 3971 = CONVERT & INT) OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AORTIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SMOOTH' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MUSCLE%' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3971=CONVERT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INT,' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SELECT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '118' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '112' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '112' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR', $19 = '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'SELECT' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'WHEN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '3971=3971' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'THEN' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '49' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'ELSE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '48' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'END' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '120' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '118' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '112' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '+CHAR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '113' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '%' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '=' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AORTIC')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'SMOOTH' OR upper(l.acc_txt) LIKE 'MUSCLE%' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE '3971=CONVERT' OR upper(l.acc_txt) LIKE 'INT,' OR upper(l.acc_txt) LIKE 'SELECT' OR upper(l.acc_txt) LIKE 'CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '118' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '112' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '112' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE '+' OR upper(l.acc_txt) LIKE 'SELECT' OR upper(l.acc_txt) LIKE 'CASE' OR upper(l.acc_txt) LIKE 'WHEN' OR upper(l.acc_txt) LIKE '3971=3971' OR upper(l.acc_txt) LIKE 'THEN' OR upper(l.acc_txt) LIKE 'CHAR' OR upper(l.acc_txt) LIKE '49' OR upper(l.acc_txt) LIKE 'ELSE' OR upper(l.acc_txt) LIKE 'CHAR' OR upper(l.acc_txt) LIKE '48' OR upper(l.acc_txt) LIKE 'END' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '120' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '118' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '112' OR upper(l.acc_txt) LIKE '+CHAR' OR upper(l.acc_txt) LIKE '113' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE '%' OR upper(l.acc_txt) LIKE '=' OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd;