[development] Modules that need your help
Si Hobbs
simon at hobbs.id.au
Fri Apr 27 07:29:15 UTC 2012
Thanks Greg!
This is prefect timing for me.
On 27 April 2012 02:49, Greg Knaddison <greg.knaddison at 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 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20120427/1edb71de/attachment-0001.html
More information about the development
mailing list