WPLING filter - Quarry

SQL

SELECT
  cl.cl_to,
  p.page_id,
  p.page_namespace,
  p.page_title,
  pc.page_id,
  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
  (SELECT c.cl_to, c.cl_from FROM categorylinks c WHERE c.cl_to LIKE "%Linguistics%") AS cl
  /*categorylinks cl*/
  LEFT JOIN
    (page p LEFT JOIN page pc ON p.page_title=pc.page_title AND p.page_namespace=(pc.page_namespace+1))
    ON cl.cl_from = p.page_id 
  
/*WHERE
  NOT p.page_namespace = 1 AND (
    cl.cl_to IN ("FA-Class_Linguistics_articles", "FL-Class_Linguistics_articles", "GA-Class_Linguistics_articles")
  )/*OR cl.cl_to = "B-Class_Linguistics_articles"
    OR cl.cl_to = "C-Class_Linguistics_articles"
    OR cl.cl_to = "Start-Class_Linguistics_articles"
    OR cl.cl_to = "Stub-Class_Linguistics_articles"
    OR cl.cl_to = "List-Class_Linguistics_articles"
    OR cl.cl_to = "Disambig-Class_Linguistics_articles"
  ) OR (NOT p.page_namespace = 15 AND cl.cl_to = "Category-Class_Linguistics_articles")
    OR (NOT p.page_namespace = 7 AND cl.cl_to = "File-Class_Linguistics_articles")
    OR (NOT p.page_namespace = 101 AND cl.cl_to = "Portal-Class_Linguistics_articles")
    OR (NOT p.page_namespace = 5 AND cl.cl_to = "Project-Class_Linguistics_articles")
    OR (NOT p.page_namespace = 11 AND cl.cl_to = "Template-Class_Linguistics_articles")
    OR (NOT p.page_namespace = 119 AND cl.cl_to = "Draft-Class_Linguistics_articles")
    OR (NOT p.page_namespace = 13 AND cl.cl_to = "NA-Class_Linguistics_articles")
    OR (cl.cl_to = "Unassessed_Linguistics_articles")
  /*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*/
LIMIT 10
SQL

Checking query status...
