public function beforeQuery(Atomik_Model_Builder $builder, Atomik_Db_Query $query) { $tableName = $builder->tableName; $primaryKeyName = $builder->getPrimaryKeyField()->name; $foreignFieldName = $this->_prefix($tableName . '_' . $primaryKeyName); $on = sprintf('%s.%s = %s.%s', $this->_suffix($tableName), $foreignFieldName, $tableName, $primaryKeyName); // add a join clause to the query $query->join($this->_suffix($tableName), $on, null, 'LEFT'); }