Anonymous

$sql = "SELECT COUNT(*) , scoretracker_scores.username
			FROM scoretracker_scores
			JOIN scoretracker_charts
			WHERE `scoretracker_charts`.`id` = `scoretracker_scores`.`chartid`
			AND `scoretracker_charts`.`hard` = '1'
			GROUP BY `scoretracker_scores`.`username`
			ORDER BY COUNT( * ) DESC ";