Guild in TOP 100

$connect = mssql_connect($host,$user,$pw)
or die("Can't connect to the datebase.");

mssql_select_db($db,$connect)
or die("Can't select the datebase");
mssql_select_db($db,$connect);

$Query="SELECT Top 50 name , exp, lv, job,jlv,permission, login_time,login_time,pkc from TelecasterNot . dbo.Character
where permission ='0' and name not like '@%' and lv > '10' order by exp desc ";

$Result = mssql_query($Query);
?>
</br></br>
<table class="tabclass" >
<tr bgcolor='#000000' align='center' height='30px'>
<td width='5%' bgcolor='#000000'>№</td>
<td width='30%' bgcolor='#000000'>Name</td>
<td width='10%' bgcolor='#000000'>Lvl</td>
<td width='10%' bgcolor='#000000'>PK</td>
<td width='10%' bgcolor='#000000'>Job</td>
<?php
error_reporting( E_ERROR );
while($Row=mssql_fetch_array($Result)){
echo "<tr background='images/2.png' align='center'>";
echo "<td>",$counter,"</td><td color='#1e1e1e'>",$Row["name"],"</td><td>",$Row["lv"],"</td><td>",$Row["pkc"],"</td><td>";

switch ($Row["job"])
{
case 100 : echo "<div align='center'><img src='images/class/100.jpg' alt='Странник'>"; break;
case 101 : echo "<div align='center'><img src='images/class/101.jpg' alt='Кадет'>"; break;
case 102 : echo "<div align='center'><img src='images/class/102.jpg' alt='Шаман'>"; break;
case 103 : echo "<div align='center'><img src='images/class/103.jpg' alt='Заклинатель'>"; break;
case 110 : echo "<div align='center'><img src='images/class/110.jpg' alt='Солдат'>"; break;
case 111 : echo "<div align='center'><img src='images/class/111.jpg' alt='Стрелок'>"; break;
case 112 : echo "<div align='center'><img src='images/class/112.jpg' alt='Друид'>"; break;
case 113 : echo "<div align='center'><img src='images/class/113.jpg' alt='Знахарь'>"; break;
case 114 : echo "<div align='center'><img src='images/class/114.jpg' alt='Колдун'>"; break;
case 120 : echo "<div align='center'><img src='images/class/120.jpg' alt='(Мастер-Класс Солдата)'>"; break;
case 121 : echo "<div align='center'><img src='images/class/121.jpg' alt='(Мастер-Класс Стрелка)'>"; break;
case 122 : echo "<div align='center'><img src='images/class/122.jpg' alt='(Мастер-Класс Друида)'>"; break;
case 123 : echo "<div align='center'><img src='images/class/123.jpg' alt='(Мастер-Класс Знахаря)'>"; break;
case 124 : echo "<div align='center'><img src='images/class/124.jpg' alt='(Мастер-Класс Колдуна)'>"; break;
case 200 : echo "<div align='center'><img src='images/class/200.jpg' alt='Следопыт'>"; break;
case 201 : echo "<div align='center'><img src='images/class/201.jpg' alt='Паладин'>"; break;
case 202 : echo "<div align='center'><img src='images/class/202.jpg' alt='Волшебник'>"; break;
case 203 : echo "<div align='center'><img src='images/class/203.jpg' alt='Зверолов'>"; break;
case 210 : echo "<div align='center'><img src='images/class/210.jpg' alt='Р*ыцарь'>"; break;
case 211 : echo "<div align='center'><img src='images/class/211.jpg' alt='Крестоносец '>"; break;
case 212 : echo "<div align='center'><img src='images/class/212.jpg' alt='Капеллан '>"; break;
case 213 : echo "<div align='center'><img src='images/class/213.jpg' alt='Клирик '>"; break;
case 214 : echo "<div align='center'><img src='images/class/214.jpg' alt='Странник'>"; break;
case 220 : echo "<div align='center'><img src='images/class/220.jpg' alt='(Мастер-Класс Р*ыцаря)'>"; break;
case 221 : echo "<div align='center'><img src='images/class/221.jpg' alt='(Мастер-Класс Крестоносца)'>"; break;
case 222 : echo "<div align='center'><img src='images/class/222.jpg' alt='(Мастер-Класс Каппелана)'>"; break;
case 223 : echo "<div align='center'><img src='images/class/223.jpg' alt='(Мастер-Класс Клирика)'>"; break;
case 224 : echo "<div align='center'><img src='images/class/224.jpg' alt='(Мастер-Класс Дрессировщика)'>"; break;
case 300 : echo "<div align='center'><img src='images/class/300.jpg' alt='Бродяга'>"; break;
case 301 : echo "<div align='center'><img src='images/class/301.jpg' alt='Наемник'>"; break;
case 302 : echo "<div align='center'><img src='images/class/302.jpg' alt='Неофит'>"; break;
case 303 : echo "<div align='center'><img src='images/class/303.jpg' alt='Адепт'>"; break;
case 310 : echo "<div align='center'><img src='images/class/310.jpg' alt='Ассасин '>"; break;
case 311 : echo "<div align='center'><img src='images/class/311.jpg' alt='Охотник '>"; break;
case 312 : echo "<div align='center'><img src='images/class/312.jpg' alt='Маг хаоса'>"; break;
case 313 : echo "<div align='center'><img src='images/class/313.jpg' alt='Чернокнижник '>"; break;
case 314 : echo "<div align='center'><img src='images/class/314.jpg' alt='Чародей'>"; break;
case 320 : echo "<div align='center'><img src='images/class/320.jpg' alt='(Мастер-Класс Ассасина)'>"; break;
case 321 : echo "<div align='center'><img src='images/class/321.jpg' alt='(Мастер-Класс Охотника)'>"; break;
case 322 : echo "<div align='center'><img src='images/class/322.jpg' alt='(Мастер-Класс Мага Хаоса)'>"; break;
case 323 : echo "<div align='center'><img src='images/class/323.jpg' alt='(Мастер-Класс Чернокнижника)'>"; break;
case 324 : echo "<div align='center'><img src='images/class/324.jpg' alt='(Мастер-Класс Чародея)'>"; break;
}
echo "</div></td></tr>";
if ($counter==100)
break;
else
$counter++;
}
echo "</table>";
mssql_close($connect);
?>
</div>
</p>
</div>

USE Telecaster

SELECT Top 50
CH.name AS name,
CH.lv AS lv,
CH.job AS job,
CH.pkc AS pkc,
G.name as guild_name,
G.icon as guild_icon
FROM dbo.Character CH LEFT JOIN dbo.GuildMember GM
ON CH.sid = GM.player_id
LEFT JOIN dbo.Guild G
ON G.sid = GM.guild_id
WHERE
CH.permission =0 AND
CH.name NOT LIKE '@%' AND
CH.lv > 10
ORDER BY CH.exp DESC