UsersNoLogin-ZF1.12.9.php

<?php  
/**
 * After making necessary ZF 1.12.8 changes
 */
$nameColumn = new Zend_Db_Expr("trim(concat_ws(' ', user.nameprefix, user.firstname, user.lastname)) as name");  
$select = $this->getDbTable()->select();  
$select->from(  
  $this->_getDbTable()->info(Zend_Db_Table_Abstract::NAME),  
    array(  
      $nameColumn,  
      "user.email",  
      // more data similar to 'user.email'  
    )
);