Untitled
public sql v1 · immutable $result = $db->query(" SELECT p.playerId, p.lastName, p.skill, p.kills, p.deaths, p.IFNULL(kills/deaths, '-') AS kpd FROM hlstats_Players p, hlstates_PlayerUniqueIss u WHERE u.playerID = p.playerId AND p.game='$game' AND p.hideranking=0 AND p.kills >= $minkills AND u.uniqueId NOT LIKE '%BOT%' ORDER BY $table->sort $table->sortorder, $table->sort2 $table->sortorder, lastName ASC LIMIT $table->startitem,$table->numperpage ");