SQL запрос - Joomla 1.5: Общие вопросы

<?php

// no direct access
defined('_JEXEC') or die('Restricted access');

$db =& JFactory::getDBO();

$sql = "SELECT a.title  
FROM #__content AS a
LEFT JOIN #__jcomments AS b ON a.id = b.object_id
ORDER BY object_id DESC"
;

$db->setQuery($sql);
$db->query();
echo $db->loadResult();

?>

$db->setQuery($sql);
$results = $db->loadObjectList();
foreach ($results as $result) {
echo $result->title;
}

<?php
defined('_JEXEC') or die('Restricted access');

$user =& JFactory::getUser();
$db =& JFactory::getDBO();

$sql = 'SELECT b.title  
FROM #__jcomments AS a
LEFT JOIN  #__content AS b ON a.object_id = b.id 
WHERE a.userid = ' . (int) $user->id;
$db->setQuery($sql);
$results = $db->loadObjectList();

if ($results) {
foreach ($results as $result) {
echo $result->title;
}
}
?>

<?php
defined('_JEXEC') or die('Restricted access');

$user =& JFactory::getUser();
$db =& JFactory::getDBO();

$sql = 'SELECT b.title  
FROM #__jcomments AS a
LEFT JOIN  #__content AS b ON a.object_id = b.id
LEFT JOIN  #__relatedselects_urls AS c ON b.title = c.url_name 
WHERE b.sectionid = 8
AND a.userid = ' . (int) $user->id;
$db->setQuery($sql);
$results = $db->loadObjectList();

if ( sizeof( $results ) ) {
echo '<ul class="jclist'.$params->get( 'moduleclass_sfx' ).'">';
foreach ($results as $result) {
echo '<li>' .$result->title.'</li>';
}
echo '</ul>';
		}
?>