enwiki pages unlikely to be hit by Special:Random

Mainspace enwiki articles which have a page_random value which is very close to (but greater than) that of another page. These pages are very unlikely to be reached when hitting the "Random article" button. (See: https://en.wikipedia.org/wiki/Wikipedia:FAQ/Technical#random)

SQL

/* ~1 second for an interval of .01%
5 minutes for an interval of 1% (without dab filtering)
*/ 
WITH copy AS 
(
  SELECT ROW_NUMBER() OVER(ORDER BY page_random) AS rownum, page_id, page_title, page_random
	FROM page
	WHERE page_namespace=0 AND page_random >= 0.5 AND page_random <= 0.5001 AND page_is_redirect=0
	AND NOT EXISTS (SELECT * FROM page_props WHERE page_id=pp_page AND pp_propname='disambiguation')
	ORDER BY page_random
)

SELECT cur.page_id, cur.page_title, cur.page_random, cur.page_random - prev.page_random AS gap
FROM copy AS cur
LEFT OUTER JOIN copy AS prev ON cur.rownum = prev.rownum+1
HAVING gap < 1e-9
ORDER BY gap

SQL

Checking query status...