Untitled query #33034

SQL

USE enwiki_p;
SELECT g.page_id, g.page_title, g.page_namespace, c.rev_id, c.rev_timestamp, c.rev_user_text, c.rev_user, case when ct.ct_tag IS NULL then 'false' else 'true' end as system, case when c.rev_parent_id = 0 then 'true' else 'false' end as new_article, CAST(c.rev_len AS SIGNED) - CAST(IFNULL(p.rev_len, 0) AS SIGNED) AS byte_change FROM revision_userindex c LEFT JOIN revision_userindex p ON p.rev_id = c.rev_parent_id INNER JOIN page g ON g.page_id = c.rev_page LEFT JOIN change_tag ct ON ct.ct_rev_id = c.rev_id AND ct.ct_tag IN (NULL) WHERE g.page_namespace IN (0,1,2,3,4,5,10,11,118,119) AND c.rev_user_text IN ('Symac') AND c.rev_timestamp BETWEEN '20160122' AND '20190128';
SQL

Checking query status...
