Active Incubator users in ruwiki

Fork of Most active Incubator users in ruwiki per year by Putnik

This query is marked as a draft This query has been published by Putnik.

SQL

SELECT
	actor_name,
    COUNT(*) AS edit_count,
    MIN(FLOOR(rev_timestamp / 10000000000)) AS first_year,
    MAX(FLOOR(rev_timestamp / 10000000000)) AS last_year
FROM revision
JOIN page ON page_id = rev_page
JOIN actor ON rev_actor = actor_id
WHERE (
      page_namespace IN (102, 103) -- Инкубатор: и Обсуждение Инкубатора:
      OR page_id IN (
        SELECT page_id
        FROM page
        WHERE page_namespace = 104
        AND page_title LIKE "Инкубатор%"
      ) -- Проект:Инкубатор/...
  ) AND page_id != 8774484 -- Инкубатор:Песочница
GROUP BY rev_actor
HAVING
	last_year = 2023
    AND first_year < 2023
    AND edit_count > 50
ORDER BY edit_count DESC

SQL

Checking query status...