Untitled query #34615

This query is marked as a draft This query has been published by CXie (WMF).

SQL

Use enwiki_p;
SELECT 
               Extract(year FROM r.rev_timestamp) AS year, 
                       p.page_title                                          AS ingredient_page, 
                       Count(r.rev_page)                               AS edits 
                FROM   revision r, 
                       page p 
                WHERE  r.rev_page = p.page_id 
                       AND ( r.rev_page = 27712 
                              OR r.rev_page = 1605200 ) 
                GROUP  BY year, 
                          ingredient_page

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...