Error Diagnostic:
Bad query.

Server Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND connected > 0 GROUP BY team ORDER BY' at line 8

Last SQL Query:

select team, name, teamkills, teamdeaths, teamheadshots, teamping, teamskill, teamshots,
                                teamhits, teamjointime, playerlist_bgcolor, playerlist_color, playerlist_index
                                FROM hlstats_Teams, (SELECT team, sum(kills) as
                                        "teamkills", sum(deaths) as "teamdeaths",
                                        sum(headshots) as "teamheadshots", avg(ping/2) as "teamping",
                                        avg(skill) as "teamskill", sum(shots) as "teamshots",
                                        sum(hits) as "teamhits", sum(unix_timestamp(NOW()) - connected) as "teamjointime"
                                         from hlstats_Livestats WHERE server_id =  AND connected > 0
                                        GROUP BY team ORDER BY teamkills) teaminfo
                                WHERE code = team and hlstats_Teams.game = "" ORDER BY playerlist_index