a.rb

mysql> select a.app_slug, ai.value from addons_installs as ai join addons as a on a.id=ai.addon_id where region=0 order by value desc limit 20;
+---------------------+--------+
| app_slug            | value  |
+---------------------+--------+
| connecta2           | 254311 |
| openwapp            | 184414 |
| facebook-1          | 153012 |
| loqui               | 115818 |
| whatsapp-firefox-os |  70816 |
| line                |  43606 |
| cut-the-rope        |  35570 |
| youtube-1           |  31684 |
| slice-fruits        |  25817 |
| penguin-pop         |  24753 |
| zombie-apocalypse   |  24457 |
| cameran             |  23730 |
| fruit-cut-ninja     |  23662 |
| wonderful-wallpaper |  23510 |
| recorder            |  22498 |
| geeklvl             |  21231 |
| soundcloud          |  21192 |
| file-manager        |  21137 |
| paint-1             |  20148 |
| candy_crush         |  19486 |
+---------------------+--------+
20 rows in set (0.03 sec)