lekki problem z php

[redbull915]

zrobiłem zapytania do bazy

$player = $SQL->query('SELECT rank_id FROM players;')
$rank_id = $SQL->query('SELECT guild_id FROM guild_ranks WHERE id = '.$player['rank_id'].';')
$guild = $SQL->query('SELECT name, id FROM guilds WHERE id = '.$rank_id['guild_id'].';')

lecz moim zdaniem jest to przesada ze by używać trzech zapytani jak można jedno użyć, ale tu mam problem nie bardzo wiem jak to przerobić w jedno, wzorowałem się na tym: http://otland.net/f118/0-3-6-0-4-top-fragers-top-guilds-one-database-query-68893/, ale nie szlo mi coś chciałem to użyć w tym.

$member = 0;
foreach($SQL->query('SELECT `total_frags`, `name`, `level`, `vocation`, `promotion`, `world_id`, `online`, `account_id`, `rank_id` FROM `players` WHERE account_id != 1 AND group_id < '.$config['site']['players_group_id_block'].' AND deleted = 0 ORDER BY `total_frags` DESC LIMIT 0,50;') as $player)
{
	$account = $SQL->query('SELECT * FROM `accounts` WHERE '.$SQL->fieldName('id').' = '.$player['account_id'].'')->fetch();
	$guilds = $SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name` FROM `players` p LEFT JOIN `guild_ranks` gr ON `p`.'.$player['rank_id'].' = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1;')->fetch();
	$member++;
	if($player['rank_id'] > 0)
		$guild .= '<br><small><a href="?subtopic=guilds&action=show&guild='.$guilds['id'].'">'.$guilds['name'].'</a></small>';
	$main_content .= '<tr bgcolor="'.(is_int($member / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']).'">
		<td style="text-align: center;">'.$member.'</td>
		<td><image src="http://otland.net/images/flags/'.$account['flag'].'.png" width="16" height="10" border="1"/> <a href="?subtopic=characters&name='.urlencode($player['name']).'">'.($player['online']>0 ? "<font color=\"green\">".$player['name']."</font>" : "<font color=\"red\">".$player['name']."</font>").'</a><br><small>Level: '.$player['level'].', '.$vocation_name[$player['world_id']][$player['promotion']][$player['vocation']].'</small>'.$guild.'</td>
		<td style="text-align: center;">Killed '.$player['total_frags'].' people.<br>'.placeImages($player['total_frags']).'</td>
	</tr>';
}

mój błąd polega na tym, ze nie wiem co z tym ustrojstwem zrobić:

WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1