Untitled query #23618

SQL

SELECT
  page_namespace,
  page_title,
  page_len
FROM afwiktionary_p.page
LEFT JOIN `user`
ON user_name = REPLACE(page_title, '_', ' ')
WHERE page_namespace IN (2,3)
AND page_is_redirect = 0
AND page_title NOT LIKE "%/%"
AND page_title NOT RLIKE "(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)"
AND user_name IS NULL;

/*
-- SELECT * FROM afwiktionary_p.revision_userindex LIMIT 100;
SELECT
 DAY,
 ACTIONS
 FROM (SELECT
   SUBSTR(log_timestamp, 1, 8) AS DAY,
   log_action AS ACTIONS
   FROM afwiktionary_p.logging
   GROUP BY DAY
   ORDER BY log_id DESC
   LIMIT 30)
   AS logs;

SELECT
  DATE(CONCAT(YEAR(rev_timestamp),"-",MONTH(rev_timestamp),"-",DAY(rev_timestamp))) AS day, rev_user_text,
  COUNT(rev_timestamp) AS revisions, sum(rev_len) "Bytes added"
FROM afwiktionary_p.revision_userindex
-- WHERE rev_user_text = 'Naudefj'
GROUP BY day, rev_user_text
order by day desc
limit 10;
*/
SQL

Checking query status...
