# SQL: أكثر N كلمة مستخدمة لكل مستخدم (تحدث بلغتهم!)

**URL:** <https://meta.discourse.org/t/sql-the-most-n-used-words-per-user-speak-their-language/38556>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [27 يناير 2016، 5:55ص UTC](https://meta.discourse.org/t/sql-the-most-n-used-words-per-user-speak-their-language/38556 "2016-01-27T05:55:21Z")\
**Posts on this page:** 1\
**Showing post:** 20

<div class="post-metadata">

**Author:** ![DiscourseMetrics](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/discoursemetrics/32/55756_2.png) [@DiscourseMetrics](https://meta.discourse.org/u/DiscourseMetrics)\
**Post date:** [17 مايو 2019، 8:50م UTC](https://meta.discourse.org/t/sql-the-most-n-used-words-per-user-speak-their-language/38556/20 "2019-05-17T20:50:42Z")

</div>

Unsure if I should start a new topic or not but.. would it be possible to tweak this SQL to get a list of the X most common words used in the last Y posts, regardless of user? I’m trying to look for common technical words I can use to create a dictionary on my forum.

---

_[View the full topic](https://meta.discourse.org/t/sql-the-most-n-used-words-per-user-speak-their-language/38556)._
