Bytes added or deleted

This query is marked as a draft This query has been published by Ananth subray.
SQL

use hiwiki_p;
SELECT anon_1.rev_user AS anon_1_rev_user,
            sum(anon_1.byte_change) AS net_sum,
            sum(abs(anon_1.byte_change)) AS absolute_sum,
            sum(CASE
                    WHEN (anon_1.byte_change > 0)
                    THEN anon_1.byte_change
                    ELSE 0 END
               ) AS positive_only_sum,
            sum(CASE
                    WHEN (anon_1.byte_change < 0)
                    THEN anon_1.byte_change
                    ELSE 0 END
               ) AS negative_only_sum,
            user_registration,
            user_name, anon1.rev_timestamp
       FROM (SELECT revision.rev_user AS rev_user,
                    (   cast(revision.rev_len as signed)
                        - cast(coalesce(anon_2.rev_len, 0) as signed)
                    ) AS byte_change
               FROM revision
                        INNER JOIN
                    page        ON page.page_id = revision.rev_page
                        LEFT OUTER JOIN
                    (SELECT revision.rev_id AS rev_id,
                            revision.rev_len AS rev_len
                       FROM revision
                    ) AS anon_2 ON revision.rev_parent_id = anon_2.rev_id
              WHERE revision.rev_timestamp  > '20160630235959' and rev_timestamp < '20170701000000' and rev_user_text in ("Anisha cruze","Anguraj33","Archana Venkat","Deeptha.s","Jyoti.Pari","kishanajain","Maaz1510132","poorvika m p","Pooja Rao S","Sagar jain 7198","ArsalanAA","यश्","kanchan.m97","ankita khandelwal97","asifanees96","Badal padma soni","Lijo baby cmi","Nirmal k Nivas","Rajath kumar singh 12","sathyarajmagaji1210","alisha jaison.c","Anagha Dhomne","Nancy Sushma","Nikitha Ravi","puja1996","Rumana fathima.31121997","taniyakroy","Alok Akka","Nithinreddy1234","monisahmed08","Navinbabu_1998","RAHUL TOM555","Sathyacharan","Anju Ans Saji","Madhu ghorawat","Mural quadras","Nupur A Bhagat","Punita Mercilin","Shreya.K.T","purvijoshi","Ankitmishi31","Deepak Jose Pandan","harshithbohra","Hemanth.Gowani.Jain","Jinu kumar","yashvardhansingh1997","Abhahoro","Brundha sk","Deepashree S","P.V.Kavya","Meghana M Nair","Monisha Pramila","Arathi Soni","Adirath1997","Akshaya Kumar H Dhelaria","Masab1510532","Shivul bhosle","SURAJ CHOUDHRY","Tushar solanki s","Arathi Soni","Arfa aliya","Divya Kanodia","Hita balasubramanya","Linda Adens","Manjusha M Nair","poojajain2097","skyeblack","Lily arul","AarushiChauhan69","AasthaAhuja27","Dhruv.Balaraman","Gopikastk","Jasmine.john470","Rashidhilla","sairindhrisengupta","Shilpa Ram17","shreyasjatti7","Sripoornap","Vishalsengupta","Devina Tiwari","Prerna goyal","Nishant00920","jasrajsin","Akshay97S","dipeshkrroy","Fabiosjohn","gokuls02","Gowtam Thakur","annettethomas97","jose.anu.cme","Dianaamathew","Hezil mendonsa","NEENA BONEYFUS","revathi_venkatesh","smrithy.r.sunil","heasues","amanswami786","darshan ashar","sagnikivanganguly","yashsaxena208","ankitagosh09","hajiraaiman","nidhi1997","himaashwath30","Abishekrl15156","Albin Babu1997","Amit24496","Joshin James","mohammedmarap","[at] hi.wikipedia.org","CHIPPY SUNIL","Mohana penumarti","Phicylinphill","Ananya1234","Anna Rthomas","Astha Narang","Davidjeremiah123456","Koushik.Narayanan007","mdharamshi01","Rachana pawar","Rajit kumar 007","Rheamabledavid123456","SANDRA THOMAS KOLAMKUZHYIL","satyamwiki","Shubam.agarwal4286","Violapires97","Reubenveersolomon","SinjiniGhosh12","riddhiman11","Addy27","akshatabadri","Chitra_iyer25","Deepshika09lunia","jayantikawiki","MD Karishma","Navya Senani 24","srinithi111","V Parvathy","acharmeghna","singh007n","smita3252","Mamtha J","Samyukta ingulika","Sadarangani nikita","nataliestanley27","jahnavichoosy3","isha225","Sneha Kukreti","SonikaK666","ShrutiSethia","UrviMalani14","gagan97arora","rinucmi","AnfaalAlam22","Shihamsauhan9","Ravina11714","berniceeaso","AyushiKhivesara","Kunjanpatel21","Sonakshi456","rupali.talan","Anjana r 1997","Advika.goenka","tarun1997","Elizabeth Mathew. TEP","Juhibaldev.TEP","Kajolchugh","Vaishnavimodi97","KavyaKhashnobish","abeytom","adishmathew","bharat0xxx521","S.HariOmPrakash","kayne98r","Neeraj933","RATWIK A K","ayushi0610","VismitaRavindra","ANAGHA NARASIMHA C.N","VivekKumarGaur","Teenu p scaria","ajith.james5","Ankur.jaimatadi","ashutosh.nadiganesh","Taher64786","Harikrishna Karuppiah","ALEENA ANCIL GEORGE","Amala Treasa Tom","Maria peter","Nambiar Neha","shamzzee","sauravnarain911","aasthamaskara","shreya.ramesh","BboyGJD","macbhat97","nehal jain 1998","ritikagoenka","88shalini","arindamchristite.science","Arlynnaby","Pranav.jose","DevangshuNandi1540630","Shruthi.n.christ","Bhoomika Rao","NikitaKishore","Snehasrivatsa","Diggy123","Noyal francis","RonaldDcostaRD241","amala joseph","Antara Kulkarni","jainyjoy.p","NADIYA S","P. Divya Reddy","Poorvi Singhania","aamnajaveed","snehaleen.h","melwycena","Arun Mathew Eyyalil","solomonjosh","usasangamesh","ishdasrox","MINUMASLIHA","Nimisha.nair","S niveditha","Ajaintt123456") #and page.page_namespace IN (0)
            ) AS anon_1
       JOIN user ON user_id=rev_user
GROUP BY user_name
ORDER BY absolute_sum DESC;
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...
