messo

published by joe

alla porta



martedì, luglio 01, 2008

and the winner is.....

TOP 3 on PLEX
mysql> select destination,count(*) from cdrs20080701 where direction='MT' group by destination having count(*) >20 order by count(*) desc;

+----------------+----------+
| destination | count(*) |
+----------------+----------+
| 00393467732xxx | 6324 |
| 00393386259yyy | 6320 |
| 00393923210zzz | 5451 |

TOP 3 WEB

| 00393386259yyy | 8718 |
| 00393467732xxx | 8665 |
| 00393896877kkk | 6713 |

posted by io @ 1:56 PM