$sql = "
SELECT
`News`.*,
Match(News.Title) Against('$q' IN BOOLEAN MODE) as titleTotal,
Match(News.Content) Against('$q' IN BOOLEAN MODE) as contentTotal
FROM
`News`
LEFT JOIN `NewsSiteURL` as siteURL
ON
siteURL.`ID` = `News`.`mySiteURLID`
WHERE
Match(News.Title) Against('$q' IN BOOLEAN MODE)
OR
Match(News.Content) Against('$q' IN BOOLEAN MODE)
ORDER BY
`Created` DESC, titleTotal +contentTotal DESC
LIMIT $limit
";
if($reponse = @DB::query($sql)){
$news = singleton('News')->buildDataObjectSet($reponse);
}
else{
$news = null;
}