punaisten linkkien naiset wikidata activity

SQL

use fiwiki_p;
select 
   sum(1) as c, 
   pl_title  
from (
  select 
  	pl_title, 
  	rev_page, 
  	rev_id, 
  	comment_text 
  from (
    select 
    	pl_title 
    from 
    	page, 
    	pagelinks 
    where 
    	pl_from=page_id 
    	and page_title="Punaisten_linkkien_naiset/2019" 
    	and page_namespace=106 
    	and pl_namespace=2
  ) as t, 
  wikidatawiki_p.revision_userindex as wd_r, 
  wikidatawiki_p.comment as wd_c 
  where 
  	wd_r.rev_comment_id=wd_c.comment_id 
  	and  t.pl_title=wd_r.rev_user_text 
  	and wd_r.rev_timestamp > 20190400174151 
  	and wd_r.rev_timestamp < 20190500174151 
  	and wd_c.comment_text like "%P21%" 
) as tt 
group by pl_title;
SQL

Checking query status...
