Вопрос по API Joomla и выполнение двух запросов - Joomla 1.5: Общие вопросы

  $query1 = sprintf("SELECT SUM(me.event_sum) AS value, p.firstname, p.lastname, t.short_name as team, p.id as id
            FROM #__joomleague_match_events AS me
            LEFT JOIN #__joomleague_players AS p ON me.player_id = p.id  
            LEFT JOIN #__joomleague_playertool AS pt ON me.player_id = pt.player_id AND pt.project_id = me.project_id
            LEFT JOIN #__joomleague_teams AS t ON pt.team_id = t.id
            LEFT JOIN #__joomleague_team_joomleague AS teamtool ON teamtool.team_id = t.id AND teamtool.project_id = me.project_id
            LEFT JOIN #__joomleague_divisions AS jldiv ON jldiv.id = teamtool.division_id		
           WHERE  
                 me.event_type_id =%s AND 
                 me.project_id =%s AND
                 ( jldiv.id = $division OR jldiv.parent_id = $division )
        GROUP BY p.id
        ORDER BY value DESC  LIMIT 0 , %s",$eventtype ,$project->id, $limit); 

$database->setQuery($query);


$query2= sprintf("SELECT (SUM(ch.vote_rating) / COUNT(ch.vote_rating)) as star, SUM(me.event_sum) AS value2
            FROM #__joomleague_match_events AS me
            LEFT JOIN #__joomleague_players AS p ON me.player_id = p.id  
            LEFT JOIN #__joomleague_playertool AS pt ON me.player_id = pt.player_id AND pt.project_id = me.project_id
            LEFT JOIN #__joomleague_teams AS t ON pt.team_id = t.id
            LEFT JOIN #__joomleague_team_joomleague AS teamtool ON teamtool.team_id = t.id AND teamtool.project_id = me.project_id
            LEFT JOIN #__joomleague_divisions AS jldiv ON jldiv.id = teamtool.division_id	
			LEFT JOIN #__joomleague_chara AS ch ON me.player_id = ch.id_hock
           WHERE  
		   me.player_id = ch.id_hock AND
                 me.event_type_id =%s AND 
                 me.project_id =%s AND
                 ( jldiv.id = $division OR jldiv.parent_id = $division )
        GROUP BY p.id
        ORDER BY value2 DESC  LIMIT 0 , %s",$eventtype ,$project->id, $limit);
$database->setQuery($query);

?>
    
    <table width="100%" align="center" border="0" cellpadding="2" cellspacing="0">
    <?php
      				
        $k = 0;
        foreach($rows as $row){
        
          $class = ($k == 0)? 'sectiontableentry1' : 'sectiontableentry2';
        
    ?>
      <tr class="<?php print $class;?>">
        <td align="left"><a class="link_prof" href="http://www.amurteam.ru/component/option,com_joomleague/func,showPlayer/lang,ru/p,1/pid,<?php echo $row->id;?>"><?php echo sprintf("%s %s",$row->firstname, $row->lastname);?></a></td>
        <td class="stars"><div class="st"><?php echo floor($row->star);?></div></td>
        <td align="left"><?php echo $row->value;?></td>

 <tr class="<?php print $class;?>">
        <td align="left"><a class="link_prof" href="http://www.amurteam.ru/component/option,com_joomleague/func,showPlayer/lang,ru/p,1/pid,<?php echo $row1->id;?>"><?php echo sprintf("%s %s",$row1->firstname, $row1->lastname);?></a></td>
        <td class="stars"><div class="st"><?php echo floor($row2->star);?></div></td>
        <td align="left"><?php echo $row1->value;?></td>

echo 'Первый запрос<br />';
var_dump ($rows1);
echo 'Второй запрос<br />';
var_dump ($rows2);

if (! $rows = $database->loadObjectList()){

if (! $rows1  || ! $rows2){{

 $k = 0;
 $i = 0;
        foreach($rows1 as $row1){
            if ($rows2[$i])  $row2 = $rows2[$i];
            ......
            $i++;