DRUG_INDICATIONS_SQL

DRUG_INDICATIONS_SQL = 'SELECT\n    MOLECULE_DICTIONARY.chembl_id,\n    MOLECULE_DICTIONARY.pref_name,\n    MOLECULE_DICTIONARY.chebi_par_id,\n    DRUG_INDICATION.mesh_id,\n    DRUG_INDICATION.mesh_heading,\n    DRUG_INDICATION.efo_id AS indication_curie,\n    DRUG_INDICATION.efo_term AS indication_label,\n    DRUG_INDICATION.max_phase_for_ind\nFROM MOLECULE_DICTIONARY\nJOIN DRUG_INDICATION ON MOLECULE_DICTIONARY.molregno == DRUG_INDICATION.molregno\n'

A SQL query for all drug-indication relationships