# Badge for total posts, and attendence
**URL:** https://meta.discourse.org/t/badge-for-total-posts-and-attendence/276727
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [2015年六月6日 06:13 UTC](https://meta.discourse.org/t/badge-for-total-posts-and-attendence/276727 "2015-06-06T06:13:44Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [2015年六月6日 06:13 UTC](https://meta.discourse.org/t/badge-for-total-posts-and-attendence/276727/1 "2015-06-06T06:13:44Z")
How can I create badges that count totally posts of someone?
And a badge for days attendance (not consecutive)
Any idea?
---
### Author:  [@PJH](https://meta.discourse.org/u/PJH)
#### Post date: [2015年六月6日 12:21 UTC](https://meta.discourse.org/t/badge-for-total-posts-and-attendence/276727/2 "2015-06-06T12:21:28Z")
> [@alefattorini](#):
>
> How can I create badges that count totally posts of someone?
Including
- PM’s,
- flags
- deleted/hidden posts
- categories that require logging in to view?
For someone who’s made 1,000 or more posts:
```sql
SELECT user_id, current_timestamp granted_at
FROM posts
GROUP BY user_id
HAVING count(*) >= 1000
```
Triggered daily, don’t target posts.
To exclude those things listed in the bullet points, change `from posts` to `from badge_posts`
> [@alefattorini](#):
>
> And a badge for days attendance (not consecutive)
For visiting 365 days:
```sql
SELECT user_id, current_timestamp granted_at
FROM user_visits
GROUP BY user_id
HAVING count(*) >= 365
```
Again, triggered daily, don’t target posts.
---
### Author:  [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [2015年八月7日 12:41 UTC](https://meta.discourse.org/t/badge-for-total-posts-and-attendence/276727/3 "2015-08-07T12:41:35Z")
Cool man, really! Now I have all what I need