webchick

{
    "name": "drupal-composer/drupal-project",
    "description": "Project template for Drupal 8 projects with composer",
    "type": "project",
    "license": "GPL-2.0-or-later",
    "authors": [
        {
            "name": "",
            "role": ""
        }

webchick

+---------+-----------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------+-------+
| nid     | project                                       | title                                                                                                                                                   | stars |
+---------+-----------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------+-------+
|  691078 | Token                                         | Field tokens                                                                                                                                            |   400 |
| 1464950 | Conditional Fields                            | Support for multiple "Field collection" and "Multifield" fields             

webchick

mysql> SELECT n.nid, n.title, c.count AS stars
    -> FROM node n
    ->   INNER JOIN flag_counts c ON c.entity_id = n.nid
    -> WHERE c.fid = 14
    -> ORDER BY c.count DESC
    -> LIMIT 50;
+---------+---------------------------------------------+-------+
| nid     | title                                       | stars |
+---------+---------------------------------------------+-------+
|  605898 | Drupal Commerce                             |   148 |

webchick

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;
+---------+-------------------------------------------------------------------+-----------+

webchick

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) /* fixed, closed (fixed), closed (duplicate) */
    -> ORDER BY c.count DESC
    -> LIMIT 50;
+---------+-----------------------------------------------------------+-----------+

webchick

One place to start might be to "mirror" some of the sprints happening in Dublin, which you can see at https://docs.google.com/a/acquia.com/spreadsheets/d/1eitbzBlGFqy1OBnx830Grix1djwcA2zaCoC-X7EOylY/edit?usp=drive_web (and even register your folks interest in sprinting remotely on the given days, just be mindful of the timezone difference :)).

Some "hot topics" I'm aware of atm are (also see http://drupal.org/core/roadmap for more):

---

Usability

Current priorities are at http://drupalux.org/sprint, a full list of issues is under the "Usability" tag. A lot of these just need someone with some front-end chops (CSS/JS) to push them over the finish line.

webchick

2573683	[pathauto] Pathauto	38
2578451	[token] Token	28
2578727	[bootstrap] Bootstrap	27
2574669	[commerce] Drupal Commerce	25
2574683	[webform] Webform	25
2591017	[og] Organic Groups	23
2574421	[panels] Panels	20
2607038	[backup_migrate] Backup and Migrate	19
2574049	[redirect] Redirect	16
2574755	[metatag] Metatag	16

webchick

SELECT n.nid, n.title, flag.count AS cnt
FROM node n
  INNER JOIN flag_counts flag ON flag.entity_id = n.nid
  INNER JOIN field_data_field_project project on project.entity_id = n.nid
WHERE flag.fid = 4 /* project_issue_follow */
AND project.field_project_target_id = 2573607 /* contrib_tracker */
GROUP BY n.nid
ORDER BY cnt DESC
LIMIT 100;

webchick

SELECT td.tid, td.name, COUNT(*) as cnt
FROM taxonomy_term_data td
  INNER JOIN field_data_taxonomy_vocabulary_9 v ON v.taxonomy_vocabulary_9_tid = td.tid
  INNER JOIN field_data_field_project p ON p.entity_id = v.entity_id
WHERE p.field_project_target_id = 3060
GROUP BY name
ORDER BY cnt DESC
LIMIT 300;

"tid","name","cnt"

webchick

Hi, I'm Angie, a Drupal developer playing around with WordPress for fun. :) Here's some feedback on the doc contribution process, in case it's helpful.

My goal was to write a simple "hello world" plugin in WordPress.

First thing I did was search 'wordpress plugins' in Google and came across https://wordpress.org/plugins/about/ (one of the sub-pages listed in the main wordpress.org google listing). This is a few too many steps ahead, when I'm ready to contribute my code back to WordPress.org.

Next I tried https://wordpress.org/plugins/about/faq/, but that's again about contributing back, and assumes I already know about how to write plugins. 

SUGGESTION: Add a link off to the plugin developer docs from one or both of these pages, since tweaking Google's SEO is hard. :)