Untitled query #38130

SQL

select concat('[[',page_title,']]'), DATE_FORMAT(max(rev_timestamp), '%d-%m-%Y')
from revision inner join page
on page_id=rev_page
where page_namespace=0
and page_is_redirect=0
and not exists
(select * from actor
 where rev_actor = actor_id
 and exists
 (select * from user_groups
  where actor_user = ug_user
  and ug_group='bot'))
/*
and rev_actor not in
(select actor_id
 from user_groups inner join actor
 on actor_user=ug_user where ug_group='bot')
*/
and not exists
(select * from page_props
 where rev_page = pp_page
 and pp_propname='disambiguation')
/*
and rev_page not in
(select pp_page
 from page_props
 where pp_propname='disambiguation')
*/
group by rev_page
order by max(rev_timestamp)
limit 1500
SQL

Checking query status...
