public static function get(SugarBean $bean) { $query = new SugarQuery(); $query->from(BeanFactory::get('dm_DedupeHashes')); $query->select('id'); $dupeRules = $query->join('dm_duplicaterules_dm_dedupehashes')->joinName(); $query->where()->equals("{$dupeRules}.bean_module", $bean->module_name); $query->where()->equals("bean_id", $bean->id); $GLOBALS['log']->error("Getting Dedupe Hashes"); $GLOBALS['log']->error($query->compileSQL()); $results = $query->execute(); return $results; }