# Search for label not in entry Request

**URL:** <https://discuss.zetetic.net/t/search-for-label-not-in-entry-request/4755>\
**Category:** Codebook\
**Created:** [December 29, 2020, 5:38pm UTC](https://discuss.zetetic.net/t/search-for-label-not-in-entry-request/4755 "2020-12-29T17:38:05Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![mmoore](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/mmoore/32/858_2.png) [@mmoore](https://discuss.zetetic.net/u/mmoore)\
**Post date:** [January 5, 2021, 10:33pm UTC](https://discuss.zetetic.net/t/search-for-label-not-in-entry-request/4755/7 "2021-01-05T22:33:46Z")

</div>

@lwetzel

Can you give this query a try:

```auto
SELECT e.name FROM entries e WHERE e.type != '1' AND e.id NOT IN
(SELECT f.entry_id FROM fields f WHERE f.type_id = (SELECT id FROM types t WHERE t.name = 'Validated'))

```

I believe that should do it. Let me know the results.

---

_[View the full topic](https://discuss.zetetic.net/t/search-for-label-not-in-entry-request/4755)._