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) as page_edits_full) as p1
inner join page_edits_full as p2 where (p1.page_title = p2.page_title and p1.page_namespace = 0 and p2.page_namespace = 1)
SQL

Checking query status...
