page JOIN page

SQL

SELECT
  p.page_id,
  p.page_namespace,
  p.page_title,
  p.page_is_redirect,
  pc.page_id,
  pc.page_namespace,
  pc.page_title,
  pc.page_is_redirect
  /*concat(YEAR(rf.rev_timestamp) , '_', MONTH(rf.rev_timestamp)) as date,
    COUNT(*) as total_count,
    COUNT(CASE WHEN rev_len < 4000 THEN 1 ELSE NULL END) as less_than_4k_count,
    avg(rev_len) as average_length
  */
  
FROM
  page p LEFT JOIN page pc ON p.page_title=pc.page_title AND p.page_namespace=(pc.page_namespace+1)
  
WHERE
  pc.page_id BETWEEN 56000000 AND 56002000 AND
  pc.page_is_redirect = 1 AND p.page_is_redirect = 0
  /*cl_to = "WikiProject_Linguistics_aricles" AND
  NOT p.page_namespace = 1*/
SQL

Checking query status...
