Untitled query #22733

SQL

select p1.*, p2.page_id AS talk_page_id, p2.page_len as talk_page_len from 
  (SELECT page_id, page_namespace, page_title, page_restrictions, page_counter, page_is_redirect, page_len, date, edits, minor_edits
  FROM (
      SELECT rev_page,
             LEFT(rev_timestamp, 8) as date,
             COUNT(*) AS edits,
             SUM(rev_minor_edit) as minor_edits
      FROM revision
      WHERE rev_timestamp BETWEEN "20160401" AND "20160402"
      GROUP BY rev_page, date
  ) as page_edits 
   RIGHT JOIN page ON (rev_page = page_id and page_namespace = 0)) 
inner join (
  SELECT page_id as talk_page_id, page_namespace as talk_page_namespace, page_title as talk_page_title, page_len as talk_page_len, page_counter as talk_page_cnt
  FROM (
      SELECT rev_page,
             LEFT(rev_timestamp, 8) as date,
             COUNT(*) AS edits,
             SUM(rev_minor_edit) as minor_edits
      FROM revision
      WHERE rev_timestamp BETWEEN "20160401" AND "20160402"
      GROUP BY rev_page, date
  ) as talk_page_edits 
  RIGHT JOIN page ON (rev_page = page_id and page_namespace = 1)) 
on page_title = talk_page_title
SQL

Checking query status...
