Ideabout
a simple site for sharing ideas

 
   

 

 

tech tantra thursday
   - behind the cosmic curtain with Bill Eberle

prev/first       next/last       toc

 

for thursday june 23, 2011    ← prev    ( 4 )    next →

Cosmic Encounter® Online at Facebook     illustration

    Ranking Details        Statistics Details

 

All Time Top Aliens for Players

SQL

select t.ce_text, sum(ar_plr_mrics) 'total'
from alien a inner join alien_rank ar on a.alien_code = ar.ar_alien_code
   inner join ce_text t on a.alien_name_id = t.ce_text_id
group by t.ce_text order by sum(ar_plr_mrics) desc limit 10;

 

Results (as of June 22, 2011)

RankAlienM-rics
.......................................................
 1Sorcerer682,411
 2Virus665,807
 3Pacifist661,491
 4Loser645,761
 5Trader553,563
 6Anti-Matter552,893
 7Warpish545,283
 8Filch542,541
 9Warrior541,771
10Empath515,652

 

. . . continued . . . Who Are the All Time Top Alien Bots?

 

for thursday june 23, 2011    ← prev    ( 4 )    next →

 

 

Cosmic Encounter® Online at Facebook     illustration

 

 

 

events        prev/first        next/last        tech tantra

 

 

just thinking . . . for fun