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 p2.page_id=pp2.pp_page AND pp2.pp_propname='disambiguation'
                WHERE pp2.pp_propname='disambiguation' 
                  AND p2.page_id != page.page_id
                  AND p2.page_namespace=0
                  AND CAST(p2.page_title AS CHAR) = CAST(page.page_title AS CHAR)
               )
  
ORDER BY page_random;
SQL

Checking query status...
