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

​