Untitled query #82540

SQL

ELECT 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...
