# סינון לייקים של משתמשים אם החשבון נוצר X ימים לפני יצירת הנושא

**URL:** https://meta.discourse.org/t/filter-users-likes-out-if-account-created-x-days-prior-to-topic-creation/232331
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [8 ביולי,‏ 2022,‏ 6:02pm UTC](https://meta.discourse.org/t/filter-users-likes-out-if-account-created-x-days-prior-to-topic-creation/232331 "2022-07-08T18:02:07Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [11 ביולי,‏ 2022,‏ 1:37pm UTC](https://meta.discourse.org/t/filter-users-likes-out-if-account-created-x-days-prior-to-topic-creation/232331/4 "2022-07-11T13:37:46Z")

</div>

> [@Matt0x01](#):
>
> t.id shows as a number rather than a preview is there anyway to go about that aswell?

For this one you just need to alias `t.id AS topic_id` and it should work its magic for you. 👍

There are a few more examples of Explorer magic you can use in this topic - [IDs in Data Explorer - #3 by tshenry](https://meta.discourse.org/t/ids-in-data-explorer/224775/3) too

When you say ‘a certain topic’ will it be the same topic each time? (ie. a static topic id)

---

_[View the full topic](https://meta.discourse.org/t/filter-users-likes-out-if-account-created-x-days-prior-to-topic-creation/232331)._