# Blocos de código postados pelos usuários em uma categoria

**URL:** <https://meta.discourse.org/t/user-posted-code-blocks-in-a-category/307712>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [Maio 13, 2024, 2:50am UTC](https://meta.discourse.org/t/user-posted-code-blocks-in-a-category/307712 "2024-05-13T02:50:37Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![jordan-violet](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jordan-violet/32/281428_2.png) [@jordan-violet](https://meta.discourse.org/u/jordan-violet)\
**Post date:** [Maio 13, 2024, 2:50am UTC](https://meta.discourse.org/t/user-posted-code-blocks-in-a-category/307712/1 "2024-05-13T02:50:37Z")

</div>

Às vezes, temos requisitos de outras equipes internas para pesquisar certas informações. Esta consulta foi útil para encontrarmos o que precisávamos.

````sql
-- [params]
-- user_id :user
-- int_list :category_ids = 0

SELECT 
    p.id AS post_id,
    p.raw, 
    p.created_at, 
    p.topic_id  
FROM posts p
WHERE p.user_id = :user
  AND p.topic_id IN (
    SELECT t.id
    FROM topics t
    WHERE (':category_ids' = 0 OR t.category_id IN (:category_ids))
      AND t.archetype <> 'private_message'
      )
  AND p.raw LIKE '%```%'

````

---

_[View the full topic](https://meta.discourse.org/t/user-posted-code-blocks-in-a-category/307712)._