public static function getForTags(array $ids)
{
// fetch items
$items = (array) FrontendModel::getContainer()->get('database')->getRecords('SELECT i.id, i.title
FROM pages AS i
INNER JOIN meta AS m ON m.id = i.meta_id
WHERE i.status = ? AND i.hidden = ? AND i.language = ? AND i.publish_on <= ? AND i.id IN (' . implode(',', $ids) . ')
ORDER BY i.title ASC', array('active', 'N', LANGUAGE, FrontendModel::getUTCDate('Y-m-d H:i') . ':00'));
// has items
if (!empty($items)) {
// reset url
foreach ($items as &$row) {
$row['full_url'] = FrontendNavigation::getURL($row['id'], LANGUAGE);
}
}
// return
return $items;
}