<?php $sql = "select word, sum(count) as tot from {search_index} group by word order
by tot desc limit 0,10";

$result= db_query($sql);

while ($myrow = db_fetch_object($result)) {
print "word.">".$myrow->word." (".$myrow->tot.")
";
}