Skip to content

Instantly share code, notes, and snippets.

@webchick
Last active August 29, 2015 14:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save webchick/b7eef2aee6fb92634871 to your computer and use it in GitHub Desktop.
Save webchick/b7eef2aee6fb92634871 to your computer and use it in GitHub Desktop.
Top 300 issue tags in Drupal core
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"
772,"Novice",3065
21556,"needs backport to D7",2202
317,"Usability",1658
36416,"VDC",1647
28686,"D8MI",1356
345,"Needs tests",1151
27698,"Configuration system",944
132,"Performance",917
275,"Quick fix",822
232,"JavaScript",684
38578,"Entity Field API",678
5934,"API change",629
36330,"Twig",616
437,"DX (Developer Experience)",606
7250,"API clean-up",570
374,"Needs issue summary update",532
26118,"WSCCI",532
1101,"accessibility",529
23178,"frontend",509
38534,"Spark",459
136,"CSS",388
53865,"Amsterdam2014",343
33622,"language-content",337
41224,"WSCCI-conversion",325
45073,"beta target",319
36358,"Needs reroll",310
33420,"language-base",302
33620,"language-config",300
2462,"coding standards",282
5144,"Needs manual testing",262
45985,"@deprecated",257
5608,"html5",251
1888,"phpunit",248
182,"needs backport to D6",247
37994,"Configurables",227
8912,"beta blocker",226
30910,"Field API",221
488,"Needs Documentation",220
30126,"Testing system",220
1096,"mobile",207
2694,"D7UX",203
534,"Entity system",203
7960,"D7 upgrade path",196
41438,"D8 cacheability",195
757,"DrupalWTF",191
40926,"FormInterface",189
36406,"theme system cleanup",188
5958,"API addition",186
40812,"Configuration schema",186
27290,"D8 upgrade path",186
636,"documentation",185
13568,"MenuSystemRevamp",177
31228,"sprint",174
33450,"JavaScript clean-up",167
33434,"language-ui",164
197,"Security improvements",161
37332,"Blocks-Layouts",151
42899,"Approved API change",144
1230,"security",143
37486,"Plugin system",141
310,"Needs usability review",133
33080,"PSR-0",129
134,"PostgreSQL",116
2544,"Framework Initiative",114
43129,"CodeSprintCIS",112
40400,"CKEditor in core",112
26180,"d8mux",110
11348,"d8ux",107
41216,"#SprintWeekend",106
1768,"ui-text",102
40352,"Block plugins",100
42699,"RTBC July 1",96
225,"Favorite-of-Dries",96
1274,"regression",94
7852,"Update manager",94
5494,"translatable fields",94
15642,"styleguide",92
18932,"D8UX usability",85
9910,"frontend performance",83
4722,"#d7ux",80
30194,"symfony",80
38080,"blocker",80
164961,"Ghent DA sprint",79
18930,"#d8ux",78
33114,"Media Initiative",77
46099,"SprintWeekend2014",76
38290,"Random test failure",74
523,"Needs design review",73
813,"string freeze",73
7066,"needs accessibility review",73
418,"RDF",72
40700,"dreammarkup",72
41796,"CodeSprintUA",71
52407,"TCDrupal 2014",71
29432,"Needs profiling",71
649,"Fields in Core",70
1818,"Security Advisory follow-up",69
51291,"banana",68
27452,"UMN 2011",65
34846,"Config novice",62
40454,"Test suite performance",61
978,"Needs screenshots",61
131,"DBTNG Conversion",61
54957,"SafeMarkup",61
31208,"docs-cleanup-2011",60
39626,"toolbar-followup",59
5564,"D7UX usability",59
39602,"Stalking Crell",58
1252,"UBUserTesting2009",58
48393,"Quickfix",57
35200,"coder-fixes-2012",56
35638,"Dependency Injection (DI)",56
33612,"Needs steps to reproduce",55
164349,"Triaged D8 critical",55
301,"i18n sprint",54
159,"RTL",54
30584,"Platform Initiative",53
27312,"Front end",51
43357,"FormBase",49
23786,"Responsive Design",49
46615,"Twig conversion",48
52375,"Drupalaton 2014",47
20540,"d8dx",47
38182,"YAML",47
9776,"Bartik",46
18686,"Needs Update Documentation",46
29628,"PHP 5.4",44
3204,"FilterSystemRevamp",44
1510,"Ajax",44
206,"i18n",43
778,"token",43
7790,"D7 API clean-up",43
1698,"CSS aggregation",43
31100,"Contributed project blocker",43
42144,"Entity validation",42
10002,"Page Manager",42
187,"jQuery",42
29726,"Needs change record",42
8458,"d7help",41
412,"Needs text review",41
38188,"State system",40
2242,"IA",40
53135,"FUDK",40
4852,"upgrade path",38
1294,"ui-pattern",38
41508,"Needs followup",37
45889,"beta deadline",37
40954,"Tour",37
8804,"D7 Form API challenge",37
33438,"TX (Themer Experience)",36
36304,"kernel-followup",36
5240,"aria",36
26900,"Proudly Found Elsewhere",36
36890,"js-novice",35
499,"theme",35
303,"menu",34
38226,"Needs JS testing",34
8092,"Seven",34
38160,"#pnx-sprint",33
42981,"Component maintainers",33
553,"overlay",33
1148,"markup",33
4774,"d7uxsprint",32
2506,"vertical tabs",32
434,"permissions",32
39974,"d8mux-admin",32
39926,"typed data",32
349,"wysiwyg",32
32136,"Increases learning curve",31
33436,"negotiation",31
460,"taxonomy",31
41374,"PHPUnit Blocker",31
10622,"FAPI #states",30
39830,"css-novice",30
165559,"entity storage",30
449,"Needs architectural review",29
4474,"Help text",29
130,"PostgreSQL Surge",29
37846,"Entity Access",29
43097,"Block UI overhaul",29
38312,"in-place editing",29
165757,"#dcdelhi",29
41638,"language-content-property",28
433,"actions",28
46177,"RDF code sprint",28
43781,"WSCCI Conversions",28
5548,"Needs committer feedback",28
41072,"Sunrise Sanity Cruise",27
14592,"needs security review",27
1688,"RDFa",27
38240,"Theme Component Library",27
47279,"Naming things is hard",27
41628,"php-novice",27
36552,"a11ySprint",27
12396,"consistency",26
46305,"D8MA",26
43973,"affects Drupal.org",26
34258,"7.13 release notes",26
3274,"Needs themer review",26
468,"database",26
38850,"7.17 release notes",26
446,"Killer End-User Features",26
41960,"MENU_LOCAL_ACTION",26
33664,"composer",25
5050,"atag",25
41126,"7.22 release notes",25
1386,"modal dialog",24
3590,"ie8",24
451,"Drupal",24
9470,"webchick's D7 alpha hit list",24
1782,"jQuery UI",24
470,"PHP 5.3",24
429,"user pictures",24
1256,"dashboard",23
42759,"Template consolidation",23
47299,"revisit before release candidate",23
54465,"7.33 release notes",23
8798,"clean-up",23
49357,"Needs change record updates",23
1019,"cron",23
645,"MySQL",23
3674,"DIE",22
48233,"#Drupal8nz",22
758,"autocomplete",22
151069,"DrupalCamp Ghent 2014",22
803,"memory",22
278,"installation",22
3404,"Registry",21
4930,"user experience",21
33412,"D8MI-meta",21
50195,"minor version target",21
54399,"dcwroc2014",21
22072,"UUID",21
39980,"medium",21
491,"image",21
53655,"Pre-AMS beta sprint",21
36350,"7.15 release notes",21
42983,"Kill includes",21
48907,"d8rules",21
37838,"Entity forms",21
5512,"session",20
41798,"7.23 release notes",20
3288,"cache",20
45539,"7.25 release notes",20
33962,"dlatino",20
17490,"WPO",20
487,"caching",20
11856,"entity API",20
4904,"Node access",20
52177,"FormState",20
44095,"Prague Hard Problems",20
54789,"drupalhagen",20
164515,"CriticalADay",20
2516,"Cleanup",20
53133,"frontendunited",20
13224,"sqlite",19
53741,"dcamsa11y",19
41678,"Annotation",19
38280,"json-ld",19
34358,"CMI",19
53331,"DUGBE1409",19
5152,"core",19
44307,"alpha target",19
107,"GHOP",19
8198,"Perfomance",19
561,"search",18
7830,"D7 UX freeze",18
10476,"D7csmtl",18
1041,"User interface",18
629,"node",18
176,"Windows",18
40710,"d8mux-css-cleanup",18
42204,"Typed sanity",18
108,"Newbie",18
1820,"pathauto",17
31654,"Needs backport to 6.x",17
13642,"Stark",17
54121,"page rendering",17
133,"D7FileAPIWishlist",17
2024,"XHTML validation",17
30822,"montreal",17
54105,"cssbanana",17
1602,"tpl-refresh",17
686,"Forum",17
396,"block",17
382,"PHP",17
42371,"Field API NG blocker",17
39194,"BADCamp2012UX",17
5052,"wcag",17
5620,"user_access",16
35928,"Avoid commit conflicts",16
5524,"d7docs",16
2768,"installation profiles",16
32844,"langcode",16
375,"SEO",16
33686,"GoogleUX2012",16
748,"code cleanup",16
663,"html",16
737,"field",16
177,"IE",16
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment