# 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:** 17

<div class="post-metadata">

**Author:** ![meglio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/meglio/32/71444_2.png) [@meglio](https://meta.discourse.org/u/meglio)\
**Post date:** [11 أبريل 2016، 3:22ص UTC](https://meta.discourse.org/t/sql-the-most-n-used-words-per-user-speak-their-language/38556/17 "2016-04-11T03:22:08Z")

</div>

The solution would be to create a ts\_vector from category title and topic title and subtract that vector from the result, per-topic.

---

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