COUNT_NAMED_COMPOUNDS_SQL

COUNT_NAMED_COMPOUNDS_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'

Return the count of molecules