Проблема вывода пользователей с сортировкой по полю связанной таблицы

 
$this->select("IFNULL(wc.user_stat, '')", 'points');
$this->joinLeft('user_stat', 'wc', 'wc.id = i.id');
 

 
$datasets['points'] = array(
  'name' => 'points',
  'title' => 'Очки',
  'order' => array('points', 'desc')
 );  
 

 
$this->select("IFNULL(wc.balance, 0)", 'club_balance');
$this->select("IFNULL(wc.id, 0)", 'user_id');
$this->joinLeft('wotmod_player_clubstat', 'wc', 'wc.id = i.id'); 
 

 
$datasets['club_balance'] = array(
                'name' => 'points',
                'title' => 'Самые богатые',
                'order' => array('club_balance', 'desc')
        ); 
 

 
Ошибка в запросе БД:
 
Unknown column 'i.club_balance' in 'order clause'
SELECT i.*, IFNULL(c.name, '') as city_name, IFNULL(c.id, 0) as city_id, IFNULL(wc.balance, 0) as club_balance, IFNULL(wc.id, 0) as user_id
FROM cms_users i
LEFT JOIN cms_geo_cities as c ON c.id = i.city
LEFT JOIN cms_wotmod_player_clubstat as wc ON wc.id = i.id
ORDER BY i.club_balance desc
LIMIT 0, 15
 
Последние вызовы:
 
    get() @ /var/www/system/controllers/users/model.php : 54
    getUsers() @ /var/www/system/controllers/users/frontend.php : 197
    renderProfilesList()
    call_user_func_array() @ /var/www/system/core/action.php : 29
    __call() @ /var/www/system/controllers/users/actions/index.php : 35
    renderProfilesList() @ /var/www/system/controllers/users/actions/index.php : 35
    run()
    call_user_func_array() @ /var/www/system/core/controller.php : 276
    runExternalAction() @ /var/www/system/core/controller.php : 207
    runAction() @ /var/www/system/core/core.php : 616
    runController() @ /var/www/index.php : 37