Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Ananth subray
.
Toggle Highlighting
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 > '20170630235959' and revision.rev_timestamp < '20180101000000' and rev_user_text in ("bhanu shankar","Harshit Govindarajan","Meghana290399","Chopperla Sanjana ","Mopurhari","Nikitha cp","S Subramanya Tejas","Kirankumar2029","Tejhas","PrernaJain","Rachana KP","S C Vaishnavi","G Uthara","T.R.Mayil Niveditha","Charan P Shetti","Hitasha chavan","PULLIKANTI VINAY KUMAR","Ssurab0221","Tejas prasad","Kiran CK","Nehaal Rao","hrithi reddy","Yashasp9","Anoop Chandrasekar","Aman Mardia","Amulya Nagaraj","Sai Pradyumna ","Mahalakshmi.S","DeekshaNRao","prashanth s","Varun583","Ahokshaj73","Aishwarya.kotam","RBalaji00","Aishwarya.kotam","vummadichetti sri sai vardhan ","Adhokshaj73","Shivani1730598","manikantesh_doradla","Pallavi N Sastry","madhura.u","Bharat Padmakar Hegde ","vummadichetti sri sai vardhan ","Gavvala Anjan Kumar","cecilsingari ","samireddi.harika","Parinitha Ravi","Anirudhpranesh","Kaja.Bhanu7","Nishanth Adiga","abdulrahaman786","Karunakirtivasan","Sudharshana369","anvitha tanguturi","Dheeraj bommisetti","Nachiketh R Rao","Bharath Umashankar","Spoorthi A Prasad ","Avilala.Arun","Vibha bharadwaj","jyothi.swaroopa","Vishnu srinath","Abdul ravoof","Achyuth Kumar Akula","Sugnan p v","Anirudh mahesh","Kishoremahadev","ranjini166","Soniya196","Kalburgi","Akshara 1730549","Anirudh. k. varma","Rugveda.M8","Nikhil kumar reddy. Kannari ","Snemagic","NandashreeNK","Sugnan p can ","Ashwini.M1730596 ","Yoganandha","sampadaupadhyaya","Balaji muvva","Sorra.varshini88","Adabala.Vineela82","krupsi_1999","Kartikeya Avadhani","Sharu.nandu99@gmail ","Vamshikrishnashalivahan892","navyachandrika","navya chandrikha bayapureddy","Kaushik_C","Kavya Chandrasekaran","Medhavini varakhed","shriranjani.s","supreeth2443","Neeharika_Saravana","Sharvari Somayaji B","Nikita hegde","Sai Pradyumna ","Pampana rahul","Himaswini.1999","NIRANJAN V NANDAKUMAR","Ananya Shenoy","SHREE LEKHA.Y.N","Ganakshi Gehlot","Ritika Rathi","Yoga nanditha ","Nivetha.V","Nidhi Anil","anirudh. k. varma","lavanya984","minnumariya985","Jyothi.swaroopa.k","Karthikeyan481","Gagan rajogoapal","narendranvalliappan","anjitha181","sudharshana38","Kav chandrasekaran","Shivani1730598","nikitha hegde","yashas1999","Neeharika S","Likitha. B","Likitha. B","Dhanish.N","Likitha. B","pradeep kumar i am here","Gagan rajagopal","Amaresh kothamaddi ","Nagori bhuvan","sudharshana6","sudharshana17","Aakashhari","RAHUL SINGH 91","Ritika Goswami","द्युति दत्ता","Lakshya_IAS","AnneJoseph7","Delisia.10","Jojin Varghese ","Neems.pramo","aakanksha_madhavaram","Elna Siby Jose ","Yana Kaveramma","Aishwarya Mathew","Falguni Jain D ","raopavan","Sathvik7846","_utkarshchaudhary_","Sagar gambhira","Anna Serene Boby","koushickthelegend","Pranavsuresh17","Manasa08","Beulah","poulami.ghosh","paawani.tiwari ","M Vibha Venugopal","Ankursingh.1740254","Laxmynarayan-username","shreya8899","medha_srivastava","hardikkothari999","Samskrathi","Bhagya Jayesh","Anjali Anil T","mohona.dey","Bhagya Jayesh","Charithranayak","Shruti bhamidipaty ","Raksha_2","Raksha_2","Rishika Hari","Rishika Hari","AneeshChacko","raghuttam_h","madiya341","madiya341","madiya341","Sneha George ","Kalyani j","Rahulnivi","vriddhi","NivedRajeev","Muskaan Agrawal","Muskaan Agrawal","Ramya haritha","SADIQ SYED","SADIQ SYED","SADIQ SYED","amansharma1","Niharikaa.mehta","Pooji1998","Sudeshana MB","gautam_malhotra","1710129 Akash","Sudeshana MB","Simranmeher","crmaaz7","crmaaz7","Sudeshana MB","raj.nisha75@gmail.com","maaima","Sudeep mallula","KRISHNA IYER S","shah_jhinal","Cecilia Nikhita ","Nikita_PME_349","samarth1612","Richakumari","Abzal sheema ","NANDINI02","ARSHAD007","Mahima Bothra","Manasa08","Poorva Samdani ","Beulah","Poorva Samdani ","RohanKrsn","Anson Joy","Aayushi jain","Aayushi jain","Aayushi jain","Shaista Taskeen T","Jaan26499","Greets.99","Madhurika agarwal","ANSHU K","ghufran shariff","vrindalobo","Vijay Murtgy","Saheema m","Rishabh Kanoi","Pratyush Bista","Alex praveen raj","Manohar seervi","greeshma 19","Harsh M Jain(1 BCOM B)","Kotni Charan kumar","vaishhh","ananya61","Mayukh98","1710129 Akash","anant.maheshwari","anant.maheshwari","Amy Jose kollannoor","Samar Singh 5","hemraj45","Zannia Mary Rosw","Sree shalini","Ralph.S","Thanuja vivek","Pooja2345","m.s.ananya","एय्नज्ल मात्यु","Sariya Kausar(1 BCOM B) ","Padhukoneti340","Padhukoneti340","SavanAntony","Vanshikaramsisaria","riya shaji ","Syeda halima mariam ","Abzal sheema ","Abzal sheema ","Anjali Abraham","Saman Parvin ","Khushi h giriya ","1710140 jincy","1710140jincy","Anjali Abraham","Sabron Nathan Mendonca","Yathinkumar","Teninpereira","Yathinkumarp","preranaa.gupta","Neharajan.cep","sohamchatt_1999","Nandakumar kuyiloor"," Anmol_Kamath_K","julia.joseph","Rohanrenukappa","manish.mpkumar","Joshua TV","Joshua TV ","Varsha Dechamma M S","anushkamunshi","दीपक.एस","Nitin Chopa","Laxmi Suvedi1","Upadhyay priyanka","K Nanditha ","pulkituppal","Jyothsna Reddy ","Mahasvin.Mittal","ashwin8558","akashkmishra","Padhukoneti340","Sdasain1998","Vaishnavi SH","Megzz_Bopzz ","Catherinejoseph","sahni_nikita28","Betsy.hi25","Maansi Agrawal","mahishashish","Arpita agrawal","Sloka Reddy","Sandeeprutger7","Prerana kadur","Elza Joseph","Kotni Charan kumar","riddhima_gupta_19","Shilpatonys","Zainab J Kapadia","Sdramw ","Nivedita17","Shravya.nair","Nikhilgeorge10","Jaskirat1212","deeksha47","sanjana.hiremath","Ankita_vig","ganesh44","Bajpairadhika","Yuktisheth","विगनेश.लिख","bhajGR","namansodhani99","Safia Zafar","Safia Zafar","Tina.dsouza","Anooya.swamy","Vishalbhadri1738","Rakshithaa Umesh","SADIQ SYED","Treesa.rose","Mohitaf10","Preetha Elumalai","Merlin George","हस्नैन्","Adwaith Suresh","रोबिन्","Sandra T.S","Mohammedkl5253","Alanpeter","Nikhil Antony","Chinmaya.","Arshi10_4","salmansuhail1710","Kdugar","Srutha Keerthi RAG","Srutha Keerthi RAG","Srutha Keerthi RAG","Chanchal1998 ","shubhneet arora","sreehariks1599","sreehariks1599","Vishnu Ganesh 50","Srutha Keerthi RAG","kavyakdas","abhaysharma1","Srutha Keerthi RAG","Srutha Keerthi RAG","Mohitaf10","Rahulsharmachristuniversity ","Biby Elizabeth Skaria","Biby Elizabeth Skaria","Biby Elizabeth Skaria","Biby Elizabeth Skaria","Biby Elizabeth Skaria","Biby Elizabeth Skaria","Rosesona joy","Litricia","Pranav Pushkar","Mansi Goyat","Ramakanthr007","Harsh Punjwani","Meena","Shreenidhi53","Shreenidhi53","Bhagya Jayesh","Kartik Gulgulia S","Mohammedkl5253","Sumukh1740877 ","Manacykumar","ajithkphilip","Sanketghatnatti1274","Shayana deb","Shayana deb","M.bose","malvika singh","Akshaya361","Jincy S Mathew","Daman.M.Bhandari","Sudeep venkat","Mohammed5253","Akhil02","Akhil02","Mehvishkhan","Tina.dsouza","Santoshsekhani6","Bavna.Mathai","Mohammed saadath","siddhant khattar","Vishnu Ganesh 7","Aishwarya Naresh","Lakshya2912","nikhilesh_bharadwaj","suyash.shukla","Abhijeet Singh Rathore","Jeffrey1502","chaitanya2912","Jojin Varghese ","anitajoy99","aliyaalicetjomas","roy.akarshak","Fairen Freddy","Yuktisheth","Sruthakeerthi1999","Simran1bcomb","Tavakley","Anu.preeti","Herbert.atheena","Suresh23","Syed safwan ahmed","hari_aakash","Syeda halima mariam ","Rohan.Agarwallll","Mohitaf10","agarwalm1711","Shaistataskeen","Gopika_suresh","Una_Flux ","Keerthisripatnala","Keerthisripatnala","uditrathi","Joyel333","Simransahoo","hiyachaudhry","Crystal Ann Pinto ","Jinu maria varghese","neelabh107","Rekha","S DIVYA BHARATHI","S DIVYA BHARATHI","JEENA SANTO","Justin783","FarihaTabassum","Sanoli Brishti Chowdhury ","Suyash Shukla1999","YASH LOYA","Sidhi Jain","Immanuel Sam Chiramel","ANGELMATHEW1","Sherin Merin Eldho","Chanchal1998","marycathygasper","Sariyakausar(1BCOMB)","Gauri Rao","Athulya (1BCOMB)","Krupa genetics","Priyanka(1BCOMB)","Manacy kumar"," PranavPushkar1272","anirbanmukherjee5471","Beulah80","meenasai","deejarvis006","YASH LOYA","Dipam.Sharma","shiviii_raj","Prerana kadur","Mariyanus123","ashwin8558","Sariya1bcomb","Greeta_99","Priyankajagadale","Prajwal simha","saadhana_rao")#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
.
Checking query status...