Untitled query #82540

SQL

SELECT page_namespace AS "namespace", 
page_title AS "title", 
page_len AS "value" 
FROM 
  page
  LEFT JOIN page_props ON (
    (page_id = pp_page) 
    AND pp_propname IN (
      'disambiguation', 'expectwithoutscans'
    )
  ) 
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
    )
  ) 
ORDER BY 
  value DESC 
LIMIT 
  51
SQL

Checking query status...
