Mainspace articles without a talk page grouped by month

Fork of Oldest 500 Mainspace articles without a talk page by MPGuy2824

This query is marked as a draft This query has been published by MPGuy2824.

SQL

select creationMonth, count(*), page_title
from (
  SELECT left(rev_timestamp, 6) as creationMonth, page_title
  FROM	page AS article
  join    revision on page_id=rev_page
  WHERE	article.page_is_redirect=0
          AND article.page_namespace=0
          AND NOT EXISTS
          (
              SELECT 1
              FROM 	page AS talkpage
              WHERE 	talkpage.page_title=article.page_title
              AND 	talkpage.page_namespace=1
              LIMIT 1
          )
          AND NOT EXISTS
          (
              SELECT 1
              FROM 	page_props AS props
              WHERE 	props.pp_propname = 'disambiguation'
              AND   	props.pp_page = article.page_id
              LIMIT 1
          )
  group by page_id
) as x
group by creationMonth
order by creationMonth asc;

SQL

Checking query status...