test2 - Quarry

SQL

SELECT
  page_id    AS aa_page,
  page_title AS aa_title,
  pp_value IS NOT NULL AS aa_is_dab,
  tl_from  IS NOT NULL AS aa_has_hatnote
FROM page
LEFT JOIN page_props    ON pp_page=page_id AND pp_propname="disambiguation"
LEFT JOIN templatelinks ON tl_from=page_id AND tl_namespace=10 AND tl_title="Hatnote"
WHERE page_namespace = 0
AND page_is_redirect = 0
/* Remove TV Seasons as they are effective the same item split (e.g. Casualty_(series_4), 1000_Ways_to_Die_(season_3,_2010)  */
AND page_title NOT REGEXP "_[(](?:seasons?|series)_[0-9]+(?:,_[0-9]{4}|)[)]$"
/* Remove "annualized" Professional Wrestling events */
AND page_id NOT IN (
  SELECT STRAIGHT_JOIN cl_from
  FROM category
  JOIN categorylinks ON cl_to=cat_title AND cl_type="page"
  WHERE cat_title LIKE "%_in_professional_wrestling"
)
limit 100; sleep 100;
SQL

Checking query status...
