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 el_to NOT RLIKE "wikipedia|wikimedia|wikiquote|mediawiki|wikidata|wikivoyage\.org"
AND page_len > 100 AND page_len < 2000
AND user_editcount < 5
SQL

Checking query status...
