Indic Wikisource Community/SaActiveUser

script edit

https://quarry.wmflabs.org/query/53197

USE sawikisource_p;
SELECT
CONCAT("# {{target | user =",actor_name,"| site = sa.wikisource.org }}") AS rev_user_text,
COUNT(actor_id) AS recent_user_editcount
/*user_editcount*/
FROM revision
JOIN actor ON rev_actor=actor_id
JOIN page ON rev_page=page_id
WHERE actor_user IS NOT NULL
  AND page_namespace IN ('0','104','106')
  AND rev_timestamp BETWEEN 20060101000000 AND 20210330235959
GROUP BY actor_id
ORDER BY recent_user_editcount DESC
LIMIT 500;

Active user list as Jan 2018 to Jun 2021 edit

rev_user_text,recent_user_editcount

User talk:Puranastudy sa.wikisource.org 23854
User talk:Surekha Kamath sa.wikisource.org 15561
User talk:Soorya Hebbar sa.wikisource.org 15136
User talk:Shardashah sa.wikisource.org 11658
User talk:Swaminathan sitapathi sa.wikisource.org 8897
User talk:Venkateswaran raman sa.wikisource.org 7753
User talk:Siddharth Kamath A sa.wikisource.org 7539
User talk:Shubha sa.wikisource.org 4391
User talk:Narayanan V T sa.wikisource.org 3108
User talk:Suryanarayana jois sa.wikisource.org 2729
User talk:Sripathy K N sa.wikisource.org 2705
User talk:Kalpana Jayanna sa.wikisource.org 2611
User talk:Wikisource-bot sa.wikisource.org 2401
User talk:Jayashri R sa.wikisource.org 2006
User talk:Ravindranathamenon sa.wikisource.org 1971
User talk:V R Sastry sa.wikisource.org 1792
User talk:Shreevidya sa.wikisource.org 1597
User talk:Asha Gangur sa.wikisource.org 1464
User talk:Shruthi Krishna murthy sa.wikisource.org 1429
User talk:Madhu M Hegde sa.wikisource.org 1381
User talk:Geeta g hegde sa.wikisource.org 1342
User talk:Latha Raghavendra sa.wikisource.org 1330
User talk:Tkkaushikrao sa.wikisource.org 1272
User talk:Akshata1988 sa.wikisource.org 1251
User talk:Ranjanin sa.wikisource.org 1237
User talk:Divya navil sa.wikisource.org 1116
User talk:Manu Harsh sa.wikisource.org 1080
User talk:Tapaskhanra1998 sa.wikisource.org 1073
User talk:शारदा भट्ट sa.wikisource.org 1035
User talk:Shivam padhi sa.wikisource.org 864
User talk:KrishnamurthyAshwini sa.wikisource.org 817
User talk:Vidvat2004 sa.wikisource.org 776
User talk:Dr.Tirumalnhm sa.wikisource.org 690
User talk:Sailu.nittala sa.wikisource.org 640
User talk:PrashantPSJR sa.wikisource.org 619
User talk:Nagamani H R sa.wikisource.org 591
User talk:Pooja Seethur sa.wikisource.org 576
User talk:Sandhya seshadri 67 sa.wikisource.org 573
User talk:Soudamani M C sa.wikisource.org 559
User talk:Sharanya nagesh sa.wikisource.org 525
User talk:Srilakshmi Desai sa.wikisource.org 523
User talk:Dayasagara sa.wikisource.org 505
User talk:Naresh Kumar Dhiman sa.wikisource.org 466
User talk:सौरभ-पोडेलः sa.wikisource.org 460
User talk:Chandashwini K.G sa.wikisource.org 435
User talk:Sandhya Shree B N sa.wikisource.org 424
User talk:Vishvak2004 sa.wikisource.org 410
User talk:Indukwiki sa.wikisource.org 398
User talk:अभिषिक्तस्य शिष्यः sa.wikisource.org 396
User talk:NehalDaveND sa.wikisource.org 350
User talk:Priyanka Umakanth sa.wikisource.org 349
User talk:Ugovindaraju sa.wikisource.org 346
User talk:दीपंकर वर्मनः sa.wikisource.org 344
User talk:Sangeetha H A sa.wikisource.org 327
User talk:Shree sa.wikisource.org 314
User talk:Meena KL sa.wikisource.org 299
User talk:Pranavasagar sa.wikisource.org 277
User talk:Ramdas080854 sa.wikisource.org 268
User talk:Nivedita2015 sa.wikisource.org 262
User talk:Padukere sripathi herle sa.wikisource.org 261
User talk:Seetharaman G.K. sa.wikisource.org 259
User talk:VijayalakshmiR48 sa.wikisource.org 249
User talk:Shyla J.K sa.wikisource.org 228
User talk:Tanuja1111 sa.wikisource.org 219
User talk:EmausBot sa.wikisource.org 217
User talk:Shreedevi Suresh sa.wikisource.org 216
User talk:कन्हाई प्रसाद चौरसिया sa.wikisource.org 212
User talk:Gopika S K sa.wikisource.org 210
User talk:Seemantini Joshi sa.wikisource.org 210
User talk:Vidhusubhasdevadhar sa.wikisource.org 209
User talk:Sandeep vasant joshi sa.wikisource.org 208
User talk:Premaskanth13 sa.wikisource.org 205
User talk:Sandhyayajur sa.wikisource.org 203
User talk:Dr. Shantala Vishwasa sa.wikisource.org 200
User talk:Mahalakshmi Prasanna sa.wikisource.org 200
User talk:Raghavendra Purohit sa.wikisource.org 194
User talk:Brijesh 1810282 sa.wikisource.org 193
User talk:Chetanachetu sa.wikisource.org 189
User talk:Dattatreya vajralli sa.wikisource.org 189
User talk:Vrngud.12 sa.wikisource.org 186
User talk:Raghunaathan.S1810379 sa.wikisource.org 183
User talk:THARUN KAUSHIK U 1810381 sa.wikisource.org 177
User talk:Aditya.G.S. 1810478 sa.wikisource.org 175
User talk:Sayant Mahato sa.wikisource.org 172
User talk:Rakesh Naidu 1810283 sa.wikisource.org 170
User talk:Tushar nayak 1810382 sa.wikisource.org 170
User talk:Kshama B N sa.wikisource.org 169
User talk:Bharati Kolekar sa.wikisource.org 166
User talk:Col Sandeep Sharma sa.wikisource.org 165
User talk:Archana kanitkar sa.wikisource.org 160
User talk:Gaurav natesh 1810177 sa.wikisource.org 151
User talk:अनुनाद सिंह sa.wikisource.org 150
User talk:Prathimarajeshnaik sa.wikisource.org 146
User talk:Usharanimahesh sa.wikisource.org 145
User talk:Parvathavardhini sa.wikisource.org 145
User talk:Harshith N 1810178 sa.wikisource.org 140
User talk:Chandaswini.K.G sa.wikisource.org 139
User talk:Pariksht zodekar sa.wikisource.org 136
User talk:Deepakuniyalwiki sa.wikisource.org 122
User talk:Apurvapwiki sa.wikisource.org 122
User talk:Kpani39 sa.wikisource.org 122
User talk:Deepanarayanan123 sa.wikisource.org 121
User talk:Ashwath Hegde 1810176 sa.wikisource.org 121
User talk:Vishvas vasuki sa.wikisource.org 120
User talk:Sanjanashekhar sa.wikisource.org 120
User talk:Likith.s 1810388 sa.wikisource.org 118
User talk:Ajay kumar mr sa.wikisource.org 117
User talk:Mahathi A H sa.wikisource.org 116
User talk:Rsachi sa.wikisource.org 115
User talk:Lynette natasha sa.wikisource.org 114
User talk:Rojeebanchhorwiki sa.wikisource.org 112
User talk:Nallur Bhanumathi sa.wikisource.org 112
User talk:Sahana19 sa.wikisource.org 104
User talk:Vinayakshabhit sa.wikisource.org 103
User talk:Rashmitarout sa.wikisource.org 100
User talk:Pradyumna tripathi sa.wikisource.org 99
User talk:Shanthi25prasad sa.wikisource.org 94
User talk:Gvijay73 sa.wikisource.org 93
User talk:Veenaddg sa.wikisource.org 92
User talk:Suneethi.nm sa.wikisource.org 92
User talk:Preethinwiki sa.wikisource.org 92
User talk:Andaldesikan sa.wikisource.org 90
User talk:Ashokdangwal sa.wikisource.org 87
User talk:Bhoomikabv sa.wikisource.org 86
User talk:Sujathamn sa.wikisource.org 85
User talk:Snigdha PODDAR sa.wikisource.org 84
User talk:Yashaswinikwiki sa.wikisource.org 84
User talk:Manjunath Ka Ho sa.wikisource.org 82
User talk:Sujatha Mattur sa.wikisource.org 82
User talk:Sanjanags sa.wikisource.org 79
User talk:Wsgsp sa.wikisource.org 79
User talk:Ruthuswiki sa.wikisource.org 78
User talk:Prakashchandrameher sa.wikisource.org 78
User talk:Indirajwiki sa.wikisource.org 77
User talk:Ranjnishreeng sa.wikisource.org 76
User talk:Veena keshav sa.wikisource.org 75
User talk:प्रसन्न अडिगः sa.wikisource.org 75
User talk:Josa123 sa.wikisource.org 75
User talk:Pushpa Javahar sa.wikisource.org 75
User talk:Shridhar V Hegde sa.wikisource.org 75
User talk:Sahananwiki sa.wikisource.org 74
User talk:Sangeetsuna sa.wikisource.org 74
User talk:Madhusmitamishrawiki sa.wikisource.org 74
User talk:S shankara sharma sa.wikisource.org 74
User talk:Adityaasopa sa.wikisource.org 73
User talk:Akanksharahul sa.wikisource.org 72
User talk:1910183Trisha sa.wikisource.org 72
User talk:Sangeetha joshi sa.wikisource.org 72
User talk:HariRavikumar sa.wikisource.org 72
User talk:Nithyashreev sa.wikisource.org 71
User talk:DrJitendraTiwari sa.wikisource.org 71
User talk:Sivakumar.Seetharaman1910179 sa.wikisource.org 71
User talk:Atul.sonwani sa.wikisource.org 70
User talk:Kamalahulagappa sa.wikisource.org 70
User talk:Rakshahjoshi sa.wikisource.org 69
User talk:Priyadarshiniwiki sa.wikisource.org 69
User talk:Nivedhag sa.wikisource.org 69
User talk:Amruthavalliwiki sa.wikisource.org 69
User talk:Rakshithaswiki sa.wikisource.org 69
User talk:Vijayalakshmivwiki sa.wikisource.org 68
User talk:ShridharHegde276 sa.wikisource.org 68
User talk:Nivedhasswiki sa.wikisource.org 68
User talk:Rishikakrao sa.wikisource.org 68
User talk:Chaitanya Lakkundi sa.wikisource.org 67
User talk:Sampadada sa.wikisource.org 66
User talk:Dwitikrushnapanigrahi sa.wikisource.org 66
User talk:Leelavathi S 1960 sa.wikisource.org 66
User talk:Varalakshmiwiki sa.wikisource.org 65
User talk:Rakshithagbhat sa.wikisource.org 65
User talk:Jayprakash12345 sa.wikisource.org 65
User talk:NoychoH sa.wikisource.org 64
User talk:Aruna mydur sa.wikisource.org 64
User talk:Aishwaryaswiki sa.wikisource.org 64
User talk:Sreemathi V. Hegde sa.wikisource.org 63
User talk:Nandithats sa.wikisource.org 63
User talk:Umakantjoshiwiki sa.wikisource.org 62
User talk:Smrithimohan sa.wikisource.org 62
User talk:Srikantanayakwiki sa.wikisource.org 61
User talk:Maneeshasarma sa.wikisource.org 61
User talk:Vinaykumarshuklawiki sa.wikisource.org 61
User talk:Gajanan Bovikan sa.wikisource.org 61
User talk:Ramachandrabhatwiki sa.wikisource.org 60
User talk:Shashank1810380 sa.wikisource.org 60
User talk:Kavanalwiki sa.wikisource.org 58
User talk:PratikR48 sa.wikisource.org 58
User talk:Ganapatijoshi26 sa.wikisource.org 57
User talk:Ankushvhegde sa.wikisource.org 57
User talk:Bhuvaneshwaripg sa.wikisource.org 57
User talk:Advaitasb sa.wikisource.org 56
User talk:Niharikadash sa.wikisource.org 56
User talk:Ranjulapadhan sa.wikisource.org 56
User talk:Swethaswiki sa.wikisource.org 56
User talk:Sarva sastry sa.wikisource.org 55
User talk:PoojaChoudhary618 sa.wikisource.org 55
User talk:Saparyadh sa.wikisource.org 55
User talk:Shankararama sa.wikisource.org 53
User talk:Sibajisahoo sa.wikisource.org 53
User talk:P.Jayashree sa.wikisource.org 52
User talk:Subhashreemoharana sa.wikisource.org 52
User talk:Anish M. Nagpal sa.wikisource.org 52