Ris

You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MariaDB server version FOR the RIGHT syntax TO USE near '-history_cats i WHERE (i.parent_id = '1') ORDER BY i.ns_left' at line 2
 
SELECT i.*
FROM cms_con_story-history_cats i
WHERE (i.parent_id = '1')
ORDER BY i.ns_left 

      public function getBest($ctype_name, $dataset)
	  {
		 if ($dataset == 'bestweek') {if (date("H")<20)
        {
        $dfrom = date("Y-m-d H:i:s",mktime(20, 0, 0, date("m")  , date("d")-9, date("Y")));
        $dto =  date("Y-m-d H:i:s",mktime(19, 59, 59, date("m")  , date("d"), date("Y")));
        }
        else
        {
        $dfrom = date("Y-m-d H:i:s",mktime(20, 0, 0, date("m")  , date("d")-7, date("Y")));
        $dto =  date("Y-m-d H:i:s",mktime(19, 59, 59, date("m")  , date("d")+1, date("Y")));
        } 
 
		  $sql = "SELECT target_id, SUM(score) as points FROM cms_rating_log WHERE target_subject = 'anec' AND votedate BETWEEN '$dfrom' AND NOW() 
		   GROUP BY target_id ORDER BY points DESC LIMIT 0, 15";
		 } else {
		 if (date("H")<20)
{
$dfrom = date("Y-m-d H:i:s",mktime(20, 0, 0, date("m")  , date("d")-3, date("Y")));
 
$dto =  date("Y-m-d H:i:s",mktime(19, 59, 59, date("m")  , date("d")-1, date("Y")));
}
else
{
$dfrom = date("Y-m-d H:i:s",mktime(20, 0, 0, date("m")  , date("d")-1, date("Y")));
$dto =  date("Y-m-d H:i:s",mktime(19, 59, 59, date("m")  , date("d"), date("Y")));
}
$sql="Select  target_id, sum(score) as points From cms_rating_log  Where votedate Between '$dfrom' And '$dto' Group by target_id Order by points DESC LIMIT 15";
	  }
	    $items = array();
		$arr = $this->db->query($sql);
		while ($joke = mysqli_fetch_assoc($arr)){
		global $points;
		$id = $joke['target_id'];
        $points = $joke['points'];		
		$table_name = $this->table_prefix . $ctype_name;
 
        $this->select('u.nickname', 'user_nickname');
 
        $this->join('cms_users', 'u', 'u.id = i.user_id');
 
        $this->useCache("content.item.{$ctype_name}");
 
        $item = $this->getItemByField($table_name, 'id', $id, function($item, $model){
            global $points;
            $item['user'] = array(
                'id' => $item['user_id'],
                'nickname' => $item['user_nickname']
            );
			$item['rating'] = $points;
 
 
            return $item;
 
        }, 'id');
        $items[] = $item;
		unset ($points);
    }
 
    return $items;
 
        }
 
}

		if ($dataset == 'bestyesterday' || $dataset == 'besttoday'){
		$items = $this->model->getBest($ctype['name'], $dataset);
		$total = 15;} else {	
        $total = $this->model->getContentItemsCount($ctype['name']);
        $items = $this->model->getContentItems($ctype['name']);
		}