Untitled query #24231

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

use sawiki_p;
select p.page_title, r.rev_timestamp from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_timestamp < '20180101000000' and r.rev_timestamp > '20170630235959' and r.rev_page = p.page_id and r.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");
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...
