Database Error
Server Address: 176.126.167.7
Server Username: mwa
Error Diagnostic:
Bad query.
Server Error: (144) Table './stats1/hlstats_Events_Frags' is marked as crashed and last (automatic?) repair failed
Last SQL Query:
SELECT
hlstats_Events_Frags.weapon,
hlstats_Weapons.name,
COUNT(hlstats_Events_Frags.weapon) AS kills,
SUM(hlstats_Events_Frags.headshot=1) as headshots
FROM
hlstats_Events_Frags
INNER JOIN
hlstats_Weapons
ON
hlstats_Weapons.code = hlstats_Events_Frags.weapon
INNER JOIN
hlstats_Players
ON
hlstats_Events_Frags.killerId=hlstats_Players.playerId
WHERE
clan=17
AND
hlstats_Weapons.game='css'
GROUP BY
hlstats_Events_Frags.weapon
ORDER BY
kills desc, headshots desc
LIMIT 1
|