# Consultas sobre sentimientos comunitarios y toxicidad

**URL:** <https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741>\
**Category:** Data & reporting\
**Tags:** ai, sql-query\
**Created:** [12 Mayo, 2023 18:58 UTC](https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741 "2023-05-12T18:58:55Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Lilly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lilly/32/575047_2.png) [@Lilly](https://meta.discourse.org/u/Lilly)\
**Post date:** [19 Septiembre, 2023 20:05 UTC](https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741/5 "2023-09-19T20:05:53Z")

</div>

Creo que esto debería apuntar al category id:

```sql
-- [params]
-- int :category_id = 

SELECT cr.target_id as post_id,
cr.model_used,
cr.classification->'negative' as negative,
cr.classification->'neutral' as neutral,
cr.classification->'positive' as positive
FROM classification_results cr
JOIN posts p ON p.id = cr.target_id
JOIN topics t ON t.id = p.topic_id
WHERE cr.model_used = 'sentiment'
AND t.category_id = :category_id
ORDER BY cr.id DESC

```

 ![category_id](https://global.discourse-cdn.com/meta/original/4X/9/c/f/9cf3b1f6814b1d6b86021868451edc99c8606424.png)

---

_[View the full topic](https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741)._