# SQL Query to extract all posts with unchecked checkboxes

**URL:** <https://meta.discourse.org/t/sql-query-to-extract-all-posts-with-unchecked-checkboxes/291634>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [January 15, 2024, 12:37am UTC](https://meta.discourse.org/t/sql-query-to-extract-all-posts-with-unchecked-checkboxes/291634 "2024-01-15T00:37:25Z")\
**Posts on this page:** 1\
**Showing post:** 1

<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:** [January 15, 2024, 12:37am UTC](https://meta.discourse.org/t/sql-query-to-extract-all-posts-with-unchecked-checkboxes/291634/1 "2024-01-15T00:37:25Z")

</div>

Continuing the discussion from [Topic Checkboxes - a dynamic check list showing all checkboxes from all topic messages](https://meta.discourse.org/t/topic-checkboxes-a-dynamic-check-list-showing-all-checkboxes-from-all-topic-messages/286176):

What would be an SQL query to extract all posts with unchecked checkboxes in a particular category, including excerpts (i.e. the paragraph that contains that checkbox)?

---

_[View the full topic](https://meta.discourse.org/t/sql-query-to-extract-all-posts-with-unchecked-checkboxes/291634)._