0)? "WHERE FIND_IN_SET('" . intval($_REQUEST['sportid']) . "', news.sport_id)" : '';
if (!empty($filter) AND $_REQUEST['authorid'] > 0)
{
$filter .= " AND FIND_IN_SET('" . intval($_REQUEST['authorid']) . "', news.author_id)";
}
$pagedata = $vbulletin->db->query_first("
SELECT COUNT(*) AS count
FROM cms_news AS news
INNER JOIN " . TABLE_PREFIX . "thread USING (threadid)
$filter
");
$pagedata['pagenumber'] = (isset($_REQUEST['page']))? intval($_REQUEST['page']) : 1;
$pagedata['minlimit'] = intval(($pagedata['pagenumber'] - 1) * 15);
?>