Untitled query #21817

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
       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 revision.rev_timestamp < '20170801000000' and revision.rev_user_text in ("Alan.me111","
Arihant Jain98","
JOEL SONNY GEORGE","
sbhual1998","
thomaishu","
debangana.mukherjee","
GREESHMA PHILIP","
Mahika1997","
sonasarin97","
Varnika.T","
Vrinda Rajanahally","
Aditazees","
हर्षित","
Anandhi.C Thevar","
Diya Mohan","
Neelima Vinodkumar","
Shazia tarannum","
Shweta Jaju","
Subhasree V","
Sayanth","
Sugin Varghese","
Karlekar Lakshmi","
Maruvadakalyani","
Srinivasmahima","
Naeem.ponakkat","
Rranjithamuniraj","
Choco abin","
Deesha22","
ssr6912","
Ryanvarela","
Mehak1998","
Arushi0880","
Deeps Aggarwal","
prachi5399","
vasumathi$21","
nelcyjohn","
aishwaryakv97","
DHRUVA SRINIVAS","
Bridgetsabu548","
Anoop Vincent","
sirisha","
Vishnuteja7991","
Sonia(shona)","
jeffin shaju","
Kaushal721","
Jeya.s1997","
Satish545","
akshara97","
tanujapasumarthi","
Anshupal101","
Mahi Modi","
Neeti Varghese","
Jahan98","
Shrutibose15","
Vishakabhat","
Athulesh K Antony","
Sameer abdul wajid","
Bincy Binny","
dizna james","
Jerestine philomina Antony","
Karishma50","
megha raghu","
Neha Clare Minj","
lakshmipeddarapu","
Poojashree.k","
priya ramesh","
Vaibhavi Nagendra","
Rahulsundar","
Kavita Singh Chauhan","
Jekkam Yeshu 334","
Ganga .km","
Disha Karamchandani7","
MEGHNA M. MENON","
123sonasonichan","
sauravmenon1998","
singhprachi","
Ashwin.V Kumar","
Shilpa Singh rajput","
Aayushi RK","
Anju Abraham","
Angelia.c.u","
Pavithra Harindranath","
sheetal Davis","
Emmanuel.M Shine","
Hetvee S Patel","
Shashank Sekar07","
Hetvee S Patel","
Anitta Joseph","
Annet Mary James","
elvinjames18","
Shruthi Giridharan","
Samantray Renuka","
Aleena joy03.52","
raisaghosh","
aswathicepa","
Nirupama.H","
annigeriaishwarya","
Surabhi Ranjan","
Steve Joslee","
Prakruthi Prasad","
Adesh Thapa","
Clerida.dsouza","
Aborah614","
Damini Niranjan (in Devangiri font)","
jomol johnson","
Mahimarajiv1","
R M Cibi","
Tanvi Dayal","
Umehani1","
singhparul806","
Alan Homes","
jerinmohan","
njbhansali007","
itsmerohanjalan","
Aathira Kumar","
Kushboo Dialani","
soniabindra","
Hindi69","
Dheer2761998","
anngracejason","
Avina.66","
Iram abdulla","
Jyotsana kaur","
Demblamihika","
Prachi Jaisinghani","
Rjrodrigues208","
BHAVESH K MUTHA","
Syed shabaz Ifc","
Sunitha Choudhary1998","
Darshana.reddy325","
shiwani singh","
arshitha irene","
chandra1610349","
Gayatri Ram","
Rupeksha Chawla","
Saloni jain1998","
Kubra Aiman","
rakesh1610345","
Namratha Tater R","
YASH R MEHTA","
sushmitha56","
Simran Vardhan","
ritwickhota","
skidbro02","
Sameeksha2798","
dhriti98","
Ashishrc","
Mayank.mehta1198","
preksha1998","
G.marina17","
Swetha Elizabath","
rishi_ghanshani","
ayushi.bhardwaj1631133","
shubham h deora","
Tanvi Rao","
catherinegeorge1631135","
lovelyn.roberts26","
ananta0008","
anir0208","
edwinlock","
kanishka harishchandra nayak","
rakshithchhajed","
sachinakku1515","
nurav007","
ananya0008","
riya1997","
sushmita1998","
Karishma714","
Johnrejil","
naveenvarghese789","
Aditi.kumar.14","
Akshara97","
Anudevu98","
andreagonsalves","
seeker_in_action","
Diya kapur","
Malvika Tandon","
Safoora Shariff","
shriya.gajurel","
Afeefa Rafath","
Vineetha19","
Aa2451842","
pulkesh03","
Divya Kumari L","
Shoibakther","
Chaitranaidu","
Syed Muzammil 007","
diassid09","
aleenajoseph222","
Anudh Iyer","
Sneha kumar","
Sahana CP","
prathibha shree cp","
Nida afreen","
deepthi98","
caroline1610149","
kavya1610151","
nidhin chacko","
jibingeorge","
sridatta pradeep","
vishaaal.b","
Merlin152","
sahityashrivastava","
N rapsta","
Vipin Kumar Tiwari 123","
tiggaumesh","
sayema ryan","
Jojo Mathew","
Celebraity Salman","
Samraddhi Singh","
ANCY KISPOTTA","
Paarvathi.Christ","
Chippusarah","
15 APARNA","
Kukuanisha","
Shridevi P","
Meena Chaudhry","
Adorablemaitreyi","
Harithaooden","
Sharanyaudupa","
Prekshajain28","
Pragya98.chaudhary","
Calvin leone69","
Harini Thanigaivel","
Josephantony352","
Sayyed Humera Nayazudin","
sodhrajalali","
Suparvagm","
nidaakhann123","
deekshu","
Athul.RV","
Fatima Syed L.A","
Rennie Jasmine","
Sharon Sardar","
Vidhya Reddy","
M.INDHUMATHI","
Rahulnahar999","
sravya","
Ahamed31598","
AISHWARYA A PAI","
joshuapaul34","
vaishak1611373","
vana225410","
Dipen goal","
kinjalpasari","
Kavyahattalli","
Jojo Mathew cmi","
deepsi1610434","
Jaigoenka","
karangollerkeri","
Chikoo_786","
rijupoop445","
somaiah98","
zaidwajid786","
Arya S Babu","
Christina Johnson","
jaishreed97","
Mahima0510Srivastava","
Nayana2310","
Nivetha454","
Siri Vasist","
Tania.Ramesh1106","
Ekshu98","
sithara98","
Viharika2737","
anushashetty0288","
Chelsybothra","
JenHannaC","
priyabhatpbm","
RavikaChand","
yamaxy420","
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","
","
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","
    Sonali Beesabathuni","
bvvinay","
Chiraglodha6","
Manish Agarwal1620384","
Vishesh.C.G","
Rahul_Krishna98","
Suhani siddesh","
Pooja shan","
Reshma7","
canika.chandran","
THAMERA VARUNI N","
Chinmayi Bhoopalam","
Priyanka 1610485","
Rao Dimple","
Poojitha boganatham 123","
spandanaramesh","
chandralekha1997","
Shipra M","
Nammu tej","
Sourabh Meda","
Apoorva s prasad","
Shreya rajagopal","
Sourav Chandrasekhar","
Pranathipranu","
vidhi.mundhra","
shreya.vyas","
Thaarani123","
Harithaj07","
Aditya Alse","
Saketh Ramakrishna","
Sushruta T S","
Nitheshnithu1998","
Arundhathi P S","
Rohith J","
Rakshitha P G","
snehitha9815","
Sanjana T.R.","
Anuj Udupa","
Akhila jami","
supreeth grewal","
Prajwol Rai","
rolwincd","
Srivatsa jnr","
Praneeth Reddy Mukku","
THANVI.UPADHYAYA","
Kavya Devraj","
swathi mahesh kashyap","
sriniketh1999","
Jayanth Ramaswamy","
PUNITH BK SHETTY","
Divyaellore","
Pavithra T Nair","
sharvani bhatt","
vidyabhat001","
RaviTeja DS","
SUHAS V P","
Kajol S Kumar","
akshay kumar17","
Nikhl.T.S.67","
Chandrika S","
namitha1234","
Sharmada H S","
shreyars","
Vaishnavikiran","
Gcvamshi43","
sujay subramanya v","
Aishwarya arjun","
Lakra Sunila","
Meghana Subramaniya","
philotreesa","
Meghana.reddy810","
Harsha Harshith","
Nandan1657","
Bharathi.achaar","
Shwesmile","
Swathi kudly","
Trishnika sabe","
sripada naru","
Subrahmanya j","
likhith singhani","
Jayesh.b.khanwani","
Kashyap k arun","
POOJA N R","
NishaSrinivas1","
Payal Jhawar","
Ranjini Nadig","
priyasharmavishnu","
rahulvallu","
phani.2111","
akhil_kakani","
suhaas kutumbaka","
Chaitra123","
Harshi abhi","
Srikesh.shenoy","
Sumadhuranoor","
Nityashree Ramakrishna","
Shwetha.H.N","
Srimedha1997","
raodiv","
Madhumita1052","
Meghana H Rao","
arundathisv","
Raviteja","
Harshavardhan.a.k.m","
pavankalyan1530976","
suprithamanjunath11","
bookonpillow","
Aneesha Jatangi","
RAKSHITA.EDWINA","
smithamanju1234","
Alekhya.06","
Abhirama.bode","
sahanachoty","
timhna","
pisupati.nityasri","
saikumarcricket","
venkyapple1","
Shreya.vathsa","
sunil shm","
S.ashwini97","
Samkeerthana","
Shruta123","
ganeshprasad123","
Pkruthik1908","
siddharthdhodapkar","
sumukh ramesh","
Arundati ajjay narkar","
shilpasesha","
SRIKANTH T N","
Deekshaarya","
Pranathi A Udupa","
sreeshashankar","
bhavana.cbz","
mssriraksha","
simranpnayak","
soundarya.hiremat","
swathiha97","
sushma aithal")#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...
