(Fair) VisualEditor statistics

SQL

USE cswiki_p;
SELECT years.page_title AS year, people.page_title AS person
FROM page AS years
JOIN pagelinks ON pl_from = years.page_id
JOIN page AS people ON people.page_namespace = pl_namespace AND people.page_title = pl_title
JOIN categorylinks ON cl_from = people.page_id
WHERE years.page_namespace = 0 AND years.page_title RLIKE '^1[0-9]{3}$'
AND cl_to LIKE 'Narození\_%' AND cl_to RLIKE 'Narození\_[0-9]{4}' AND cl_to <> CONCAT('Narození_', years.page_title)
AND NOT EXISTS (
  SELECT 1 FROM categorylinks AS cl2 WHERE cl2.cl_from = people.page_id AND cl_to = CONCAT('Úmrtí_', years.page_title)
)
LIMIT 10;
SQL

Checking query status...
