public static function getFaqsForCategory($id)
{
$items = (array) FrontendModel::getContainer()->get('database')->getRecords('SELECT i.id, i.category_id, i.question, i.hidden, i.sequence, m.url
FROM faq_questions AS i
INNER JOIN meta AS m ON i.meta_id = m.id
WHERE i.language = ? AND i.category_id = ?
ORDER BY i.sequence ASC', array(LANGUAGE, (int) $id));
$link = FrontendNavigation::getURLForBlock('Faq', 'Detail');
foreach ($items as &$item) {
$item['full_url'] = $link . '/' . $item['url'];
}
return $items;
}