Untitled query #45865

SQL

use wikidatawiki_p;

select 
	p2.page_title, 
    p2.page_id, 
    COALESCE(max(r1.rev_timestamp),0) as r1_max_rev_timestamp     
    COALESCE(max(r1.rev_id),0) as r1_max_rev_id 
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")) > 365 
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
SQL

Checking query status...
