public static function getForTags(array $ids)
{
$items = (array) FrontendModel::getContainer()->get('database')->getRecords('SELECT i.question AS title, m.url
FROM faq_questions AS i
INNER JOIN meta AS m ON m.id = i.meta_id
WHERE i.hidden = ? AND i.id IN (' . implode(',', $ids) . ')
ORDER BY i.question', array('N'));
if (!empty($items)) {
$link = FrontendNavigation::getURLForBlock('Faq', 'Detail');
// build the item urls
foreach ($items as &$row) {
$row['full_url'] = $link . '/' . $row['url'];
}
}
return $items;
}