Fork of Pages and first rev ts, number of rev for a set of wikipedians by Arjunaraoc
This query is marked as a draft This query has been published by Arjunaraoc.

SQL

AخA
 
SELECT
  page_title,
  actor_name,
  rev_timestamp as first_rev_timestamp,
  COUNT(*) as num_of_revisions
FROM actor
LEFT JOIN revision
      ON rev_actor = actor_id    
LEFT JOIN page
      ON page_id = rev_page
WHERE page_namespace=0 AND page_is_redirect =0 AND  rev_parent_id= 0 AND (page_title in (SELECT page_title 
                    FROM page
            LEFT JOIN  categorylinks ON categorylinks.cl_from = page.page_id
        WHERE (page_namespace=1 AND (categorylinks.cl_to = 'B-Class_Andhra_Pradesh_articles' OR categorylinks.cl_to = 'GA-Class_Andhra_Pradesh_articles') )))
GROUP BY page_title
ORDER BY page_title,actor_name;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Query status: complete

Executed in 7.23 seconds as of Thu, 27 Apr 2023 01:22:24 UTC.