Untitled query #35262

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

use knwiki_p;
#select page_title from page where page_namespace='2' and page_title like '%Ananth_subray%';
select concat('[[User:',page_title,']]') from page where page_namespace=2 and page_title like '%Sushmitha.janardhana%'
or page_title like '%Sanjana740%'
or page_title like '%Nithin Kumar v454%'
or page_title like '%Akashgr%'
or page_title like '%Bharath  Raj149%'
or page_title like '%Bharath Raj149%'
or page_title like '%Gautham1710150%'
or page_title like '%Jnandevaiah M M 151%'
or page_title like '%Maddy 17%'
or page_title like '%Jayanth1710153%'
or page_title like '%Nikhil154%'
or page_title like '%Pavan155%'
or page_title like '%Rahulraj180%'
or page_title like '%Santhosh157%'
or page_title like '%shashanka158%'
or page_title like '%Thejas KR%'
or page_title like '%Vinodbk1710160%'
or page_title like '%aishu161%'
or page_title like '%Ambika162%'
or page_title like '%arokia jabashree%'
or page_title like '%AshlinG 164%'
or page_title like '%Chandana0165%'
or page_title like '%Gagana166%'
or page_title like '%Jennifer preethika167%'
or page_title like '%Kusuma0168%'
or page_title like '%Kusuma168%'
or page_title like '%Kusuma888%'
or page_title like '%169meghana%'
or page_title like '%Pooitha170%'
or page_title like '%Poojitha170a%'
or page_title like '%Sheena172%'
or page_title like '%p.soundaryagnani799%'
or page_title like '%Swetha174%'
or page_title like '%Vidyashree175%'
or page_title like '%Shashankgowda84%'
or page_title like '%211 pavanprashanth%'
or page_title like '%211pavanprashanth%'
or page_title like '%amogh_prakash248%'
or page_title like '%Chandru 249%'
or page_title like '%Chandru 249%'
or page_title like '%harry Prasad hari%'
or page_title like '%Johnrobin251%'
or page_title like '%Manikanta252%'
or page_title like '%Nagendra253%'
or page_title like '%niteshreddy1710254%'
or page_title like '%Pranav pemmaiah 255%'
or page_title like '%Venkatrakshak%'
or page_title like '%Shafi %'
or page_title like '%Shafi shafi%'
or page_title like '%Sinaialwyn%'
or page_title like '%Tony augustine259%'
or page_title like '%tonykodiyam%'
or page_title like '%Drvishruth %'
or page_title like '%Aishu261%'
or page_title like '%Amrutha262%'
or page_title like '%maria263%'
or page_title like '%Blessythomas 2641%'
or page_title like '%Blessythomas 264%'
or page_title like '%maria264%'
or page_title like '%Chandushree265%'
or page_title like '%geetha%'
or page_title like '%JeslinDaniel267%'
or page_title like '%Eswari68%'
or page_title like '%Nalinir269%'
or page_title like '%premachandresh270%'
or page_title like '%sherene272%'
or page_title like '%REENU INFANCIA%'
or page_title like '%Sparshitha273%'
or page_title like '%udaya274%'
or page_title like '%vimalpriyaj%'
or page_title like '%Pavankalyan123456%'
or page_title like '%Divyashree613%'
or page_title like '%Divyashree316%'
or page_title like '%A.Shreyas reddy %'
or page_title like '%A.Shreyas Reddy%'
or page_title like '%Arjun Devadhar %'
or page_title like '%K Deepu%'
or page_title like '%Deepak k s%'
or page_title like '%Harsha p%'
or page_title like '%H350%'
or page_title like '%Karthik s tewar%'
or page_title like '%Manjunath Singh MR%'
or page_title like '%prasan355%'
or page_title like '%Rehan Thimmaiah356%'
or page_title like '%Mr.bopanna%'
or page_title like '%Seban%'
or page_title like '%Sino Antony%'
or page_title like '%Rachan Uthappa %'
or page_title like '%Boss yathin%'
or page_title like '%Anjana62%'
or page_title like '%Arpitha. A%'
or page_title like '%364chaithra%'
or page_title like '%hema366%'
or page_title like '%Juliet367%'
or page_title like '%Mamtha11%'
or page_title like '%Mamtha kj%'
or page_title like '%mamtha k.j%'
or page_title like '%Nandini369%'
or page_title like '%Pushpavani.V370%'
or page_title like '%S Thejashree %'
or page_title like '%shivanimp372%'
or page_title like '%chinnu373%'
or page_title like '%VaishnaviShobaRani%'
or page_title like '%apoorva 75%'
or page_title like '%Mahesh D m%'
or page_title like '%Mahesh DM%'
or page_title like '%Mahesh DM408%'
or page_title like '%Tejaswinibudal%'
or page_title like '%Aditya K Hajeri447%'
or page_title like '%Dixith.N449%'
or page_title like '%Harsha450%'
or page_title like '%Likith451%'
or page_title like '%Manthan452%'
or page_title like '%Nithin454%'
or page_title like '%Prithvi raj N455%'
or page_title like '%Rohithramdas456%'
or page_title like '%Shashank457%'
or page_title like '%Srinivas458%'
or page_title like '%Yeshwanth.j%'
or page_title like '%Anne Preethi Paul%'
or page_title like '%Asfiya sultana 463%'
or page_title like '%Chaithra464%'
or page_title like '%Jeevitha S 466%'
or page_title like '%kvchaitra467%'
or page_title like '%Mary Nikitha KJ447%'
or page_title like '%Mary Nikitha%'
or page_title like '%Nanditha A S %'
or page_title like '%Raasi P 470%'
or page_title like '%classmate%'
or page_title like '%Sindhu472%'
or page_title like '%Surekha S%'
or page_title like '%Varshini474%'
or page_title like '%Yaharipriya %'
or page_title like '%preetham83%'
or page_title like '%Ajith kumar.s547%'
or page_title like '%Ashish548%'
or page_title like '%Durga Prasad MR %'
or page_title like '%ImmanuelNitish007%'
or page_title like '%ImmanuelNitish98%'
or page_title like '%Madan1710551%'
or page_title like '%Munikrishna.m%'
or page_title like '%Nelson. D%'
or page_title like '%pavanssp21%'
or page_title like '%Punith k r%'
or page_title like '%Sagar sambuddha YK%'
or page_title like '%Sriram0001%'
or page_title like '%Vijay vip%'
or page_title like '%Yeshwanth1710560%'
or page_title like '%AlphyM561%'
or page_title like '%Alphy16%'
or page_title like '%Anu Thomas562%'
or page_title like '%Asha Rani N563%'
or page_title like '%Chandana.R.Gowda%'
or page_title like '%Filcy565%'
or page_title like '%Jeevitha 566%'
or page_title like '%Kavana 1710567%'
or page_title like '%Meghana n raj%'
or page_title like '%Nanditha569g%'
or page_title like '%Nandithag569s%'
or page_title like '%Sharon betsy %'
or page_title like '%sharon betsy01%'
or page_title like '%Sushmitha%'
or page_title like '%V.Sushmitha%'
or page_title like '%Yashaswini.N575%'
or page_title like '%suhas181%'
or page_title like '%ಲಿಕಿತ್ ಎಮ್. ವಿ%'
or page_title like '%nithin354%'
or page_title like '%Likhithaa Dayal %'
or page_title like '%RishabhTM280%'
or page_title like '%Niharika281%'
or page_title like '%Prithviraj379%'
or page_title like '%Tejaswini819%'
or page_title like '%Darshan nayaka %'
or page_title like '%Harshitha Ravikumar %'
or page_title like '%Kiran1720679%'
or page_title like '%Kiran1720679%'
or page_title like '%Kiran1720679%'
or page_title like '%K Devika Devaiah%'
or page_title like '%Deeksha Eshwar%'
or page_title like '%Meghana111%'
or page_title like '%DIVYASHREE R.S%'
or page_title like '%Varidhi14%'
or page_title like '%Prithvi4960%'
or page_title like '%Pratheeksha Sreenath%'
or page_title like '%Sahanaskashyap%'
or page_title like '%sharon.serrao %'
or page_title like '%Angelin lidyea%'
or page_title like '%prajna a%'
or page_title like '%shambhavink%'
or page_title like '%shambhavii%'
or page_title like '%joamal%'
or page_title like '%Samhitha Bhat%'
or page_title like '%ShriGowri.C.G%'
or page_title like '%Kamal V%'
or page_title like '%Kamal samraat%'
or page_title like '%yellumalai%'
or page_title like '%Chandana Nagarathna%'
or page_title like '%Sakshi Raju Kiran %'
or page_title like '%Mahesh Nik%'
or page_title like '%Koodalasangamadeva%'
or page_title like '%Na manasu%'
or page_title like '%Kushal P K%'
or page_title like '%Manoj bangalore%'
or page_title like '%ranjithkumar.D%'
or page_title like '%ranjith.neymar%'
or page_title like '%Hemadri hema%'
or page_title like '%HEMADRI%'
or page_title like '%GhanaviiRaj%'
or page_title like '%Noor Ayesha H S%'
or page_title like '%Praveena pobbati %'
or page_title like '%Praveena V P%'
or page_title like '%navinrakshitha %'
or page_title like '%Vidyashree.v.%'
or page_title like '%Vidyashree venkatesh%'
or page_title like '%Vidyashree venkatesh %'
or page_title like '%Vidyashree.v.%'
or page_title like '%Apoorva C N%'
or page_title like '%Apoorva C N %'
or page_title like '%Priyanka aradhya%'
or page_title like '%Sathya maya%'
or page_title like '%Sathya lakshmi40%'
or page_title like '%Srujana U Shankar%'
or page_title like '%Shweta vs%'
or page_title like '%BhumikaAnantharaman%'
or page_title like '%Punith_p_156%'
or page_title like '%Srikanthhubli.29%'
or page_title like '%bernadethjoshiba.jr%'
or page_title like '%bernadethjoshiba%'
or page_title like '%chandanamayas%'
or page_title like '%deeksha60%'
or page_title like '%monicavinodkumar%'
or page_title like '%nanditha62%'
or page_title like '%navya063%'
or page_title like '%Rkanishka%'
or page_title like '%ranjini166%'
or page_title like '%Shilpa.A%'
or page_title like '%sneha68%'
or page_title like '%Soniya196%'
or page_title like '%Soniya169%'
or page_title like '%RAMAPURAM TARUN%'
or page_title like '%sarah ayman63%'
or page_title like '%Vickyswiss%'
or page_title like '%Tejasisboss%'
or page_title like '%anita.babu@science.christuniversity.in%'
or page_title like '%Anitababu1599%'
or page_title like '%anusha.k@science.christuniversity.in%'
or page_title like '%Anushakrishnakumar%'
or page_title like '%Anusha kumar%'
or page_title like '%ashritha.k@science.christuniversity.in%'
or page_title like '%ashritha.k%'
or page_title like '%Bright Antony%'
or page_title like '%christina.joshy%'
or page_title like '%Harshithaguddu %'
or page_title like '%Harshithaguddu%'
or page_title like '%Jeniferprincy%'
or page_title like '%Karishma kavya%'
or page_title like '%Karishma kavs%'
or page_title like '%RoshiniLawrence%'
or page_title like '%Shamreen R A R%'
or page_title like '%Vibhashree G M %'
or page_title like '%Balaji352%'
or page_title like '%KARTIK53%'
or page_title like '%N.S.ASHOKKUMAR%'
or page_title like '%ashok.ns99%'
or page_title like '%nikhilta0356%'
or page_title like '%vinay357%'
or page_title like '%Chaitra K%'
or page_title like '%kavya359%'
or page_title like '%Namratha Suresh%'
or page_title like '%nishadsouza%'
or page_title like '%nishajacob%'
or page_title like '%NISHADSOUZA1999%'
or page_title like '%Kannisha123%'
or page_title like '%christnisha1%'
or page_title like '%Nivetha r s%'
or page_title like '%Pooja.R%'
or page_title like '%Prathika0364%'
or page_title like '%Sahanajain365%'
or page_title like '%Sahanjain365%'
or page_title like '%swathio366%'
or page_title like '%Swathi0366%'
or page_title like '%VarijaaSri367%'
or page_title like '%Vidya369%'
or page_title like '%Madhu shree .R%'
or page_title like '%Appanna P P%'
or page_title like '%GURURAJ B GAWANALLI%'
or page_title like '%km.manoj.kannada%'
or page_title like '%kannayanyadav%'
or page_title like '%Koushik rajesh%'
or page_title like '%manishchrist%'
or page_title like '%Mahadevappachrist%'
or page_title like '%Shashank.nayak%'
or page_title like '%Sreecharan S Ajjagola%'
or page_title like '%The.mad.agni%'
or page_title like '%Vinaykumar14%'
or page_title like '%ann mary.science%'
or page_title like '%deepika@christ%'
or page_title like '%deepikachrist%'
or page_title like '%Bhagyalakshmi K%'
or page_title like '%Dhanya Y Bharadwaj%'
or page_title like '%Dhanya Bharadwaj%'
or page_title like '%Greeshma Reddy K%'
or page_title like '%jhansi.kl%'
or page_title like '%Madhu shree%'
or page_title like '%monisha james%'
or page_title like '%Muthamma473%'
or page_title like '%prakrutisudarshan%'
or page_title like '%Harsha Priyanka Chopra%'
or page_title like '%priyanka.G.R%'
or page_title like '%Sai Meera%'
or page_title like '%Radhavishwanathappa%'
or page_title like '%radhachrist%'
or page_title like '%Thanushashashi%'
or page_title like '%yashodha.v%'
or page_title like '%Akhil k varghese56%'
or page_title like '%Amith557%'
or page_title like '%kamal558%'
or page_title like '%Yashwanth. M%'
or page_title like '%bhagyalakshmi561%'
or page_title like '%Bhavana.c.yadav%'
or page_title like '%bhoomika563%'
or page_title like '%chaithra.m 564%'
or page_title like '%jesnyelsy566%'
or page_title like '%kruthiraj567%'
or page_title like '%Nithya568%'
or page_title like '%Pallavi.N.M%'
or page_title like '%Pallavi.N.M%'
or page_title like '%Pallavi570%'
or page_title like '%Pallavi  Sreenivas%'
or page_title like '%Priyanka.D.V%'
or page_title like '%Priyanka.M 573%'
or page_title like '%Rakshitha h m%'
or page_title like '%Rakshitha h.m 574%'
or page_title like '%Rakshitha h.m  574%'
or page_title like '%Thirtha m shetty 575%'
or page_title like '%Pappashetty575%'
or page_title like '%Rakshith gowda H N%'
or page_title like '%Sumanth658%'
or page_title like '%CHAITHRA659%'
or page_title like '%manya660%'
or page_title like '%Nayanaj61%'
or page_title like '%Neha662%'
or page_title like '%Sanjukta663%'
or page_title like '%PrinceTC%'
or page_title like '%Aditi T S%'
or page_title like '%Aditi temkar%'
or page_title like '%Anjanim734%'
or page_title like '%Dechamma.mb%'
or page_title like '%Mahalakshmiabhishek%'
or page_title like '%Nayana Rajashekar Katteppanavar%'
or page_title like '%Preetha738%'
or page_title like '%ramya739%'
or page_title like '%Sanjanasanju%'
or page_title like '%Sanjana740%'
or page_title like '%Sanjana740%'
or page_title like '%Sheethal Dechamma U N%'
or page_title like '%Usha d s%'
or page_title like '%veena743%'
or page_title like '%Omkar R K%'
or page_title like '%Namratha S%'
or page_title like '%Thejus C.S%'
or page_title like '%SC bose%'
or page_title like '%Sagarika Prakash%'
or page_title like '%vj hemanth484%'
or page_title like '%Yashpal Rajputh%';
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...
