Untitled query #37405

SQL

use trwiki_p;
select 
	page_id, 
    sum(coalesce(ug_user, ufg_user)>0) as bot_created, 
    sum(1) as total_created  
from (
  select 
  	page_id, 
  	min(rev_timestamp) as min_ts 
  from 
  	page, 
  	revision 
  where 
  	rev_page=page_id 
  	and page_namespace=0 
  	and page_len > 100 
  	and page_is_redirect!=1 
  	and RIGHT(page_id,1)=1 
  	and RIGHT(FLOOR(page_id/10),1)=1 
  	and RIGHT(FLOOR(page_id/100),1)=1 
  group by page_id
) as r1, 
	revision as r2, 
    actor as a 
    	LEFT JOIN user_groups ON ug_user=actor_user AND ug_group='bot' 
    	LEFT JOIN user_former_groups ON ufg_user=actor_user AND ufg_group='bot' 
   where 
   		rev_actor=actor_id 
        AND r1.page_id=rev_page 
        AND r1.min_ts=r2.rev_timestamp 
  limit 100
SQL

Checking query status...
