Viikon kilpailu stats

SQL

USE fiwiki_p;
SELECT 
   rev_user_text, 
   (filter_user_name IS NOT NULL) as already_awarded,
   count(distinct(p2.page_title)) as vk_pages, 
   count(distinct(rev_id)) as vk_revisions 
FROM (
   SELECT 
     pl_title 
   FROM 
     page as p1, 
     pagelinks 
  WHERE 
     p1.page_namespace=4 
     AND p1.page_title LIKE "Viikon_kilpailu/Viikon_kilpailu_2017%" 
     AND pl_from=p1.page_id 
     AND pl_namespace=2 
  GROUP BY pl_title
) AS vkusers, 
(
   SELECT
     p1.page_namespace, 
     p1.page_title, 
     p1.page_len, 
     pl_title, 
     pl_namespace 
  FROM page AS p1, 
     pagelinks 
  WHERE 
     p1.page_namespace=4 
     AND p1.page_title LIKE "Viikon_kilpailu/Viikon_kilpailu_2017%" 
     AND p1.page_title REGEXP "Viikon_kilpailu/Viikon_kilpailu_2017-[0-9]{2}$" 
     AND pl_from=p1.page_id AND pl_namespace=0
) AS page_filter, 
   revision_userindex LEFT JOIN (
     SELECT 
        pl_title AS filter_user_name 
     FROM 
        page, 
        pagelinks 
     WHERE 
        page_title="Kuukauden_wikipedisti" 
        AND page_namespace=4 
        AND pl_from=page_id 
        AND pl_namespace=2
   ) AS user_filter ON filter_user_name=rev_user_text, 
   page AS p2 
WHERE 
  rev_user_text=vkusers.pl_title 
  AND rev_page=p2.page_id 
  AND p2.page_namespace=0 
  AND rev_timestamp > 20170000000000 
  AND p2.page_title=page_filter.pl_title 
GROUP BY rev_user_text 
ORDER BY vk_pages DESC LIMIT 25;
SQL

Checking query status...
