достать топ лист из phpMyAdmin(loadObjectList()) - Общие вопросы по расширениям Joomla

           $query = 'SELECT a.title' .
                        ' FROM #__redim_starvote AS a' .
                        ' INNER JOIN #__content AS f ON a.id = f.id' .
                        ' ORDER BY (a.total_value/a.total_votes) DESC'.
                        ' LIMIT 10';

            $db->setQuery($query);
            $rows=$db->loadObjectList();


             $i;
             $lists        = array();

             foreach($rows as $row){
                 $lists[$i]->link = htmlspecialchars($row->title) 
                 $i++;
             }



                return $lists;

var_dump($rows);

Array
(
    [0] => 
    [1] => 
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [6] => 
    [7] => 
    [8] => 
    [9] => 
)

		
if ($db->getErrorNum()) {
	JError::raiseError(500, $db->stderr());
}

500 - DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 10' at line 1 SQL=SELECT a.id, f.title FROM lie_redim_starvote AS a INNER JOIN lie_content AS f ON a.id = f.id ORDER BY (a.total_value/a.total_votes) DESC LIMIT 10 LIMIT 0, 10

<?php

// no direct access
defined('_JEXEC') or die('Restricted access');

require_once (JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php');

class modMostReadBySectionOrCategoryHelper
{
function getList(&$params)
{
global $mainframe;

$db =& JFactory::getDBO();
$user =& JFactory::getUser();

$menus = &JSite::getMenu();
$currentMenu = $menus->getActive();
$menuOption=$currentMenu->query['option'];

if($menuOption=='com_content'){
$menuView=$currentMenu->query['view'];
if($menuView=='section'){
$secid=$currentMenu->query['id'];
$secCondition = ' AND a.sectionid='.$secid;
}elseif($menuView=='category'){
$catid=$currentMenu->query['id'];
$catCondition = ' AND a.catid='.$catid;
}
}elseif($menuOption=='com_sectionex'){
$menuView=$currentMenu->query['view'];
if($menuView=='category'){
$secid=$currentMenu->query['id'];
$secCondition = ' AND a.sectionid='.$secid;
}
}

$count = intval($params->get('count', 10));
$show_front = $params->get('show_front', 1);
$aid = $user->get('aid', 0);

$contentConfig = &JComponentHelper::getParams( 'com_content' );
$access = !$contentConfig->get('show_noauth');

$nullDate = $db->getNullDate();
jimport('joomla.utilities.date');
$date = new JDate();
$now = $date->toMySQL();

if ($catid) {
$ids = explode( ',', $catid );
JArrayHelper::toInteger( $ids );
$catCondition = ' AND (cc.id=' . implode( ' OR cc.id=', $ids ). ')';
}
if ($secid) {
$ids = explode( ',', $secid );
JArrayHelper::toInteger( $ids );
$secCondition = ' AND (s.id=' . implode( ' OR s.id=', $ids ). ')';
}

//Content Items only
$query = 'SELECT f.title' .
' FROM #__redim_starvote AS a' .
' INNER JOIN #__content AS f ON a.id = f.id' .
' ORDER BY (a.total_value/a.total_votes) DESC'.
' LIMIT 10';

$db->setQuery($query, 0, $count);
$rows=$db->loadObjectList();



var_dump($rows);
$i=0;
$lists = array();
for ($i=0; $i < 10; $i++) {


$lists[$i] = htmlspecialchars($rows[$i]->f.title);
}

return $lists;
}
}