[development] Modules that need your help
Greg Knaddison
greg.knaddison at acquia.com
Thu Apr 26 16:47:23 UTC 2012
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)
More information about the development
mailing list