public static function getMostRead($limit)
{
$items = (array) FrontendModel::getContainer()->get('database')->getRecords('SELECT i.*, m.url
FROM faq_questions AS i
INNER JOIN meta AS m ON i.meta_id = m.id
WHERE i.num_views > 0 AND i.language = ? AND i.hidden = ?
ORDER BY (i.num_usefull_yes + i.num_usefull_no) DESC
LIMIT ?', array(LANGUAGE, 'N', (int) $limit));
$link = FrontendNavigation::getURLForBlock('Faq', 'Detail');
foreach ($items as &$item) {
$item['full_url'] = $link . '/' . $item['url'];
}
return $items;
}