Для Joomla 1.5

<?php
require_once (JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php'); // если нужно вывести в модуле

$view = JRequest::getVar('view', null);
$layout = JRequest::getVar('layout', null);
$limitstart = JRequest::getVar('limitstart', null);
$cattid = $this->category->id;
if($view=='category' && $layout=='blog' && $limitstart !='') {
    $db =& JFactory::getDBO();
    $query = $db->getQuery(true);
    $query = 'SELECT a.*, ' .
            ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,'.
            ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug'.
            ' FROM #__content AS a' .
            ' INNER JOIN #__categories AS cc ON cc.id = a.catid' .
            ' INNER JOIN #__sections AS s ON s.id = a.sectionid' .
            ' WHERE `catid`='.$cattid.' AND `state` > 0 ORDER BY id DESC LIMIT 5';
    $db->setQuery($query);
    $res= $db->loadObjectList();
        echo '<div style="clear:both;"></div><ul class="additional_ul">';
        foreach ($res as $concert) {
            echo '<li>';
            echo '<a href="'.JRoute::_(ContentHelperRoute::getArticleRoute($concert->slug, $concert->catslug, $concert->sectionid)).'">'.$concert->title.'</a>';
            echo '</li>';
        }
        echo '</ul>';
}
?>




Joomla 2.5

<?php
$db =& JFactory::getDBO();
$query = $db->getQuery(true);
$query = 'SELECT a.*, ' .
    ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,'.
    ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug'.
    ' FROM #__content AS a' .
    ' INNER JOIN #__categories AS cc ON cc.id = a.catid' .
    ' WHERE `catid`='.$cattid.' AND `state` > 0 ORDER BY id DESC LIMIT 5';
$db->setQuery($query);
$res= $db->loadObjectList();
echo '<div style="clear:both;"></div><ul class="additional_ul">';
    foreach ($res as $concert) {
        echo '<li>';
        echo '<a href="'.JRoute::_(ContentHelperRoute::getArticleRoute($concert->id)).'">'.$concert->title.'</a>';
        echo '</li>';
    }
echo '</ul>';
?>