All pastes #592207 Raw Edit

Stuff

public sql v1 · immutable
#592207 ·published 2007-06-27 16:58 UTC
rendered paste body
		$result = $db->query("				SELECT					hlstats_Players.lastName AS name,					Count(hlstats_Frags_Kills.kills) AS kills,					Count(hlstats_Frags_Kills.deaths) AS deaths,					hlstats_Frags_Kills.playerId as victimId,					IFNULL(Count(hlstats_Frags_Kills.kills)/Count(hlstats_Frags_Kills.deaths),						IFNULL(FORMAT(Count(hlstats_Frags_Kills.kills), 2), '-')) AS kpd				FROM					hlstats_Frags_Kills				INNER JOIN					hlstats_Players				ON					hlstats_Frags_Kills.playerId = hlstats_Players.playerId				GROUP BY					hlstats_Frags_Kills.playerId				HAVING					Count(hlstats_Frags_Kills.kills) >= $killLimit				ORDER BY	            $tblPlayerKillStats->sort $tblPlayerKillStats->sortorder,	            $tblPlayerKillStats->sort2 $tblPlayerKillStats->sortorder		");