Untitled query #45525

SQL

use fiwiki_p;
select 
	page_title, 
    bc10_first,
    ip_first, 
    rev_timestamp, 
from 
	page, 
    (
      	select 
      		a.rev_page, 
      		sum(a.min_rev_id>b.min_rev_id) as abc10_first, 
      		sum(a.min_rev_id<b.min_rev_id) as ip_first, 
      		a.rev_timestamp, count(distinct(a.rev_page)) as c, 
      		a.actor_name  
      	from  
      		(
              	select 
              		min(rev_id) as min_rev_id, 
              		count(distinct(rev_id)) as rev_id_c, 
              		rev_page, 
              		rev_timestamp, 
              		actor_name 
              	from 
              		revision, 
              		actor_revision 
              	where 
              		rev_id>18630374 
              		and rev_actor=actor_id 
              		and actor_name LIKE "95.17%" 
              	group by rev_page
            ) as a 
      		LEFT JOIN 
      		(
              	select 
              		min(rev_id) as min_rev_id, 
              		count(distinct(rev_id)) as rev_id_c, 
              		rev_page 
              	from 
              		revision, 
              		actor_revision 
              	where 
              		rev_id>18630374 
              		and rev_actor=actor_id 
              		and actor_name="Abc10" 
              	group by rev_page
            ) as b 
      		ON a.rev_page=b.rev_page 
      		group by a.rev_page
    ) as t 
where 
	rev_page=page_id 
    group by page_id 
    order by rev_timestamp desc;
SQL

Checking query status...
