Untitled query #34615

SQL

use enwiki_p;

SELECT f.year, 
       Max(f.sugar) AS Sugar, 
       Max(f.salt)  AS Salt 
FROM   (SELECT s.year, 
               CASE 
                 WHEN s.ingredient_page = 'Sugar' THEN s.edits 
                 ELSE 0 
               END AS 'Sugar', 
               CASE 
                 WHEN s.ingredient_page = 'Salt' THEN s.edits 
                 ELSE 0 
               END AS 'Salt' 
        FROM   (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) AS s) AS f 
GROUP  BY f.year
SQL

Checking query status...
