[Modern AAC] Searching for a Query

$allM4 = $connection->query ('SELECT `name` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ORDER BY `[COLOR="red"]sword[/COLOR]` DESC LIMIT 1')->fetch();

SELECT p.name, ps.value as Sword 
FROM players as p JOIN player_skills as ps
WHERE ps.player_id = p.id and ps.skillid = 2 AND rank_id IN (SELECT id FROM guild_ranks WHERE guild_id = 5) ORDER by Sword DESC Limit 1

$allM4 = $connection->query ('SELECT `p`.`name`, `ps`.`value` AS `Sword` FROM `players` AS `p` JOIN `player_skills` AS `ps` WHERE `ps`.`player_id` = `p`.`id` AND `ps`.`skillid` = `2` AND `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ORDER BY `Sword` DESC Limit 1')->fetch();

$allM5 = $connection->query ('SELECT `p`.`name` AS `Name`, `ps`.`value` AS `Sword` FROM `players` AS `p` JOIN `player_skills` AS `ps` WHERE `ps`.`player_id` = `p`.`id` AND `ps`.`skillid` = 2 AND `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ORDER BY `Sword` DESC Limit 1')->fetch();
echo "".$allM5[0]." has sword fighting lvl ".$allM5[1]." and its biggest in our guild.";

$skills = array(
0 => "Fist Fighting",
1 => "Club Fighting",
2 => "Sword Fighting",
3 => "Axe Fighting",
4 => "Distance Fighting",
5 => "Shielding",
6 => "Fishing"
);


foreach($skills as $key => $value)
{ 
$allM5 = $connection->query ('SELECT `p`.`name` AS `Name`, `ps`.`value` AS `Sword` FROM `players` AS `p` JOIN `player_skills` AS `ps` WHERE `ps`.`player_id` = `p`.`id` AND `ps`.`skillid` = '.$key.' AND `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ORDER BY `Sword` DESC Limit 1')->fetch();
echo "".$allM5[0]." has ".$allM5[1]." : ".$value."<br>";
}