Untitled query #45865

SQL

use wikidatawiki_p;

select 
    count(distinct(t.page_title)),
    count(distinct(r2.rev_id)),
	t.*,
    r2.rev_timestamp,
    r2.rev_user_text,
    r2.rev_comment
from (
select 
	p2.page_title, 
    p2.page_id, 
    COALESCE(max(r1.rev_timestamp),0) as r1_max_rev_timestamp,     
    datediff(now(), str_to_date(r1.rev_timestamp, "%Y%m%d%H%i%S")) as datediff
from 
	page as p1, 
    pagelinks as pl1, 
    page as p2 LEFT JOIN revision_compat as r1 
    	ON  r1.rev_page=p2.page_id and datediff(now(), str_to_date(r1.rev_timestamp, "%Y%m%d%H%i%S")) > 90 
where 
	p1.page_title="Zache/pori" 
    and p1.page_namespace=2 
    and pl_from=p1.page_id 
    and pl_from_namespace = 2 
    and pl_namespace=0 
    and p2.page_title=pl1.pl_title 
    and p2.page_namespace=0 
group by p2.page_id
) as t,
revision_compat as r2 
LEFT JOIN (SELECT ug_user FROM user_groups WHERE ug_group="bot") as ug ON r2.rev_user=ug_user
WHERE
	r2.rev_page=t.page_id
    AND r2.rev_timestamp>r1_max_rev_timestamp
    AND r2.rev_user_text NOT IN ('SannaOikkis')
    AND ug.ug_user IS NULL
GROUP BY r2.rev_page;
SQL

Checking query status...
