use hewiki_p;

select max(rev_timestamp) as date, replace(page_title, "_", " ") as "article_name" from revision_userindex inner join page

on page_id=rev_page

where page_namespace=0

and page_is_redirect=0

and 0 in (locate("'", page_title), locate('"', page_title))

and rev_user not in (select ug_user from user_groups where ug_group='bot')

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 1000

​