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

[Sean_R (Republic Wireless)]

@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