Untitled query #82540

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

SQL

SELECT count(*)
FROM 
  page
  LEFT JOIN page_props ON (
    (page_id = pp_page) 
    AND pp_propname = 'disambiguation'
  ) 
WHERE 
  pp_page IS NULL 
  AND page_namespace = 0 
  AND page_is_redirect = 0 
  AND (
    page_id NOT IN (
      SELECT 
        page_id 
      FROM 
        page
        JOIN templatelinks ON (
          (page_id = tl_from)
        ) 
        JOIN linktarget ON (
          (tl_target_id = lt_id)
        ) 
      WHERE 
        lt_namespace = 250 
        AND page_namespace = 0 
        AND page_is_redirect = 0
    )
  )

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...