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