Modules that need your help
Hello Drupal Developers! If you use contributed modules to build your site and want to make sure those modules are well maintained you might be interested to review the list of modules "Seeking co-maintainer" at http://drupal.org/taxonomy/term/9990 The list is currently sorted by the project node age, so it's possible you can't find your module in the list. Lucky for you I just ran this query to find projects with stable releases that had at least 500 users last week that are seeking co-maintainer. Note that some of these projects are probably well-maintained but the maintainer wants a little extra help. One of the best ways to become a co-maintainer is to be a "farmer" or a "pirate" - http://webchick.net/we-need-farmers-and-pirates When thinking about how to co-maintain, consider the ideas on http://drupal.org/node/363367 "Best practices for co-maintaining projects" It's possible this status is out of date (some of these may not actually be seeking co-maintainers). Thanks for helping maintain Drupal's contributed modules. Greg -- Director Security Services | +1-720-310-5623 Skype: greg.knaddison | http://twitter.com/greggles | http://acquia.com mysql> select distinct n.nid, title, 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 count > 500 and prn.version_extra is null order by p.count desc; +---------+----------------------------------------------+--------+ | nid | title | count | +---------+----------------------------------------------+--------+ | 465844 | Libraries API | 108558 | | 8404 | CAPTCHA | 98191 | | 55200 | Lightbox2 | 84063 | | 9058 | Nodewords: D6 Meta Tags | 84001 | | 380298 | IMCE Wysiwyg bridge | 55439 | | 80382 | Path redirect | 54200 | | 380298 | IMCE Wysiwyg bridge | 46571 | | 8404 | CAPTCHA | 45250 | | 985370 | References | 41027 | | 43047 | Nice Menus | 36886 | | 3724 | Taxonomy menu | 32866 | | 103123 | Fivestar | 31263 | | 63905 | Content Templates (Contemplate) | 29444 | | 216745 | Content Profile | 27730 | | 26416 | Simplenews | 26691 | | 465844 | Libraries API | 26445 | | 144819 | Content Access | 25351 | | 221788 | Menu Breadcrumb | 24714 | | 33591 | GMap Module | 24634 | | 43047 | Nice Menus | 24079 | | 488352 | Skinr | 22914 | | 506436 | Omega - Responsive HTML5 Base Theme | 22777 | | 55200 | Lightbox2 | 22013 | | 8121 | Taxonomy Image | 21930 | | 328228 | Module Filter | 21652 | | 349872 | Author Pane | 19207 | | 286610 | File (Field) Paths | 18013 | | 198285 | HTML Purifier | 17229 | | 3724 | Taxonomy menu | 16123 | | 193248 | Advanced Forum | 15918 | | 69051 | Login Destination | 14880 | | 33591 | GMap Module | 14254 | | 144819 | Content Access | 14217 | | 112767 | Twitter | 14173 | | 38678 | Nodequeue | 14148 | | 733310 | Multiple forms | 13320 | | 74767 | Computed Field | 12412 | | 258223 | Node export | 12381 | | 280990 | Image FUpload | 11445 | | 89309 | Boost | 11369 | | 172915 | Hierarchical Select | 11270 | | 26416 | Simplenews | 10902 | | 209591 | Imagefield Crop | 10856 | | 73594 | SpamSpan filter | 10516 | | 38678 | Nodequeue | 10355 | | 16617 | Front Page | 10345 | | 3279 | Privatemsg | 10252 | | 15109 | LDAP integration | 10148 | | 488352 | Skinr | 10057 | | 246513 | Block Class | 9002 | | 328228 | Module Filter | 8228 | | 283087 | DraggableViews | 8153 | | 103123 | Fivestar | 8083 | | 102776 | Advertisement | 8040 | | 448520 | Webform Block | 7866 | | 246513 | Block Class | 7769 | | 241076 | OAuth | 7717 | | 241076 | OAuth | 7667 | | 731212 | Custom Search | 7623 | | 448656 | Follow | 7538 | | 37197 | Comment Upload | 7330 | | 193248 | Advanced Forum | 7314 | | 247345 | Shadowbox | 7196 | | 69051 | Login Destination | 7077 | | 138844 | Auto Assign Role | 6591 | | 210180 | RootCandy | 6570 | | 1017248 | Field Slideshow | 6418 | | 221788 | Menu Breadcrumb | 6061 | | 112767 | Twitter | 5916 | | 3279 | Privatemsg | 5886 | | 334297 | Upload element | 5713 | | 434198 | IE Unlimited CSS Loader | 5623 | | 67084 | Advanced User | 5616 | | 731212 | Custom Search | 5283 | | 172915 | Hierarchical Select | 5239 | | 10126 | Taxonomy Access Control | 5230 | | 107191 | Web File Manager | 5115 | | 16617 | Front Page | 5055 | | 286610 | File (Field) Paths | 5031 | | 169222 | CAPTCHA Pack | 5026 | | 138614 | Colorpicker | 4882 | | 261287 | Translation Overview | 4851 | | 20967 | Invite | 4710 | | 247345 | Shadowbox | 4596 | | 192744 | CCK Blocks | 4403 | | 995442 | Location Map | 4346 | | 89309 | Boost | 4325 | | 338860 | Translation table | 4114 | | 241442 | Rotor Banner | 4067 | | 283087 | DraggableViews | 4040 | | 330271 | Node Gallery | 4033 | | 132283 | Views Tagadelic | 4019 | | 342154 | Galleria | 4000 | | 50589 | Case Tracker | 3941 | | 247048 | Node Convert | 3939 | | 215311 | MailChimp | 3930 | | 205275 | Advanced Profile Kit | 3927 | | 215311 | MailChimp | 3889 | | 40956 | Taxonomy Redirect | 3802 | | 1087170 | Geofield | 3711 | | 209591 | Imagefield Crop | 3675 | | 74767 | Computed Field | 3673 | | 801106 | Internationalization Views | 3651 | | 578084 | ImageField Extended | 3557 | | 258223 | Node export | 3556 | | 116949 | Taxonomy Super Select (TSS) | 3497 | | 125230 | Multiselect | 3488 | | 801106 | Internationalization Views | 3444 | | 362109 | Simplenews Statistics | 3440 | | 342154 | Galleria | 3406 | | 5460 | Guestbook | 3401 | | 324500 | Block edit | 3391 | | 385312 | Select (or other) | 3322 | | 3296 | Smileys | 3309 | | 256865 | Plugin Manager | 3092 | | 57004 | Remember me | 3065 | | 723378 | Webform Conditional (Same Page Conditionals) | 2983 | | 73594 | SpamSpan filter | 2978 | | 157468 | Update status advanced settings | 2970 | | 277490 | View reference | 2923 | | 13304 | Inline | 2832 | | 385312 | Select (or other) | 2790 | | 774050 | MediaFront | 2757 | | 109168 | CacheExclude | 2695 | | 30885 | Invisimail | 2676 | | 247048 | Node Convert | 2640 | | 192744 | CCK Blocks | 2617 | | 262984 | Ubercart Addresses | 2594 | | 105916 | Coder | 2561 | | 78967 | CAS | 2560 | | 25974 | Similar Entries | 2549 | | 448656 | Follow | 2545 | | 670520 | Custom Formatters | 2528 | | 63905 | Content Templates (Contemplate) | 2518 | | 3224 | Bbcode | 2471 | | 518250 | Cuf?n | 2468 | | 723378 | Webform Conditional (Same Page Conditionals) | 2463 | | 356334 | User points Nodes and Comments | 2428 | | 379032 | Ubercart Discounts (Alternative) | 2363 | | 8404 | CAPTCHA | 2362 | | 766022 | JW Player Module for Drupal | 2260 | | 364543 | NineSixty (960 Grid System) | 2249 | | 321353 | Finder | 2247 | | 518250 | Cuf?n | 2181 | | 10126 | Taxonomy Access Control | 2156 | | 261287 | Translation Overview | 2124 | | 670520 | Custom Formatters | 2118 | | 277490 | View reference | 2092 | | 350453 | Token Filter | 2082 | | 167500 | Panels Tabs | 2082 | | 19699 | freelinking | 2076 | | 349872 | Author Pane | 2074 | | 364543 | NineSixty (960 Grid System) | 2027 | | 367758 | Term Node Count | 1989 | | 312145 | Calendar Block | 1984 | | 883920 | Noggin | 1971 | | 301667 | AHAH helper | 1965 | | 301116 | Ubercart AJAX Cart | 1940 | | 9058 | Nodewords: D6 Meta Tags | 1911 | | 198285 | HTML Purifier | 1892 | | 1088348 | Taxonomy Term Reference Tree Widget | 1840 | | 816724 | Views Infinite Scroll | 1819 | | 616078 | TableField | 1816 | | 145480 | Site Documentation | 1780 | | 30885 | Invisimail | 1779 | | 180902 | Blueprint | 1764 | | 240007 | Search Files | 1751 | | 20967 | Invite | 1740 | | 337844 | Hide submit button | 1736 | | 447028 | Corresponding node references | 1723 | | 365308 | Term Fields | 1695 | | 447028 | Corresponding node references | 1676 | | 138844 | Auto Assign Role | 1674 | | 65961 | GeSHi Filter for syntax highlighting | 1672 | | 3242 | Feedback | 1662 | | 3778 | TrackBack | 1655 | | 125230 | Multiselect | 1639 | | 616078 | TableField | 1626 | | 350453 | Token Filter | 1619 | | 204097 | User Points Contributed modules | 1581 | | 91961 | Editview | 1568 | | 534768 | IE 6 Update | 1568 | | 105916 | Coder | 1531 | | 149970 | Typogrify | 1523 | | 3219 | Amazon Module | 1510 | | 174512 | Share | 1496 | | 962344 | Open Graph meta tags | 1473 | | 1078890 | Sub-pathauto (Sub-path URL Aliases) | 1459 | | 1031042 | Commerce Feeds | 1410 | | 352460 | Advanced Taxonomy Blocks | 1406 | | 63905 | Content Templates (Contemplate) | 1397 | | 413832 | Visitors | 1392 | | 70707 | Chat Room | 1385 | | 811698 | Translation Management | 1379 | | 78967 | CAS | 1378 | | 962344 | Open Graph meta tags | 1357 | | 708544 | Your social media presense On The Web | 1357 | | 848240 | Phone Number | 1352 | | 483270 | User Terms | 1296 | | 362624 | Content Complete | 1295 | | 114662 | Birthdays | 1288 | | 1446622 | Date iCal | 1284 | | 130911 | Protected node | 1280 | | 108383 | Node Comments | 1249 | | 65961 | GeSHi Filter for syntax highlighting | 1246 | | 871168 | Media: Video Flotsam | 1241 | | 413602 | Node Access | 1218 | | 277343 | Session API | 1210 | | 1282854 | TagCloud | 1209 | | 620426 | Domain Views | 1200 | | 617818 | Ubercart Terms of Service | 1200 | | 123287 | abuse | 1194 | | 413588 | Menu Access | 1191 | | 852484 | Sweaver | 1150 | | 342629 | Ad Flash | 1141 | | 321543 | Slider | 1138 | | 291809 | album photos | 1132 | | 277343 | Session API | 1127 | | 244140 | Google Search Appliance | 1104 | | 480022 | Support Ticketing System | 1089 | | 26416 | Simplenews | 1083 | | 241478 | Geolocation Field | 1081 | | 712262 | SexyBookmarks | 1073 | | 380866 | Homebox | 1070 | | 886354 | qTip (Stylish jQuery Tooltips) | 1056 | | 3219 | Amazon Module | 1024 | | 64094 | OG Vocabulary | 1008 | | 57004 | Remember me | 1002 | | 713702 | Popup | 1002 | | 490866 | oEmbed | 997 | | 338860 | Translation table | 987 | | 413832 | Visitors | 980 | | 317655 | Shared Email | 976 | | 554232 | BackReference | 974 | | 932730 | Style Guide | 970 | | 506436 | Omega - Responsive HTML5 Base Theme | 956 | | 420014 | File Aliases | 955 | | 118128 | Classified Ads | 931 | | 32400 | Control Panel | 930 | | 3224 | Bbcode | 927 | | 77900 | Timeline | 926 | | 347291 | Multistep | 921 | | 129858 | AES encryption | 920 | | 880284 | Views Slideshow JCarousel Thumbs | 914 | | 190684 | Multiping | 913 | | 356334 | User points Nodes and Comments | 903 | | 279576 | Fast Gallery | 897 | | 708544 | Your social media presense On The Web | 888 | | 848240 | Phone Number | 866 | | 129858 | AES encryption | 859 | | 55200 | Lightbox2 | 855 | | 710994 | Content locking (anti-concurrent editing) | 850 | | 380866 | Homebox | 846 | | 487184 | Wysiwyg API template plugin | 832 | | 5460 | Guestbook | 825 | | 43047 | Nice Menus | 823 | | 336245 | Colourise | 823 | | 480022 | Support Ticketing System | 815 | | 336245 | Colourise | 812 | | 149970 | Typogrify | 809 | | 273911 | Nitobe | 804 | | 712262 | SexyBookmarks | 795 | | 312145 | Calendar Block | 786 | | 774050 | MediaFront | 777 | | 84160 | Return-Path | 774 | | 577102 | Comment Bonus API | 771 | | 350957 | iTunes | 764 | | 83042 | Profile Privacy | 763 | | 1141686 | KCFinder integration | 762 | | 52349 | Textimage | 760 | | 487184 | Wysiwyg API template plugin | 743 | | 69846 | Signwriter | 740 | | 253481 | Storm | 738 | | 186858 | OG Menu | 737 | | 321353 | Finder | 735 | | 1039636 | Organic Groups create permissions | 732 | | 210180 | RootCandy | 728 | | 100574 | OG Aggregator | 714 | | 201607 | Wordpress Import | 705 | | 80382 | Path redirect | 704 | | 169222 | CAPTCHA Pack | 703 | | 652800 | DataTables | 701 | | 141224 | Form Defaults | 697 | | 720164 | Webform Simplenews Component | 695 | | 118128 | Classified Ads | 691 | | 250777 | Feed Path Publisher | 677 | | 269084 | Top Searches | 677 | | 452642 | Wysiwyg API CCK Integration | 667 | | 1018026 | Flippy | 662 | | 527962 | Application Toolbar (Appbar) | 662 | | 159897 | User titles | 630 | | 70707 | Chat Room | 629 | | 327649 | Glossify Internal Links Auto SEO | 623 | | 916932 | Media: Image Flotsam | 620 | | 167500 | Panels Tabs | 607 | | 279576 | Fast Gallery | 603 | | 88697 | Digg this | 600 | | 519572 | Media: Archive | 597 | | 244948 | Campaign Monitor | 596 | | 168995 | Keys | 595 | | 478566 | Delegate Menu Administration | 591 | | 601496 | SoundManager2 | 584 | | 28069 | Acidfree Albums | 581 | | 33591 | GMap Module | 580 | | 253208 | Ubercart Payment Method Adjustments | 577 | | 16617 | Front Page | 570 | | 144819 | Content Access | 570 | | 816346 | Cloud Zoom | 565 | | 1184978 | Views Load More | 564 | | 40233 | Taxonomy Lineage | 561 | | 710994 | Content locking (anti-concurrent editing) | 557 | | 74767 | Computed Field | 543 | | 713702 | Popup | 539 | | 269484 | Apture | 538 | | 434272 | Feed field (CCK module) | 533 | | 218007 | Highslide | 525 | | 101261 | Subform | 515 | | 17004 | Node Relativity | 513 | | 1124688 | Administration Menu select | 512 | | 103123 | Fivestar | 505 | +---------+----------------------------------------------+--------+
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)
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 <greg.knaddison@acquia.com> 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
Thanks Greg! This is prefect timing for me. On 27 April 2012 02:49, Greg Knaddison <greg.knaddison@acquia.com> wrote:
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 <greg.knaddison@acquia.com> 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
participants (2)
-
Greg Knaddison -
Si Hobbs