test explain - Quarry

SQL

WITH pagelinks_cte AS (
  SELECT pl_from, pl_title
  FROM pagelinks
  WHERE pl_namespace = 0 AND pl_from_namespace = 0 AND pl_title NOT IN ('Control_de_autoridades', 'Wikidata')
),
page_props_cte AS (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname IN ('disambiguation', 'noindex')
), 
filtered_pages_cte AS (
  SELECT page_id, page_title
  FROM page
  WHERE page_is_redirect = 0 AND page_namespace = 0  AND page_title NOT IN ('Control_de_autoridades')
  AND NOT EXISTS (
    SELECT 1
    FROM page_props_cte pp
    WHERE pp.pp_page = page.page_id
  ) 
  LIMIT 5
)

SELECT p.page_id,
       p.page_title,
       pl.pl_title AS links_to
FROM filtered_pages_cte p
LEFT JOIN pagelinks_cte pl ON p.page_id = pl.pl_from;
SQL

Checking query status...
