Как получить ссылку на статью через дополнительное поле? - Joomla 3.x: Общие вопросы

JRoute::_(ContentHelperRoute::getArticleRoute(slug, catid, language));

SELECT alias, title FROM #__content WHERE id = 1;

SELECT id as value, title as text FROM #__content

$cont = JFactory::getDbo()->setQuery("SELECT `id`, `alias`, `catid`, `language` FROM `#__content` WHERE `catid` = '{$catId}' AND `created_by` = '{$this->item->created_by}'")->loadObject();
$contLink = JRoute::_(ContentHelperRoute::getArticleRoute($cont->slug, $cont->catid, $cont->language));

$cont = JFactory::getDbo()->setQuery($query = "SELECT `id`, `alias`, `catid`, `language` FROM `#__content` WHERE `catid` = '{$catId}' AND `created_by` = '{$this->item->created_by}'")->loadObject();
print_r($query);
print_r($cont);

print_r($this->item);

$catId = 16;
$cont = JFactory::getDbo()->setQuery($query = "SELECT `id`, `alias`, `catid`, `language` FROM `#__content` WHERE `catid` = '{$catId}' AND `created_by` = '{$this->item->created_by}'")->loadObject();
print_r($query);
print_r($cont);

$contLink = JRoute::_(ContentHelperRoute::getArticleRoute($cont->id.':'.$cont->alias, $cont->catid, $cont->language));