Вывод всех статей автора - Разработка расширений для Joomla

Как то так:

Код: php

$db = JFactory::getDbo();
$nullDate = $db->quote( $db->getNullDate() );
$nowDate = $db->quote( JFactory::getDate()->toSql() );
$authorId = 123;
$query = $db->getQuery( true )->select( 'a.id, a.title, a.alias, a.created, a.introtext, a.images, a.catid, a.attribs, a.hits' )
	->from( '#__content AS a' )
	->where( 'a.published=1' )
	->where( 'a.created_by=' . $authorId )
	->group( 'a.id' )
	->where( '(a.publish_up = ' . $nullDate . ' OR a.publish_up <= ' . $nowDate . ')' )
	->where( '(a.publish_down = ' . $nullDate . ' OR a.publish_down >= ' . $nowDate . ')' )
	->order( 'a.created DESC' );
$list = $db->setQuery( $query )->loadObjectList();
foreach ( $list as $item ) {
	echo '<p>' . $item->title . '</p>';
}