Some duplicate records are still sneaking in through one of the joins, so don't trust the count number but do help co-maintain. I apologize, yet again, for sending inaccurate count data into the world.
Greg On Thu, Apr 26, 2012 at 10:47 AM, Greg Knaddison <[email protected]> wrote: > 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) -- Director Security Services | +1-720-310-5623 Skype: greg.knaddison | http://twitter.com/greggles | http://acquia.com
