page_random gaps

SQL

SELECT page_id, page_title, page_random, page_random - (LAG(page_random) OVER (ORDER BY page_random)) AS gap
FROM page
WHERE page_namespace=0 AND page_is_redirect=0 AND
  	-- page_random >= 0.5 AND page_random <= 0.51 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')
ORDER BY gap
LIMIT 600000

AخA
 
SELECT page_id, page_title, page_random, page_random - (LAG(page_random) OVER (ORDER BY page_random)) AS gapFROM pageWHERE page_namespace=0 AND page_is_redirect=0 AND    -- page_random >= 0.5 AND page_random <= 0.51 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')ORDER BY gapLIMIT 600000

SQL

Checking query status...