Untitled query #7114

SQL

use ptwiki_p;


select sum(leng) from (SELECT  IF(r.rev_parent_id = 0, CAST(r.rev_len AS INT), CAST(r.rev_len AS INT) - CAST(rp.rev_len AS INT)) AS leng FROM revision r LEFT JOIN revision rp ON r.rev_parent_id = rp.rev_id INNER JOIN page p ON r.rev_page = p.page_id WHERE (r.rev_user_text = "Icecube09" OR r.rev_user_text = "Pedrohndc" OR r.rev_user_text = "Celsocag" OR r.rev_user_text = "Luan_Procópio" OR r.rev_user_text = "Alcirema" OR r.rev_user_text = "Gabs763" OR r.rev_user_text = "Rodrigolimaj" OR r.rev_user_text = "Jorge_Márcio1891" OR r.rev_user_text = "Rozalvojr" OR r.rev_user_text = "Jéssica_rueb" OR r.rev_user_text = "Jaquie_Livino" OR r.rev_user_text = "Jardson1980" OR r.rev_user_text = "Telmafarias" OR r.rev_user_text = "Hennafenix1" OR r.rev_user_text = "Marlon.ney" OR r.rev_user_text = "Carlos_DIn33" OR r.rev_user_text = "Gleycem" OR r.rev_user_text = "Meretelecentro" OR r.rev_user_text = "Isaurathome" OR r.rev_user_text = "Eliane_maria_couto" 
OR r.rev_user_text = "Hunter6537")  and r.rev_timestamp < 20160128000000 and r.rev_timestamp > 20160125000000 and p.page_namespace = 0) a;
SQL

Checking query status...
