Untitled query #66063

SQL

SELECT
  page_namespace,
  page_title,
  page_len,
  CONCAT("https://be.wikipedia.org/wiki/User:", REPLACE(page_title, " ", "_")),
  el_to
FROM page
LEFT JOIN user
ON user_name = REPLACE(page_title, '_', ' ')
LEFT JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 2
AND page_is_redirect = 0
AND page_title NOT LIKE "%/%"
AND page_is_redirect = 0
AND el_id IS NOT NULL
AND page_len > 100 AND page_len < 2000
AND user_editcount < 5
AND NOT EXISTS 
   (SELECT el_id FROM externallinks
    WHERE el_from = page_id
   -- AND RLIKE "toolforge|toolserver|wikiscan|wmflabs|wikipedia|wikimedia|wikiquote|mediawiki|wikisource|wikinews|wiktionary|wikidata|wikiversity|wikibooks|wikivoyage\.org"
    LIMIT 1
   )
SQL

Checking query status...
