public static function search(array $ids)
{
$items = (array) FrontendModel::getContainer()->get('database')->getRecords('SELECT i.id, i.question AS title, i.answer AS text, m.url,
c.title AS category_title, m2.url AS category_url
FROM faq_questions AS i
INNER JOIN meta AS m ON i.meta_id = m.id
INNER JOIN faq_categories AS c ON c.id = i.category_id
INNER JOIN meta AS m2 ON c.meta_id = m2.id
WHERE i.hidden = ? AND i.language = ? AND i.id IN (' . implode(',', $ids) . ')', array('N', LANGUAGE), 'id');
// prepare items for search
$detailUrl = FrontendNavigation::getURLForBlock('Faq', 'Detail');
foreach ($items as &$item) {
$item['full_url'] = $detailUrl . '/' . $item['url'];
}
return $items;
}