Database Error
Server Address: 192.168.1.60
Server Username: kevin
Error Diagnostic:
Bad query.
Server Error: (144) Table './hlstatsx/hlstats_Events_Statsme2' is marked as crashed and last (automatic?) repair failed
Last SQL Query:
SELECT
hlstats_Events_Statsme2.weapon AS smweapon,
SUM(hlstats_Events_Statsme2.head) AS smhead,
SUM(hlstats_Events_Statsme2.chest) AS smchest,
SUM(hlstats_Events_Statsme2.stomach) AS smstomach,
SUM(hlstats_Events_Statsme2.leftarm) AS smleftarm,
SUM(hlstats_Events_Statsme2.rightarm) AS smrightarm,
SUM(hlstats_Events_Statsme2.leftleg) AS smleftleg,
SUM(hlstats_Events_Statsme2.rightleg) AS smrightleg,
SUM(hlstats_Events_Statsme2.head)+SUM(hlstats_Events_Statsme2.chest)+SUM(hlstats_Events_Statsme2.stomach)+
SUM(hlstats_Events_Statsme2.leftarm)+SUM(hlstats_Events_Statsme2.rightarm)+SUM(hlstats_Events_Statsme2.leftleg)+
SUM(hlstats_Events_Statsme2.rightleg) as smhits,
IFNULL(ROUND((SUM(hlstats_Events_Statsme2.leftarm) + SUM(hlstats_Events_Statsme2.leftleg)) / (SUM(hlstats_Events_Statsme2.head) + SUM(hlstats_Events_Statsme2.chest) + SUM(hlstats_Events_Statsme2.stomach) + SUM(hlstats_Events_Statsme2.leftarm ) + SUM(hlstats_Events_Statsme2.rightarm) + SUM(hlstats_Events_Statsme2.leftleg) + SUM(hlstats_Events_Statsme2.rightleg)) * 100, 1), 0.0) AS smleft,
IFNULL(ROUND((SUM(hlstats_Events_Statsme2.rightarm) + SUM(hlstats_Events_Statsme2.rightleg)) / (SUM(hlstats_Events_Statsme2.head) + SUM(hlstats_Events_Statsme2.chest) + SUM(hlstats_Events_Statsme2.stomach) + SUM(hlstats_Events_Statsme2.leftarm ) + SUM(hlstats_Events_Statsme2.rightarm) + SUM(hlstats_Events_Statsme2.leftleg) + SUM(hlstats_Events_Statsme2.rightleg)) * 100, 1), 0.0) AS smright,
IFNULL(ROUND((SUM(hlstats_Events_Statsme2.head) + SUM(hlstats_Events_Statsme2.chest) + SUM(hlstats_Events_Statsme2.stomach)) / (SUM(hlstats_Events_Statsme2.head) + SUM(hlstats_Events_Statsme2.chest) + SUM(hlstats_Events_Statsme2.stomach) + SUM(hlstats_Events_Statsme2.leftarm ) + SUM(hlstats_Events_Statsme2.rightarm) + SUM(hlstats_Events_Statsme2.leftleg) + SUM(hlstats_Events_Statsme2.rightleg)) * 100, 1), 0.0) AS smmiddle
FROM
hlstats_Events_Statsme2
LEFT JOIN hlstats_Players ON
hlstats_Players.playerId=hlstats_Events_Statsme2.playerId
WHERE
clan=57
GROUP BY
hlstats_Events_Statsme2.weapon
HAVING
smhits > 0
ORDER BY
smhits desc,
smweapon desc
|