Meu site numa tabela de top frag guilds tem essa tag:

<ul>
									<?
										foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
											`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags`
										FROM `killers` k
											LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
											LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
											LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
											LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
										WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
											GROUP BY `name`
											ORDER BY `frags` DESC, `name` ASC
											LIMIT 0, 5;') as $guild)
										echo '<li><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '">' . $guild['name'] . '&nbsp;&nbsp;&nbsp;(' . $guild['frags'] . ' kills)</a></li>';
									?>
								</ul>

Porem no site, na tabela, fica um erro enorme, e não aparece as tops guilds... porq?

erro:

query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, `g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0, 5;') as $guild) echo '
    ' . $guild['name'] . '   (' . $guild['frags'] . ' kills)
    '; ?> 

Coloque o erro ...