Last active
September 20, 2017 22:47
-
-
Save webchick/5508141c3c7e5570a2af82c5d33bc7dd to your computer and use it in GitHub Desktop.
Top 50 "most wanted" modules that are the least furthest along (by contrib_tracker data)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql> SELECT n.nid, n.title, c.count AS followers | |
-> FROM node n | |
-> INNER JOIN flag_counts c ON c.entity_id = n.nid | |
-> INNER JOIN field_data_field_project p ON p.entity_id = n.nid | |
-> INNER JOIN field_data_field_issue_status s ON s.entity_id = n.nid | |
-> WHERE p.field_project_target_id = 2573607 /* contrib_tracker */ | |
-> AND s.field_issue_status_value NOT IN (2, 7, 3, 8, 14) /* fixed, closed (fixed), closed (duplicate), needs review, RTBC */ | |
-> ORDER BY c.count DESC | |
-> LIMIT 50; | |
+---------+-------------------------------------------------------------------+-----------+ | |
| nid | title | followers | | |
+---------+-------------------------------------------------------------------+-----------+ | |
| 2591017 | [og] Organic Groups | 97 | | |
| 2604358 | [feeds] Feeds | 83 | | |
| 2595163 | [media] Media | 68 | | |
| 2596641 | [field_collection] Field Collection | 41 | | |
| 2606848 | [better_exposed_filters] Better Exposed Filters | 36 | | |
| 2578231 | [calendar] Calendar | 33 | | |
| 2615320 | [entityreference_prepopulate] Entityreference prepopulate | 33 | | |
| 2573679 | [transliteration] Transliteration | 31 | | |
| 2608648 | [content_access] Content Access | 31 | | |
| 2605194 | [libraries] Libraries API | 28 | | |
| 2606490 | [openatrium] Open Atrium | 28 | | |
| 2574083 | [crm_core] CRM Core | 27 | | |
| 2624188 | [ip_geoloc] IP Geolocation Views & Maps | 27 | | |
| 2611516 | [advanced_forum] Advanced Forum | 25 | | |
| 2589671 | [leaflet] Leaflet | 24 | | |
| 2606944 | [twitter] Twitter | 24 | | |
| 2606904 | [pathologic] Pathologic | 23 | | |
| 2609640 | [gmap] GMap Module | 23 | | |
| 2620300 | [menu_item_visibility] Menu item visibility | 22 | | |
| 2622398 | [openlayers] Openlayers | 22 | | |
| 2608930 | [views_data_export] Views data export | 22 | | |
| 2612838 | [hybridauth] HybridAuth Social Login | 21 | | |
| 2622594 | [commerce_kickstart] Commerce Kickstart | 21 | | |
| 2584487 | [node_clone] Node Clone | 20 | | |
| 2613248 | [commerce_stock] Commerce Stock | 18 | | |
| 2621706 | [rate] Rate | 18 | | |
| 2621762 | [nodeaccess] Nodeaccess | 18 | | |
| 2574403 | [page_manager] Page Manager | 18 | | |
| 2608214 | [cmis] CMIS API | 18 | | |
| 2611322 | [boost] Boost | 17 | | |
| 2622814 | [privatemsg] Privatemsg | 17 | | |
| 2634612 | [editableviews] Editable Views | 17 | | |
| 2573659 | [project_short_name] Project Human-Readable Name (Issue Template) | 17 | | |
| 2609708 | [taxonomy_manager] Taxonomy Manager | 17 | | |
| 2612316 | [views_bootstrap] Views Bootstrap | 16 | | |
| 2612946 | [path_breadcrumbs] Path Breadcrumbs | 16 | | |
| 2615348 | [fullcalendar] FullCalendar | 16 | | |
| 2630066 | [views_conditional] Views Conditional | 16 | | |
| 2683457 | [commerce_license] Commerce License | 16 | | |
| 2606908 | [responsive_menus] Responsive Menus | 16 | | |
| 2606920 | [security_review] Security Review | 16 | | |
| 2608708 | [views_php] Views PHP | 16 | | |
| 2596721 | [userpoints] User Points | 15 | | |
| 2605202 | [menu_attributes] Menu Attributes | 15 | | |
| 2605570 | [logintoboggan] LoginToboggan | 15 | | |
| 2611402 | [securepages] Secure Pages | 15 | | |
| 2615294 | [date_ical] Date iCal | 14 | | |
| 2634298 | [opigno_lms] Opigno LMS | 14 | | |
| 2655672 | [subscriptions] subscriptions | 14 | | |
| 2601754 | [menu_position] Menu position | 14 | | |
+---------+-------------------------------------------------------------------+-----------+ | |
50 rows in set (14.45 sec) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment