page JOIN page

SQL

SELECT
  cl.cl_to,
  p.page_id,
  p.page_namespace,
  p.page_title,
  p2.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
  categorylinks cl INNER JOIN page p ON cl.cl_from = p.page_id INNER JOIN page p2 ON p.page_title=p2.page_title
  
WHERE
  cl_to = "Redirect-Class_Linguistics_articles" AND
  p2.page_is_redirect = 0
  /*cl_to = "WikiProject_Linguistics_articles" AND
  /*NOT p.page_namespace = 1*/
LIMIT 40
SQL

Checking query status...
