This query is marked as a draft This query has been published by DreamRimmer.

SQL

AخA
 
select page_id, page_title, user_name
from pagetriage_page  
join page on page_id = ptrp_page_id 
join user on user_id = ptrp_last_reviewed_by
where ptrp_reviewed = 3 
  and page_namespace = 0 
  and page_is_redirect = 0
  and not exists (
      select 1 
      from user_groups 
      where ug_user = user_id 
        and (ug_group = "autoreviewer" or ug_group = "bot")
  )
order by ptrp_last_reviewed_by desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...