Untitled query #7125

SQL

use ptwiki_p;


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, r.rev_user_text, p.page_title, p.page_namespace, r.rev_timestamp 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 = "Rodrigo Padula" OR r.rev_user_text = "Zoldyick" OR r.rev_user_text = "José Amoras"
                       OR r.rev_user_text = "Xavier201642"  OR r.rev_user_text = "Suellen as"   OR r.rev_user_text = "Rafael Jobs2" 
                        OR r.rev_user_text = "Fabiobarros") and r.rev_timestamp < 20160117000000
order by 5,4,2;
SQL

Checking query status...
