# SQL : Les N mots les plus utilisés par utilisateur (parlez leur langue !)

**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:** [Janvier 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:** 2

<div class="post-metadata">

**Author:** ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)\
**Post date:** [Janvier 27, 2016, 9:01 UTC](https://meta.discourse.org/t/sql-the-most-n-used-words-per-user-speak-their-language/38556/2 "2016-01-27T09:01:40Z")

</div>

“`post_search_data.search_data`” is fine if you want to work on [**_lexemes_**](http://www.postgresql.org/docs/current/static/datatype-textsearch.html#DATATYPE-TSVECTOR) since

> a “`tsvector`” value is a sorted list of distinct _lexemes_, which are words that have been normalized to merge different variants of the same word.

If you want to work on _raw_ words, then it’s better to use “`posts.raw`” 😉

---

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