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%
9 seconds for .1%
5 minutes for an interval of 1%
So like 10 hours+ for the full db? :/

Gap threshold of 1e-10 gives 60 results for 1% (so 6k for full database). 
*/ 
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_is_redirect=0 AND
  	page_random >= 0.5 AND page_random <= 0.5001 AND -- limit to an arbitrary small subset of pages for query testing
 	-- exclude dab pages
	NOT EXISTS (SELECT * FROM page_props WHERE page_id=pp_page AND pp_propname='disambiguation')
)

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

SQL

Checking query status...