Untitled query #66063

SQL

SELECT
  page_title AS USER,
  page_len AS LEN,
  COUNT(el_to) AS LINKS,
  CONCAT("https://ru.wikipedia.org/wiki/User:", REPLACE(page_title, " ", "_")) AS URL,
  el_to AS LINK
FROM page
# LEFT JOIN user
# ON user_name = REPLACE(page_title, '_', ' ')
LEFT JOIN externallinks
ON page_id = el_from
#WHERE page_namespace = 2
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title NOT LIKE "%/%"
AND page_is_redirect = 0
AND el_id IS NOT NULL
#AND page_len > 190 AND page_len < 650
AND page_len > 2000
# AND user_editcount < 5
AND NOT EXISTS (
  SELECT el_id FROM externallinks
  WHERE el_from = page_id
  AND el_to RLIKE "toolforge|toolserver|wikiscan|wmflabs|wikipedia|wikimedia|wikiquote|mediawiki|wikisource|wikinews|wiktionary|wikidata|wikiversity|wikibooks|wikivoyage\.org"
  LIMIT 1
)
AND NOT EXISTS (
  SELECT pl_title FROM pagelinks
  WHERE pl_from = page_id
  LIMIT 1
)
GROUP BY page_title

-- AND el_to NOT RLIKE "toolforge|toolserver|wikiscan|wmflabs|wikipedia|wikimedia|wikiquote|mediawiki|wikisource|wikinews|wiktionary|wikidata|wikiversity|wikibooks|wikivoyage\.org"
SQL

Checking query status...
