Untitled query #85511

SQL

SELECT page_title, cl_to
FROM page
JOIN (SELECT page_title AS article_title
FROM page AS article
WHERE page_namespace = 0
AND page_is_redirect = 0
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from=page_id
                AND cl_to REGEXP "disambiguation_pages|[Gg]iven_names|[Ss]urnames|[Ss]et_index_articles|[Ll]ists")
ORDER BY RAND()
      LIMIT 125000) AS articles ON article_title = page_title
LEFT JOIN categorylinks ON cl_from = page_id
WHERE page_namespace = 1
AND page_is_redirect = 0

AخA
 
SELECT page_title, cl_toFROM pageJOIN (SELECT page_title AS article_titleFROM page AS articleWHERE page_namespace = 0AND page_is_redirect = 0AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from=page_id                AND cl_to REGEXP "disambiguation_pages|[Gg]iven_names|[Ss]urnames|[Ss]et_index_articles|[Ll]ists")ORDER BY RAND()      LIMIT 125000) AS articles ON article_title = page_titleLEFT JOIN categorylinks ON cl_from = page_idWHERE page_namespace = 1AND page_is_redirect = 0

SQL

Checking query status...