public function match($str, $limit = 10, $offset = 0)
{
$query = <<<__SQL__
SELECT
it.title,
it.updated_at,
it.open_item_id,
us.email,
us.username
FROM
items_fts fts
INNER JOIN
items it ON it.id = fts.item_id AND it.published = 2
INNER JOIN
users us ON it.user_id = us.id
WHERE
fts.words MATCH :match
ORDER BY
it.updated_at DESC, it.id DESC
LIMIT
{$limit}
OFFSET
{$offset}
__SQL__;
return \DB::select(\DB::raw($query), array('match' => FtsUtils::createMatchWord($str)));
}