# Sondaggio sul sentimento della comunità e tossicità

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

<div class="post-metadata">

**Author:** ![SaraDev](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/saradev/32/335139_2.png) [@SaraDev](https://meta.discourse.org/u/SaraDev)\
**Post date:** [9 Novembre 2023, 1:15am UTC](https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741/12 "2023-11-09T01:15:19Z")

</div>

Ciao Samantha,

Se volessi perfezionare quelle query per includere i parametri di data di inizio e fine, potresti usare una query come questa:

```sql
-- [params]
-- date :start_date = 2023-01-01
-- date :end_date = 2024-01-01

SELECT
p.created_at,
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
WHERE cr.model_used = 'sentiment'
AND p.created_at BETWEEN :start_date AND :end_date
ORDER BY cr.id DESC

```

Esempio di risultati:

| created\_at | post | model\_used | negative | neutral | positive |
| --- | --- | --- | --- | --- | --- |
| 2023-11-08T21:21:23.913Z | post\_id | sentiment | 58 | 38 | 2 |

La parte importante aggiunta qui è l’unione della tabella `posts` con la tabella `classification_results` in modo da poter aggiungere:

```plaintext
AND p.created_at BETWEEN :start_date AND :end_date

```

all’istruzione `WHERE` per filtrare i post in base alla loro data `created_at`.

Poiché le query di classificazione `emotion` e `toxicity` sono simili, potresti modificare anche quelle query con questa aggiunta per includere i parametri di data di inizio e fine. 🙂

---

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