Times Reported Most Frequent Error / Event #1

x Hide

ERROR: syntax error at or near "trans" at character 7

Statement: begin trans

Date: 2026-06-25 13:47:45

ERROR: syntax error at or near "transactiom" at character 10

Statement: rollback transactiom

Date: 2026-06-25 13:48:46

ERROR: syntax error at or near "WHERE" at character 1144

Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id INNER JOIN reference r ON cc.reference_id = r.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id WHERE t.id = 1486859

Date: 2026-06-25 14:51:28

x Hide

Times Reported Most Frequent Error / Event #2

x Hide

ERROR: relation "ixn_qualifer_table" does not exist at character 15

Statement: select * from ixn_qualifer_table

Date: 2026-06-25 13:15:23
Database: ctddev51
Application: pgAdmin 4 - CONN:1855680
User: pub1
Remote: 

ERROR: relation "ixn_qualifier_table" does not exist at character 15

Statement: select * from ixn_qualifier_table

Date: 2026-06-25 13:15:51

ERROR: relation "ixn_qualifier" does not exist at character 15

Statement: select * from ixn_qualifier

Date: 2026-06-25 13:16:13

x Hide

Times Reported Most Frequent Error / Event #3

x Hide

ERROR: column "ixn_qualifer_nm" does not exist at character 58

Hint: Perhaps you meant to reference the column "chem_conc.ixn_qualifier_nm".
Statement: update chem_conc set ixn_qualifier_nm = 'in vitro' where ixn_qualifer_nm = 'Invitro';

Date: 2026-06-25 13:48:08

ERROR: column r.reference_id does not exist at character 597

Hint: Perhaps you meant to reference the column "cc.reference_id".
Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, COUNT(DISTINCT r.reference_id) referenceCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id INNER JOIN reference r ON cc.reference_id = r.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859

Date: 2026-06-25 14:50:29

ERROR: column r.reference_id does not exist at character 799

Hint: Perhaps you meant to reference the column "cc.reference_id".
Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refText, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc 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 LEFT JOIN ( SELECT r.reference_id, string_agg(distinct r.abbr_authors_txt || '^' || r.core_citation_txt || '^' || r.pub_start_yr || r.acc_txt, '|') AS refText FROM reference r GROUP BY cca.chem_conc_id ) r ON c.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm,taxoncomnm, taxonid,taxonacc, refText

Date: 2026-06-25 15:22:37

x Hide

Times Reported Most Frequent Error / Event #4

x Hide

x Hide

Times Reported Most Frequent Error / Event #5

x Hide

ERROR: missing FROM-clause entry for table "cc" at character 35

Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, COUNT(DISTINCT r.reference_id) referenceCount

Date: 2026-06-25 14:50:26
Database: ctddev51
Application: pgAdmin 4 - CONN:202330
User: pubeu
Remote: 

ERROR: missing FROM-clause entry for table "cca" at character 959

Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refText, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.abbr_authors_txt || '^' || r.core_citation_txt || '^' || r.pub_start_yr || r.acc_txt, '|') AS refText FROM reference r GROUP BY cca.chem_conc_id ) r ON c.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm,taxoncomnm, taxonid,taxonacc, refText

Date: 2026-06-25 15:23:06

ERROR: missing FROM-clause entry for table "c" at character 971

Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refText, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.abbr_authors_txt || '^' || r.core_citation_txt || '^' || r.pub_start_yr || r.acc_txt, '|') AS refText FROM reference r GROUP BY r.id ) r ON c.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm,taxoncomnm, taxonid,taxonacc, refText

Date: 2026-06-25 15:24:07

x Hide

Times Reported Most Frequent Error / Event #6

x Hide

ERROR: invalid reference to FROM-clause entry for table "cc" at character 799

Hint: There is an entry for table "cc", but it cannot be referenced from this part of the query.
Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refText, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc 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 LEFT JOIN ( SELECT cc.reference_id, string_agg(distinct r.abbr_authors_txt || '^' || r.core_citation_txt || '^' || r.pub_start_yr || r.acc_txt, '|') AS refText FROM reference r GROUP BY cca.chem_conc_id ) r ON c.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm,taxoncomnm, taxonid,taxonacc, refText

Date: 2026-06-25 15:22:46

ERROR: invalid reference to FROM-clause entry for table "cca" at character 1268

Hint: There is an entry for table "cca", but it cannot be referenced from this part of the query.
Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refText, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc 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 LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id LEFT JOIN ( SELECT r.id, string_agg(distinct r.abbr_authors_txt || '^' || r.core_citation_txt || '^' || r.pub_start_yr || r.acc_txt, '|') AS refText FROM reference r GROUP BY cca.chem_conc_id ) r ON c.reference_id = r.id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm,taxoncomnm, taxonid,taxonacc, refText

Date: 2026-06-25 15:23:47

x Hide

Times Reported Most Frequent Error / Event #7

x Hide

ERROR: column "cc.chem_id" must appear in the GROUP BY clause or be used in an aggregate function at character 35

Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id INNER JOIN reference r ON cc.reference_id = r.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859

Date: 2026-06-25 14:51:03

ERROR: column "t.nm" must appear in the GROUP BY clause or be used in an aggregate function at character 55

Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id INNER JOIN reference r ON cc.reference_id = r.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id

Date: 2026-06-25 14:51:34

x Hide

Times Reported Most Frequent Error / Event #8

x Hide

ERROR: current transaction is aborted, commands ignored until end of transaction block

Statement: update chem_conc set ixn_qualifier_nm = 'in vitro' where ixn_qualifier_nm = 'Invitro';

Date: 2026-06-25 13:48:23

ERROR: current transaction is aborted, commands ignored until end of transaction block

Statement: begin transaction

Date: 2026-06-25 13:48:31

x Hide

Times Reported Most Frequent Error / Event #9

x Hide

FATAL: password authentication failed for user "pubeu"

Detail: Connection matched pg_hba.conf line 85: "host all all 192.168.201.0/24 md5 "

Date: 2026-06-25 14:01:19

x Hide

Times Reported Most Frequent Error / Event #10

x Hide

ERROR: schema "r" does not exist at character 825

Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, refText, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.abbr_authors_txt '^' || r.pub_start_yr || '^' || r.acc_txt, '|') AS refText FROM reference r GROUP BY r.id ) r ON cc.reference_id = r.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm,taxoncomnm, taxonid,taxonacc, refText

Date: 2026-06-25 15:27:04

x Hide

Times Reported Most Frequent Error / Event #11

x Hide

ERROR: syntax error at end of input at character 1403

Statement: SELECT /* ChemConcentrationDao */ cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc|| ' ' || cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, COUNT(DISTINCT cc.reference_id) referenceCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id INNER JOIN reference r ON cc.reference_id = r.id LEFT JOIN term d ON cc.disease_id = d.id LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html || '^' || cca.anatomy_acc_txt || '^' || cca.position_seq || '^' || cca.anatomy_acc_db_id || '^' || cca.anatomy_nm, '|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id ) cca ON cc.id = cca.chem_conc_id WHERE t.id = 1486859 GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc,

Date: 2026-06-25 14:52:43

x Hide