Teahouse preinvite activites (v2)

SQL

SELECT                                                                                                                             
  user_id,                                                                                                                         
  COUNT(rev_id) AS edits,                                                                                                          
  SUM(page_namespace = 0) AS main_edits,                                                                                           
  SUM(page_namespace = 1) AS talk_edits,                                                                                           
  SUM(page_namespace = 2) AS user_edits,                                                                                           
  SUM(page_namespace = 3) AS user_talk_edits,                                                                                      
  SUM(page_namespace IN (4,5)) AS wp_edits,                                                                                        
  SUM(page_namespace > 5) AS other_edits                                                                                           
FROM (                                                                                                                             
    (SELECT                                                                                                                        
        user_id,
     	rev_id,
        page_namespace                                                                                               
    FROM u2041__thr_p.th2_experimental_user
    INNER JOIN enwiki_p.user USING (user_id)
    LEFT JOIN enwiki_p.revision_userindex ON                                                                                                          
        rev_user = user_id AND                                                                                                     
        rev_timestamp <= DATE_FORMAT(                                                                                               
            DATE_ADD(user_registration, INTERVAL 1 DAY),
            "%Y%m%d%H%i%S"                                                                                                         
        )
    LEFT JOIN enwiki_p.page ON rev_page = page_id)
    UNION                                                                                                                          
    (SELECT                                                                                                                        
        user_id,
     	ar_rev_id AS rev_id,
        ar_namespace AS page_namespace                                                                                               
    FROM u2041__thr_p.th2_experimental_user
    INNER JOIN enwiki_p.user USING (user_id)
    LEFT JOIN enwiki_p.archive_userindex ON                                                                                                          
        ar_user = user_id AND                                                                                                     
        ar_timestamp <= DATE_FORMAT(                                                                                               
            DATE_ADD(user_registration, INTERVAL 1 DAY),
            "%Y%m%d%H%i%S"                                                                                                         
        )
   )
) AS foo
GROUP BY user_id;
SQL

Checking query status...
