Untitled query #35604

SQL

select T1.page_title, T1.page_touched,substring_index(T1.page_title, '/', 1) as base_page_name, user_editcount,
  count(rev_id) as rev_count
  from page T1
  left join user T2 on substring_index(page_title, '/', 1) = user_name
  left join revision T3 on user_id = rev_user
  left join page T4 on rev_page = T4.page_id
where
  T1.page_namespace = 2 and T1.page_is_redirect = 0 and T1.page_content_model = 'wikitext' and
  user_id is not null and user_editcount < 1000 and
  T4.page_namespace = 0
  having rev_count < 10
  order by T1.page_touched asc limit 10;
SQL

Checking query status...
