http://www.herogame.org

$query = "select hid,SUM(tot) as supertot from (
select t1.hero_id1 as hid, count(*) as tot
from mh_hero_teacup t1
group by t1.hero_id1
union
select t2.hero_id2 as hid, count(*) as tot
from mh_hero_teacup t2
group by t2.hero_id2) tt2
group by hid
order by supertot desc
limit $DISPLAYED_TOP";

ARGH
rimettere le mani qui dentro è da spararsi