Вообщем решил вопрос по своему:
Добавил в
"catalog\model\catalog\information.php" функцию
public function getInformationAdd($information_id) {
$query = $this->db->query("SELECT DISTINCT *, (SELECT keyword FROM " . DB_PREFIX . "url_alias WHERE query = 'information_id=" . (int)$information_id . "') AS keyword FROM " . DB_PREFIX . "information i LEFT JOIN " . DB_PREFIX . "information_description id ON (i.information_id = id.information_id) LEFT JOIN " . DB_PREFIX . "information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '" . (int)$information_id . "' AND id.language_id = '" . (int)$this->config->get('config_language_id') . "' AND i2s.store_id = '" . (int)$this->config->get('config_store_id') . "' AND i.status = '1'");
return $query->row;
}
Вызывают просто в
$page = $this->model_catalog_information->getInformationAdd($information_id);
теперь, при вызове
print_rArray
(
[information_id] => 9
[bottom] => 0
[sort_order] => 5
[status] => 1
[language_id] => 1
[title] => 'Заголовок страницы'
[description] => ''
[meta_title] => 'Заголовок страницы в метатеге'
[meta_description] =>
[meta_keyword] =>
[store_id] => 0
[keyword] => 'zagolovok-stranitzi'
)
И
[keyword] - нужный мне
seo_url.