Shmurak-playing

SQL

use ukwiki_p;
select log_title, log_namespace, log_user_text, log_action, rev_id
from (
  select log_title, log_namespace, log_user_text, log_action
  from logging
  where log_type = 'review'
  and log_timestamp > 201601010000
  and log_namespace = 6
  order by log_timestamp desc
  limit 1000
) all_reviews
join page
on log_title = page_title
and log_namespace = page_namespace
join revision on
page_latest = rev_id
group by log_title
having log_user_text = 'Shmurak'
and log_action in ('approve', 'approve-i')
SQL

Checking query status...
