Articles created by set of users in Tewiki

This query is marked as a draft This query has been published by Pavan santhosh.s.
SQL

#to customize your query, follow the numbers to the instructions
#listed below the query. contact jmorgan@wikimedia.org if you need help.
SELECT DISTINCT(page_id), page_title
#1
FROM tewiki_p.page p JOIN 
#2
tewiki_p.revision r 
ON p.page_id = r.rev_page 
WHERE r.rev_user_text IN
#3
(
"Ramana1248",
"Achalamunigal",
"Sakthi swaroop",
"Rajagopala reddy",
"విజయ్ కొండ",
"Nandan1996",
"Vin09",
"Goliamarchand",
"Khairakki",
"Aaradhana krishna",
"Babavali virat",
"Chandanadevikorada",
"DURGAPRASAD.DP",
"Kushi 06",
"Matangi.rajesh",
"Nagaraju007",
"Syamsundarnhv",
"Venkateshchallagundla",
"Vijayasanthi. matha",
"Kalyaniaptourism",
"akshaygodke",
"harish-nithm",
"saikumar-nithm",
"gnitin-nithm",
"harikrishna-nithm",
"Rajeshvayala-NITHM",
"suneethkrishna.nithm",
"saikusuma-nithm",
"sohaib-nithm",
"Omerhussain-nithm",
"Suryareddynithm",
"suneetaattourism",
"PRADEEP DEEKONDA",
"shubham-nithm",
"Pallavisudheer",
"Pvramana24",
"shridhevie",
"drgsaroja",
"rajani nellutla",
"kiranmayi.ys",
"gpushpa",
"Boju srinivas",
"krishna.kunuthuru",
"Guntiraviou",
"Dayakargajula",
"Madhuri.ranirajitha",
"vasuvaddanam",
"Elkasudharani",
"Mohammed shoukat hayat",
"suresh thatha",
"rajkumareligedi",
"upendermaloth",
"గుర్రం సీతారాములు",
"Kothakonda suman",
"fello traveller",
"umbeflu",
"Ksatya2013",
"Gogushyamalamma",
"srinusorupaka",
"vrnayad",
"gollakirrankhumar",
"vijaypvk",
"upendereflu",
"biluka nirmala",
"Sunithabukya",
"srinusorupaka",
"chandueflu",
"adusumilli lavanya",
"b.babyrani",
"pvgalc",
"kommareddy rayapareddy",
"GSRALC64",
"juke.m13",
"kolasekhara",
"Amulmary",
"Sarojinichilivuri",
"KISHORE G A P",
"kotanivas",
"matheanil",
"bhaskarao",
"sucharithab",
"sirisha ignatius",
"hemajoshandhra",
"lakshmisrinivasu.ch",
"karthik.chd",
"pendyalajohn",
"srinivasan vijay",
"phycologistasr",
"balachandrakolli",
"mmdalc",
"alcsatish",
"pendyalajohn",
"sivakumari B",
"kjsudarshan2014",
"vijaykasthala",
"G.DOMINIC",
"marrivadasivaram",
"శ్రీనివాసశాస్త్రి",
"Dasari Praveen",
"రేమల్లిజాన్",
"saisureshsunkara",
"bhargavichinta",
"padma.alc",
"drgvasu.k",
"anuradha.maths",
"vijayraj.bollapalli",
"sahayabaskaran",
"Y.Subbareddyalc",
"Aaradhana krishna",
"Yvndamodararao",
"Tummala.srikumarphysics",
"Neelam bharathi",
"Nepoleon movva",
"sairam1566",
"drbsyamsundar",
"bprathima",
"bsivakumari",
"udayanil",
"nunnasr",
"wikinostra",
"dbkarun",
"wikiphirang",
"Jhansiranibanala",
"Divya Regadda",
"Nageswara rao nani",
"Roja Pichhika",
"Raveena putla",
"Niharika mudunuri",
"SHIVAnamritha",
"Sannidhi hema",
"Srikari smiley",
"Yasin mogal",
"Kommuji aswini",
"Srilakshmi chintapalli",
"Sammetasravani",
"Sonydaniel117",
"Srisarasijag69",
"Indiracute22",
"Rohini mandavalli",
"SURYA KIRAN",
"D. JANIBASHA",
"Padmadurga",
"Tirnadaanusha",
"Gopinathbatthula",
"Pusalapati",
"Sagarraju.b",
"Anilkalyanponnampalli99",
"K.swathi023",
"Kanyakumari karre",
"Kakaraparthi",
"Roy.d",
"Nayak",
"Priyanka Botany",
"Sunad praharshitha",
"Unnam.priya29alc",
"Cheva nikitha 666",
"Deepu21alc",
"Bujjimanu123alc",
"Nagaraju vuyyuru",
"Monika uppu",
"Parveen sultana",
"Usha karanam",
"Priya pandit",
"Stephinmathewc",
"Shaniba karikeerikandy",
"Susanthi songa",
"Shubham lucas 1",
"ASHISH KUMAR DUNGDUNG",
"Sumanjali.katta",
"Pramod kumar 14",
"Shaikamana444",
"Sunjiev",
"Sujjisupriya",
"Lakshmidurgaavutapalli",
"Priyanka mainampudi",
"Jyothsna.G",
"Amrutha.y",
"Himana koleti",
"U.raghavi",
"Rsailaja27",
"Ebinjosephv",
"Matla.tabitha",
"Prasanthiwp",
"Gaddam aravind",
"P somasekhar",
"Bhagyarekha lukka",
"Himabindu machcha",
"Monika uppu",
"Matte Akhilapriya",
"Sandeep prince7",
"devipriyawp",
"Suneela gudipudi",
"Annam mastanvali",
"Mandapaati dileep",
"Rama mandava 51423",
"M. MADHU KIRAN",
"Podilishedrak",
"K. venkateswara rao 1997",
"A.Sekhar1997",
"Sesha soumya",
"Sandhyapodili",
"B. manikanta 1998",
"Sowjanyateketi",
"Sai nvds",
"Simhadri keerthana kumar",
"Naveen kumar aadi",
"P. srinivas 1998",
"Ravivarma1997",
"Rachaprolu Pragna Dhamini",
"Saginala hemanth",
"Kata durga prasad",
"Ajay kumar chinnam",
"Vybhavapadma",
"Parameswara yeswanth",
"Yamini priyanka 1997",
"Mkkiran07",
"Amarsukhi",
"Samanvitha chiklee",
"Blessy sravya.p",
"Chirravuri Raghavendrarao",
"William carey1996",
"Y.sunny joshua",
"Gubbala.mounika",
"Vazram avutapalli",
"Kaveti samhitha",
"Sarojinibalabomma22",
"Lasya donkina999",
"Jami komali777",
"Jyothsna devi donkenya",
"Chittaluri pavani",
"Purushotham mokara",
"Y.D.KRISHNA SAI",
"TADANKI PRASAD BABU",
"Aparna naram",
"Ruth shakaina",
"Gubbala.likhita",
"Deepthi sree lankapalli",
"Seelam.mercy",
"Vennela tirupati",
"Karuna sree yalam",
"Satya sahithi burra",
"Shivanya bayyana",
"Lakshmi prasanna1998",
"Raj kumar enugupalli",
"Syamprasadvemula",
"Sivakumargarlapati"
"Meena gayathri.s"
) 
AND page_namespace = 0
AND r.rev_timestamp BETWEEN 
#4
20150701000000 
AND 
#5
20160827000000

# CUSTOMIZING THIS QUERY
# log in to Quarry and copy/paste everything in this window into a new query
# then follow the instructions below to customize each line
#1 specify the wiki: change 'mediawikiwiki_p.page' to the alias code for whatever wiki you want data from 
# (example: 'enwiki_p.page'). See the full list of possible wikis here: http://quarry.wmflabs.org/query/1103
#2 this needs to match the first alias. So if you entereed 'enwiki_p.page' above, change this to 'enwiki_p.revision'
#3 copy/paste the usernames of the people in your cohort between the parentheses, 
# put quotation marks around each name, and separate them with a comma outside the closing quotation mark
# don't put a comma after the last name in the list
#4 date to start counting (14-digit timestamp): year-month-day-hour-minute-second 
# use four digits for year, two digits for everything else
# you can use six zeros for hour-minute-second if you don't need to be that specific
#5 date to stop counting. same instructions as #4
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...
