Projects with the most stars on Drupal.org

most_starred_projects

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 |
|    3060 | Drupal core                                 |   128 |
| 2130961 | Paragraphs                                  |   111 |
|    7404 | Webform                                     |    86 |
| 2579611 | Bricks                                      |    70 |
|  343333 | Chaos tool suite (ctools)                   |    62 |
|   38878 | Views                                       |    60 |
|  190124 | Rules                                       |    59 |
|   17345 | Pathauto                                    |    59 |
|  790418 | Search API                                  |    56 |
|  640498 | Metatag                                     |    55 |
|   74958 | Panels                                      |    55 |
|    3236 | Devel                                       |    53 |
| 2474539 | Admin Toolbar                               |    52 |
|  106016 | Token                                       |    52 |
| 2643614 | Twig tweak                                  |    51 |
| 2723491 | JSON API                                    |    50 |
| 2649868 | Thunder                                     |    49 |
|  948488 | Field Group                                 |    49 |
| 2786057 | Configuration Split                         |    48 |
|  607826 | Display Suite                               |    48 |
|  259843 | Bootstrap                                   |    48 |
|  711148 | Group                                       |    47 |
| 1181848 | Inline Entity Form                          |    41 |
|  268362 | Flag                                        |    41 |
|  401392 | Features                                    |    37 |
| 2105097 | Lightning                                   |    36 |
| 2456161 | GraphQL                                     |    35 |
| 1943336 | Entity Browser                              |    35 |
|  241478 | Geolocation Field                           |    35 |
| 1232556 | Honeypot                                    |    34 |
|  583948 | Feeds                                       |    34 |
|  189065 | Backup and Migrate                          |    34 |
|  626176 | Entity API                                  |    33 |
| 2841106 | UI Patterns                                 |    32 |
| 2810685 | Bootstrap Paragraphs                        |    32 |
| 1246440 | Entity reference                            |    32 |
|  206178 | Conditional Fields                          |    32 |
|  719864 | Linkit - Enriched linking experience        |    31 |
|    3287 | Redirect                                    |    31 |
| 2125649 | Open Social                                 |    30 |
| 1820494 | Adminimal - Responsive Administration Theme |    30 |
| 1118924 | Lingotek Translation                        |    30 |
| 1066416 | Advanced CSS/JS Aggregation                 |    30 |
|  172915 | Hierarchical Select                         |    30 |
| 2099473 | Media entity                                |    29 |
|  274365 | Elysia Cron                                 |    29 |
| 2813727 | Parade                                      |    28 |
| 2565749 | Real-time SEO for Drupal                    |    28 |
| 2578773 | Default Content for D8                      |    27 |
+---------+---------------------------------------------+-------+
50 rows in set (0.16 sec)