# How do I see who is marking solved and on what?

**URL:** <https://meta.discourse.org/t/how-do-i-see-who-is-marking-solved-and-on-what/63981>\
**Category:** Data & reporting\
**Tags:** solved, sql-query\
**Created:** [June 5, 2017, 7:34pm UTC](https://meta.discourse.org/t/how-do-i-see-who-is-marking-solved-and-on-what/63981 "2017-06-05T19:34:06Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Sean\_R](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sean_r/32/72433_2.png) [@Sean\_R](https://meta.discourse.org/u/Sean_R)\
**Post date:** [June 5, 2017, 11:52pm UTC](https://meta.discourse.org/t/how-do-i-see-who-is-marking-solved-and-on-what/63981/5 "2017-06-05T23:52:18Z")

</div>

> [@david](#):
>
> – [params]  
> – string :interval = 1 year  
> SELECT ua.user\_id,  
> count(case t.user\_id when ua.user\_id then 1 else null end) as is\_op,  
> count(case t.user\_id when ua.user\_id then null else 1 end) as not\_op,  
> count(\*) as total  
> FROM user\_actions ua  
> LEFT JOIN topics t ON target\_topic\_id = t.id  
> WHERE action\_type=15  
> AND ua.created\_at \>= CURRENT\_DATE - INTERVAL :interval  
> GROUP BY ua.user\_id  
> ORDER BY total DESC

Do these show the user with the correct answer? I am looking for more of a log as to who is doing the marking helps me keep people honest.

I do like the queries, however 🙂

---

_[View the full topic](https://meta.discourse.org/t/how-do-i-see-who-is-marking-solved-and-on-what/63981)._