বছর অনুসারে বাংলা উইকিপিডিয়ায় নিবন্ধ তৈরি

SQL

SELECT DISTINCT Creator
FROM (
  SELECT actor_name as Creator,
  	COUNT(*) as Articles,
    SUBSTRING(rev_timestamp, 1, 8) as Date
  FROM revision
  JOIN actor_revision ON actor_id = rev_actor
  JOIN page ON page_id = rev_page
  WHERE rev_parent_id = 0
    AND page_namespace = 0
    AND page_is_redirect = 0
    AND rev_timestamp > '20060900'
    AND (rev_len > 149 #94% of redirects are smaller than this; 95% of articles are created longer.
       OR rev_len < 16) #very few redirects are smaller than 16 bytes, but a not-insignificant amount of articles start out smaller
  GROUP BY Creator, Date
  HAVING Articles > 24
) as Summation

SQL

Checking query status...