Quick update... Scott Reynen noticed duplicates which came about because I wasn't properly getting the usage data.
This is an important catch because now that the query is improved we can see that the http://drupal.org/project/buymeabeer module is in need of a co-maintainer. New data: mysql> select n.nid, n.title, sum(p.count) from node n inner join term_node tn on n.nid = tn.nid inner join project_usage_week_project p on n.nid = p.nid inner join project_release_nodes prn on n.nid = prn.pid where tn.tid = 9990 and timestamp = 1334448000 and prn.version_extra is null group by n.nid, n.title having sum(p.count) > 500 order by sum(p.count) desc; +---------+----------------------------------------------------------------------+--------------+ | nid | title | sum(p.count) | +---------+----------------------------------------------------------------------+--------------+ | 8404 | CAPTCHA | 27994176 | | 258223 | Node export | 9459744 | | 63905 | Content Templates (Contemplate) | 9307161 | | 26416 | Simplenews | 7889904 | | 69051 | Login Destination | 6396540 | | 506436 | Omega - Responsive HTML5 Base Theme | 6146847 | | 103123 | Fivestar | 5977650 | | 3724 | Taxonomy menu | 4338312 | | 107191 | Web File Manager | 4257360 | | 193248 | Advanced Forum | 3925824 | | 89309 | Boost | 3289312 | | 55200 | Lightbox2 | 2994068 | | 112767 | Twitter | 2736456 | | 9058 | Nodewords: D6 Meta Tags | 2577360 | | 43047 | Nice Menus | 2224368 | | 247345 | Shadowbox | 2010930 | | 20967 | Invite | 1851300 | | 138844 | Auto Assign Role | 1308372 | | 38678 | Nodequeue | 1289756 | | 3279 | Privatemsg | 1088868 | | 328228 | Module Filter | 896400 | | 253481 | Storm | 895965 | | 286610 | File (Field) Paths | 830592 | | 465844 | Libraries API | 810018 | | 731212 | Custom Search | 774360 | | 73594 | SpamSpan filter | 716404 | | 774050 | MediaFront | 660858 | | 8121 | Taxonomy Image | 619976 | | 279576 | Fast Gallery | 612000 | | 349872 | Author Pane | 598640 | | 102776 | Advertisement | 587316 | | 1141686 | KCFinder integration | 586740 | | 247048 | Node Convert | 556080 | | 246513 | Block Class | 505410 | | 33591 | GMap Module | 473616 | | 1017248 | Field Slideshow | 449260 | | 192744 | CCK Blocks | 446859 | | 25974 | Similar Entries | 429000 | | 70707 | Chat Room | 427630 | | 215311 | MailChimp | 423252 | | 209591 | Imagefield Crop | 409276 | | 380298 | IMCE Wysiwyg bridge | 408828 | | 277490 | View reference | 391170 | | 670520 | Custom Formatters | 371680 | | 172915 | Hierarchical Select | 366234 | | 144819 | Content Access | 361242 | | 65961 | GeSHi Filter for syntax highlighting | 351407 | | 710994 | Content locking (anti-concurrent editing) | 334866 | | 16617 | Front Page | 319400 | | 447028 | Corresponding node references | 312708 | | 74767 | Computed Field | 299304 | | 261287 | Translation Overview | 279000 | | 19699 | freelinking | 266070 | | 256865 | Plugin Manager | 262500 | | 118128 | Classified Ads | 242928 | | 488352 | Skinr | 230797 | | 262984 | Ubercart Addresses | 221200 | | 198285 | HTML Purifier | 210936 | | 321353 | Finder | 202776 | | 1087170 | Geofield | 200394 | | 114662 | Birthdays | 195398 | | 385312 | Select (or other) | 189472 | | 365308 | Term Fields | 183060 | | 3219 | Amazon Module | 182448 | | 90667 | Exif | 171810 | | 333324 | Sheetnode | 169596 | | 30885 | Invisimail | 167688 | | 1088348 | Taxonomy Term Reference Tree Widget | 165600 | | 985370 | References | 164108 | | 167500 | Panels Tabs | 155792 | | 221788 | Menu Breadcrumb | 153875 | | 210180 | RootCandy | 145960 | | 480022 | Support Ticketing System | 137088 | | 434198 | IE Unlimited CSS Loader | 134952 | | 78967 | CAS | 126592 | | 15109 | LDAP integration | 124668 | | 512396 | Ink Ribbon | 121770 | | 448656 | Follow | 121128 | | 811698 | Translation Management | 115416 | | 327649 | Glossify Internal Links Auto SEO | 112500 | | 80382 | Path redirect | 109808 | | 578084 | ImageField Extended | 106710 | | 180902 | Blueprint | 103950 | | 676340 | Clock | 102432 | | 413832 | Visitors | 101996 | | 116949 | Taxonomy Super Select (TSS) | 101052 | | 50589 | Case Tracker | 96120 | | 241442 | Rotor Banner | 94415 | | 280990 | Image FUpload | 91560 | | 712262 | SexyBookmarks | 89664 | | 3778 | TrackBack | 89596 | | 1282854 | TagCloud | 87048 | | 518250 | Cuf?n | 74384 | | 125230 | Multiselect | 73262 | | 283087 | DraggableViews | 73158 | | 766022 | JW Player Module for Drupal | 72320 | | 413588 | Menu Access | 71460 | | 379032 | Ubercart Discounts (Alternative) | 70890 | | 448520 | Webform Block | 70794 | | 342154 | Galleria | 66654 | | 244140 | Google Search Appliance | 62730 | | 40956 | Taxonomy Redirect | 62368 | | 616078 | TableField | 61956 | | 352460 | Advanced Taxonomy Blocks | 61908 | | 105916 | Coder | 61770 | | 241076 | OAuth | 61536 | | 130911 | Protected node | 58695 | | 671046 | Inline Ajax Search | 57266 | | 342629 | Ad Flash | 56399 | | 216745 | Content Profile | 55460 | | 413602 | Node Access | 54810 | | 708544 | Your social media presense On The Web | 53880 | | 10126 | Taxonomy Access Control | 53676 | | 5460 | Guestbook | 52224 | | 995442 | Location Map | 52152 | | 816724 | Views Infinite Scroll | 50664 | | 129858 | AES encryption | 50512 | | 273911 | Nitobe | 48664 | | 324500 | Block edit | 47698 | | 40233 | Taxonomy Lineage | 45408 | | 723378 | Webform Conditional (Same Page Conditionals) | 43568 | | 204097 | User Points Contributed modules | 42416 | | 362109 | Simplenews Statistics | 42276 | | 424354 | Amazon Store | 41776 | | 338860 | Translation table | 40808 | | 367758 | Term Node Count | 39780 | | 1073362 | Panels Extras | 38100 | | 57004 | Remember me | 37350 | | 101261 | Subform | 36050 | | 186858 | OG Menu | 35532 | | 3224 | Bbcode | 35180 | | 67084 | Advanced User | 35076 | | 334297 | Upload element | 34278 | | 487184 | Wysiwyg API template plugin | 33075 | | 330271 | Node Gallery | 32264 | | 3242 | Feedback | 31346 | | 389194 | Node Limit | 30852 | | 680808 | Simplify Node Add | 29965 | | 261036 | Ogone | Ubercart payment | 29280 | | 240007 | Search Files | 29216 | | 1035312 | Realname registration | 28567 | | 145480 | Site Documentation | 28545 | | 962344 | Open Graph meta tags | 28300 | | 277343 | Session API | 28044 | | 1073296 | Webform CiviCRM Integration | 27762 | | 713702 | Popup | 27738 | | 1122068 | amfserver | 27675 | | 733310 | Multiple forms | 26640 | | 852484 | Sweaver | 26604 | | 91961 | Editview | 26080 | | 871168 | Media: Video Flotsam | 26061 | | 337844 | Hide submit button | 25704 | | 529766 | Video Chat | 25688 | | 886354 | qTip (Stylish jQuery Tooltips) | 25218 | | 69846 | Signwriter | 25146 | | 317655 | Shared Email | 24402 | | 620426 | Domain Views | 24000 | | 256860 | Mobile Codes | 23520 | | 887932 | User Alert | 23520 | | 350453 | Token Filter | 22218 | | 241478 | Geolocation Field | 22160 | | 77900 | Timeline | 21800 | | 333543 | Role Change Notify | 21348 | | 557216 | Domain CTools | 21030 | | 138614 | Colorpicker | 19820 | | 13304 | Inline | 19722 | | 312145 | Calendar Block | 19460 | | 570548 | Community Accounting | 19440 | | 108383 | Node Comments | 17780 | | 601496 | SoundManager2 | 17540 | | 201607 | Wordpress Import | 17376 | | 347291 | Multistep | 17024 | | 132283 | Views Tagadelic | 16992 | | 26950 | Taxonomy Theme | 16464 | | 660208 | Content moderation | 16030 | | 434272 | Feed field (CCK module) | 15990 | | 301667 | AHAH helper | 15720 | | 37197 | Comment Upload | 15114 | | 527962 | Application Toolbar (Appbar) | 14360 | | 149970 | Typogrify | 14274 | | 932730 | Style Guide | 13812 | | 3296 | Smileys | 13748 | | 1078890 | Sub-pathauto (Sub-path URL Aliases) | 13131 | | 269084 | Top Searches | 12885 | | 289989 | Invoice | 12810 | | 301116 | Ubercart AJAX Cart | 12060 | | 109168 | CacheExclude | 11972 | | 169222 | CAPTCHA Pack | 11952 | | 534768 | IE 6 Update | 11802 | | 317284 | Menu Import | 11610 | | 380866 | Homebox | 11496 | | 168995 | Keys | 11104 | | 848240 | Phone Number | 11090 | | 350764 | Ubercart eWay Payment Gateway | 10890 | | 864096 | Views Horizontal Slider | 10848 | | 816346 | Cloud Zoom | 10110 | | 289829 | Contact Importer | 10080 | | 356334 | User points Nodes and Comments | 9993 | | 32400 | Control Panel | 9560 | | 88697 | Digg this | 9525 | | 1124688 | Administration Menu select | 9306 | | 298619 | Simple Blogroll | 9144 | | 1016340 | Advanced upload pages | 8850 | | 362624 | Content Complete | 8772 | | 652070 | Sandium | 8710 | | 904742 | Pullquote | 8646 | | 244948 | Campaign Monitor | 8620 | | 364543 | NineSixty (960 Grid System) | 8552 | | 200642 | PHPlist Integration Module | 8480 | | 250777 | Feed Path Publisher | 8376 | | 52349 | Textimage | 8304 | | 305058 | OpenWYSIWYG Editor | 8246 | | 336245 | Colourise | 8175 | | 205275 | Advanced Profile Kit | 8006 | | 152861 | Annotate | 7945 | | 883920 | Noggin | 7884 | | 17004 | Node Relativity | 7774 | | 123287 | abuse | 7704 | | 823344 | Uniform | 7140 | | 801106 | Internationalization Views | 7095 | | 271269 | Views Node Feed | 6831 | | 1010912 | HeadJS | 6798 | | 141315 | Salesforce Suite | 6696 | | 490866 | oEmbed | 6606 | | 869238 | Webform Patched | 6579 | | 483270 | User Terms | 6480 | | 28069 | Acidfree Albums | 6480 | | 157468 | Update status advanced settings | 6238 | | 1376584 | Comment goodness | 6192 | | 350957 | iTunes | 6112 | | 457436 | Menu Node Edit | 6000 | | 216410 | iDEAL Pro | Ubercart Payment | 5980 | | 938264 | Ubercart CCK Attribute | 5920 | | 600894 | Views catalogue | 5886 | | 554232 | BackReference | 5844 | | 269484 | Apture | 5805 | | 291809 | album photos | 5660 | | 800028 | Date single day | 5635 | | 752376 | Panels Teasers | 5472 | | 64094 | OG Vocabulary | 5240 | | 38055 | Family Tree | 5220 | | 1446622 | Date iCal | 5136 | | 83042 | Profile Privacy | 5106 | | 100574 | OG Aggregator | 5033 | | 14267 | Related links | 4809 | | 58779 | Drupal vB | 4752 | | 449208 | Advanced Mail Reroute | 4704 | | 462008 | Oracle driver | 4650 | | 321543 | Slider | 4552 | | 470946 | Disclaimer | 4455 | | 82297 | Texy! | 4368 | | 1031042 | Commerce Feeds | 4230 | | 728764 | Forena Reports | 3916 | | 577102 | Comment Bonus API | 3855 | | 617818 | Ubercart Terms of Service | 3837 | | 89889 | bluebreeze | 3834 | | 335569 | Profile Setup | 3808 | | 844596 | Node access product | 3744 | | 482764 | Ubercart GST / ABN | 3744 | | 519572 | Media: Archive | 3732 | | 1184978 | Views Load More | 3648 | | 271630 | Meta Tags by Path | 3592 | | 478566 | Delegate Menu Administration | 3546 | | 31089 | Event Repeat | 3516 | | 415598 | Booking Time Slots | 3504 | | 260375 | Active Translation | 3504 | | 652800 | DataTables | 3488 | | 866584 | Media: SoundCloud | 3460 | | 164145 | Nista | 3450 | | 745904 | Thrifty 404 | 3210 | | 84160 | Return-Path | 3204 | | 216881 | About This Node | 3143 | | 174512 | Share | 3138 | | 235936 | HTML Export | 2996 | | 628482 | Sunlight Congressional Districts (with optional CiviCRM integration) | 2982 | | 1039636 | Organic Groups create permissions | 2928 | | 966228 | Vimeo Link Formatter | 2926 | | 665640 | Daylight saving time | 2922 | | 413606 | Admin Access | 2880 | | 184684 | DataBase File Manager | 2720 | | 217866 | Block Refresh | 2668 | | 1018026 | Flippy | 2648 | | 916932 | Media: Image Flotsam | 2480 | | 1139428 | Signup Rules Integration | 2460 | | 720164 | Webform Simplenews Component | 2300 | | 994812 | Case Tracker Plus | 2280 | | 141224 | Form Defaults | 2238 | | 420014 | File Aliases | 2202 | | 667356 | Visitor Info | 2128 | | 201501 | Multiple E-mail Addresses | 2048 | | 880284 | Views Slideshow JCarousel Thumbs | 2044 | | 3261 | Listhandler | 2043 | | 916878 | Media: Audio Flotsam | 2034 | | 971928 | Closed Question | 1980 | | 797150 | Node Import Update | 1956 | | 190684 | Multiping | 1918 | | 755114 | Advanced comment | 1896 | | 1001256 | Webform Mailchimp | 1885 | | 1075246 | Taskbar | 1872 | | 211355 | Graphviz Filter | 1782 | | 296717 | IDEAL Lite | Ubercart Payment | 1782 | | 514520 | Simple Reservation | 1740 | | 735184 | Privatemsg Views | 1614 | | 37339 | Table Manager | 1590 | | 218007 | Highslide | 1575 | | 67043 | Import / Export API | 1527 | | 898576 | Views Dynamic Fields | 1475 | | 358040 | ImageField Zip/HTML5 Bulk Upload | 1455 | | 60959 | Node style | 1400 | | 372093 | Donations Thermometer | 1368 | | 798128 | PDF to ImageField | 1368 | | 420742 | Blue Droplet Video | 1368 | | 452642 | Wysiwyg API CCK Integration | 1334 | | 159897 | User titles | 1308 | | 699358 | Graceful Email Obfuscation Filter | 1302 | | 304570 | Content Refresh | 1302 | | 112783 | Menu Subtree Permissions | 1287 | | 776836 | Views Infinite Pager | 1278 | | 558316 | Network Manager | 1260 | | 938482 | Nameday | 1240 | | 1131890 | Imagefield Cycle | 1239 | | 662194 | Views Two Column Table | 1236 | | 418516 | Table Quote - Shipping cost based on total ranges | 1224 | | 253208 | Ubercart Payment Method Adjustments | 1220 | | 630066 | Ubercart Sermepa Payment Systems | 1188 | | 296719 | iDEAL Easy | Ubercart Payment | 1176 | | 344652 | Search Log | 1080 | | 239166 | CCK comment reference | 1071 | | 418298 | CloudFront | 1032 | | 996398 | Views Slideshow Ajax | 1024 | | 705782 | Sites | 1008 | | 564934 | 2 Way Video Chat | 996 | | 532772 | Measured Value Field | 976 | | 818084 | Views hierarchy | 936 | | 189349 | Panels Accordion | 932 | | 703224 | ImageField Avatar | 904 | | 494888 | Support Timer | 900 | | 67105 | Frameprevention | 885 | | 1092076 | Salesforce Web-to-Lead Webform Data Integration | 870 | | 777490 | Postmark | 852 | | 296659 | WoW Armory | 840 | | 1074380 | Formatters for Node Reference fields | 826 | | 649044 | Accessible Content | 804 | | 263591 | UC Payflow Pro | 800 | | 896028 | Ubercart Bulk Stock Updater | 798 | | 192823 | Clickpath | 786 | | 1282044 | VKontakte CrossPoster | 780 | | 554202 | Juitter - jQuery Twitter live search feeds | 744 | | 1205900 | Allow All File Extensions | 742 | | 849344 | Taxonomy Autocomplete Settings | 705 | | 330705 | Restrict Password Change | 699 | | 153802 | KnowledgeTree integration | 696 | | 224204 | Drupify | 690 | | 345043 | phonetic wordfilter | 672 | | 1131938 | Live Streaming | 660 | | 317444 | Hiroshige | 636 | | 146637 | Multisite Manager | 633 | | 510240 | Ubercart Products Recommender | 632 | | 389134 | UC CiviCRM | 632 | | 1234248 | Apache Solr Custom Path | 630 | | 393246 | OG Similar Groups | 612 | | 112012 | The Next Generation Integration | 602 | | 532690 | Units of Measurement | 578 | | 356489 | Contrib Toggle | 576 | | 651964 | Notechoas | 564 | | 296012 | OpenX Manager | 558 | | 1121222 | Organic groups content links | 558 | | 793214 | Media: TeacherTube | 545 | | 972394 | Content Taxonomy Term List | 540 | | 418436 | Weather_es | 522 | | 185762 | Spoiler | 522 | | 760746 | Taxonomy Tree Select | 514 | | 147218 | Buy Me a Beer | 504 | +---------+----------------------------------------------------------------------+--------------+ 373 rows in set (0.83 sec)
