Untitled query #63821

SQL

-- CORE: 0.192735719584
-- Core: 0.235579655725117
SELECT page_id, page_title, pp_propname
FROM page LEFT JOIN page_props ON page_id=pp_page AND pp_propname='disambiguation'
WHERE page_namespace=0 AND page_random >= 0.1927 AND page_random <= 0.1928 AND page_is_redirect=0
	AND pp_propname='disambiguation'
    AND EXISTS (SELECT * FROM page AS p2 LEFT JOIN page_props AS pp2 ON page_id=pp2.pp_page AND pp_propname='disambiguation'
                WHERE pp_propname='disambiguation' AND p2.page_id != page_id AND pp_propname='disambiguation'
                  AND page_namespace=0
                  AND UPPER(p2.page_title) = UPPER(page_title)
               )
  
ORDER BY page_random;
SQL

Checking query status...
