$get_Doubles_leaders=$conn->query(“SELECT P.nameFirst, P.nameLast, P.finalGame, SUM(B.2B) AS Doubles FROM `batting` B, `people` P WHERE B.playerID=P.playerID GROUP BY B.playerID ORDER BY Doubles DESC LIMIT 500”);

echo(“

“);
while($row=$get_Doubles_leaders->fetch_assoc()){
echo(“

“);
}
echo(“

“);

echo(“

$get_active_Doubles_leaders=$conn->query(“SELECT P.nameFirst, P.nameLast, P.finalGame, SUM(B.2B) AS Doubles FROM `batting` B, `people` P WHERE B.playerID=P.playerID AND (LEFT(P.finalGame,4)=’2019′ OR LEFT(P.finalGame,4)=’2018′) GROUP BY B.playerID ORDER BY Doubles DESC LIMIT 500”);

echo(“

“);
while($row=$get_active_Doubles_leaders->fetch_assoc()){
echo(“

“);
}
echo(“

“);

echo(“