gistfile1.sql

mysql> select * from user_count order by count desc limit 50;
+------------------+-------+
| user             | count |
+------------------+-------+
| @oracleofmydoc   | 12122 |
| oracleofmydoc    | 12122 |
| @nasa            | 11322 |
| nasa             | 11322 |
| @designsbylilla  | 10626 |
| designsbylilla   | 10626 |
| @loveislove824   | 10171 |
| loveislove824    | 10171 |
| @abercrombie     | 10164 |
| abercrombie      | 10164 |
| @elskemccain     | 10144 |
| elskemccain      | 10144 |
| @wwwbigbaldhead  | 10137 |
| wwwbigbaldhead   | 10137 |
| @onlinemiamidade |  8916 |
| onlinemiamidade  |  8916 |
| @victoriassecret |  8884 |
| victoriassecret  |  8884 |
| @fashionindie    |  8870 |
| fashionindie     |  8870 |
| @classisinternal |  8035 |
| classisinternal  |  8035 |
| @walmart         |  7877 |
| walmart          |  7877 |
| @the_helenkeller |  7342 |
| the_helenkeller  |  7342 |
| @youranonnews    |  6152 |
| youranonnews     |  6152 |
| @etsy            |  5021 |
| etsy             |  5021 |
| @verizonwireless |  4568 |
| verizonwireless  |  4568 |
| @selenagomez     |  4554 |
| selenagomez      |  4554 |
| @derpey          |  3797 |
| derpey           |  3797 |
| @kennethcoleprd  |  3661 |
| kennethcoleprd   |  3661 |
| @gategadget      |  3305 |
| gategadget       |  3305 |
| @menshumor       |  2518 |
| menshumor        |  2518 |
| @andrewchristian |  2337 |
| andrewchristian  |  2337 |
| @target          |  2295 |
| target           |  2295 |
| @ebay            |  2282 |
| ebay             |  2282 |
| @mansionelan     |  2145 |
| mansionelan      |  2145 |
+------------------+-------+
50 rows in set (0.42 sec)