COUNT_QUERY_SQL

COUNT_QUERY_SQL = 'SELECT COUNT(MOLECULE_DICTIONARY.chembl_id) as count\nFROM MOLECULE_DICTIONARY\nJOIN COMPOUND_STRUCTURES ON MOLECULE_DICTIONARY.molregno == COMPOUND_STRUCTURES.molregno\nWHERE molecule_dictionary.pref_name IS NOT NULL\n'

Old name