Jump to content

Indic Wikisource Community/SaActiveUser

From Meta, a Wikimedia project coordination wiki

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

  1. User talk:Puranastudy sa.wikisource.org 23854
  2. User talk:Surekha Kamath sa.wikisource.org 15561
  3. User talk:Soorya Hebbar sa.wikisource.org 15136
  4. User talk:Shardashah sa.wikisource.org 11658
  5. User talk:Swaminathan sitapathi sa.wikisource.org 8897
  6. User talk:Venkateswaran raman sa.wikisource.org 7753
  7. User talk:Siddharth Kamath A sa.wikisource.org 7539
  8. User talk:Shubha sa.wikisource.org 4391
  9. User talk:Narayanan V T sa.wikisource.org 3108
  10. User talk:Suryanarayana jois sa.wikisource.org 2729
  11. User talk:Sripathy K N sa.wikisource.org 2705
  12. User talk:Kalpana Jayanna sa.wikisource.org 2611
  13. User talk:Wikisource-bot sa.wikisource.org 2401
  14. User talk:Jayashri R sa.wikisource.org 2006
  15. User talk:Ravindranathamenon sa.wikisource.org 1971
  16. User talk:V R Sastry sa.wikisource.org 1792
  17. User talk:Shreevidya sa.wikisource.org 1597
  18. User talk:Asha Gangur sa.wikisource.org 1464
  19. User talk:Shruthi Krishna murthy sa.wikisource.org 1429
  20. User talk:Madhu M Hegde sa.wikisource.org 1381
  21. User talk:Geeta g hegde sa.wikisource.org 1342
  22. User talk:Latha Raghavendra sa.wikisource.org 1330
  23. User talk:Tkkaushikrao sa.wikisource.org 1272
  24. User talk:Akshata1988 sa.wikisource.org 1251
  25. User talk:Ranjanin sa.wikisource.org 1237
  26. User talk:Divya navil sa.wikisource.org 1116
  27. User talk:Manu Harsh sa.wikisource.org 1080
  28. User talk:Tapaskhanra1998 sa.wikisource.org 1073
  29. User talk:शारदा भट्ट sa.wikisource.org 1035
  30. User talk:Shivam padhi sa.wikisource.org 864
  31. User talk:KrishnamurthyAshwini sa.wikisource.org 817
  32. User talk:Vidvat2004 sa.wikisource.org 776
  33. User talk:Dr.Tirumalnhm sa.wikisource.org 690
  34. User talk:Sailu.nittala sa.wikisource.org 640
  35. User talk:PrashantPSJR sa.wikisource.org 619
  36. User talk:Nagamani H R sa.wikisource.org 591
  37. User talk:Pooja Seethur sa.wikisource.org 576
  38. User talk:Sandhya seshadri 67 sa.wikisource.org 573
  39. User talk:Soudamani M C sa.wikisource.org 559
  40. User talk:Sharanya nagesh sa.wikisource.org 525
  41. User talk:Srilakshmi Desai sa.wikisource.org 523
  42. User talk:Dayasagara sa.wikisource.org 505
  43. User talk:Naresh Kumar Dhiman sa.wikisource.org 466
  44. User talk:सौरभ-पोडेलः sa.wikisource.org 460
  45. User talk:Chandashwini K.G sa.wikisource.org 435
  46. User talk:Sandhya Shree B N sa.wikisource.org 424
  47. User talk:Vishvak2004 sa.wikisource.org 410
  48. User talk:Indukwiki sa.wikisource.org 398
  49. User talk:अभिषिक्तस्य शिष्यः sa.wikisource.org 396
  50. User talk:NehalDaveND sa.wikisource.org 350
  51. User talk:Priyanka Umakanth sa.wikisource.org 349
  52. User talk:Ugovindaraju sa.wikisource.org 346
  53. User talk:दीपंकर वर्मनः sa.wikisource.org 344
  54. User talk:Sangeetha H A sa.wikisource.org 327
  55. User talk:Shree sa.wikisource.org 314
  56. User talk:Meena KL sa.wikisource.org 299
  57. User talk:Pranavasagar sa.wikisource.org 277
  58. User talk:Ramdas080854 sa.wikisource.org 268
  59. User talk:Nivedita2015 sa.wikisource.org 262
  60. User talk:Padukere sripathi herle sa.wikisource.org 261
  61. User talk:Seetharaman G.K. sa.wikisource.org 259
  62. User talk:VijayalakshmiR48 sa.wikisource.org 249
  63. User talk:Shyla J.K sa.wikisource.org 228
  64. User talk:Tanuja1111 sa.wikisource.org 219
  65. User talk:EmausBot sa.wikisource.org 217
  66. User talk:Shreedevi Suresh sa.wikisource.org 216
  67. User talk:कन्हाई प्रसाद चौरसिया sa.wikisource.org 212
  68. User talk:Gopika S K sa.wikisource.org 210
  69. User talk:Seemantini Joshi sa.wikisource.org 210
  70. User talk:Vidhusubhasdevadhar sa.wikisource.org 209
  71. User talk:Sandeep vasant joshi sa.wikisource.org 208
  72. User talk:Premaskanth13 sa.wikisource.org 205
  73. User talk:Sandhyayajur sa.wikisource.org 203
  74. User talk:Dr. Shantala Vishwasa sa.wikisource.org 200
  75. User talk:Mahalakshmi Prasanna sa.wikisource.org 200
  76. User talk:Raghavendra Purohit sa.wikisource.org 194
  77. User talk:Brijesh 1810282 sa.wikisource.org 193
  78. User talk:Chetanachetu sa.wikisource.org 189
  79. User talk:Dattatreya vajralli sa.wikisource.org 189
  80. User talk:Vrngud.12 sa.wikisource.org 186
  81. User talk:Raghunaathan.S1810379 sa.wikisource.org 183
  82. User talk:THARUN KAUSHIK U 1810381 sa.wikisource.org 177
  83. User talk:Aditya.G.S. 1810478 sa.wikisource.org 175
  84. User talk:Sayant Mahato sa.wikisource.org 172
  85. User talk:Rakesh Naidu 1810283 sa.wikisource.org 170
  86. User talk:Tushar nayak 1810382 sa.wikisource.org 170
  87. User talk:Kshama B N sa.wikisource.org 169
  88. User talk:Bharati Kolekar sa.wikisource.org 166
  89. User talk:Col Sandeep Sharma sa.wikisource.org 165
  90. User talk:Archana kanitkar sa.wikisource.org 160
  91. User talk:Gaurav natesh 1810177 sa.wikisource.org 151
  92. User talk:अनुनाद सिंह sa.wikisource.org 150
  93. User talk:Prathimarajeshnaik sa.wikisource.org 146
  94. User talk:Usharanimahesh sa.wikisource.org 145
  95. User talk:Parvathavardhini sa.wikisource.org 145
  96. User talk:Harshith N 1810178 sa.wikisource.org 140
  97. User talk:Chandaswini.K.G sa.wikisource.org 139
  98. User talk:Pariksht zodekar sa.wikisource.org 136
  99. User talk:Deepakuniyalwiki sa.wikisource.org 122
  100. User talk:Apurvapwiki sa.wikisource.org 122
  101. User talk:Kpani39 sa.wikisource.org 122
  102. User talk:Deepanarayanan123 sa.wikisource.org 121
  103. User talk:Ashwath Hegde 1810176 sa.wikisource.org 121
  104. User talk:Vishvas vasuki sa.wikisource.org 120
  105. User talk:Sanjanashekhar sa.wikisource.org 120
  106. User talk:Likith.s 1810388 sa.wikisource.org 118
  107. User talk:Ajay kumar mr sa.wikisource.org 117
  108. User talk:Mahathi A H sa.wikisource.org 116
  109. User talk:Rsachi sa.wikisource.org 115
  110. User talk:Lynette natasha sa.wikisource.org 114
  111. User talk:Rojeebanchhorwiki sa.wikisource.org 112
  112. User talk:Nallur Bhanumathi sa.wikisource.org 112
  113. User talk:Sahana19 sa.wikisource.org 104
  114. User talk:Vinayakshabhit sa.wikisource.org 103
  115. User talk:Rashmitarout sa.wikisource.org 100
  116. User talk:Pradyumna tripathi sa.wikisource.org 99
  117. User talk:Shanthi25prasad sa.wikisource.org 94
  118. User talk:Gvijay73 sa.wikisource.org 93
  119. User talk:Veenaddg sa.wikisource.org 92
  120. User talk:Suneethi.nm sa.wikisource.org 92
  121. User talk:Preethinwiki sa.wikisource.org 92
  122. User talk:Andaldesikan sa.wikisource.org 90
  123. User talk:Ashokdangwal sa.wikisource.org 87
  124. User talk:Bhoomikabv sa.wikisource.org 86
  125. User talk:Sujathamn sa.wikisource.org 85
  126. User talk:Snigdha PODDAR sa.wikisource.org 84
  127. User talk:Yashaswinikwiki sa.wikisource.org 84
  128. User talk:Manjunath Ka Ho sa.wikisource.org 82
  129. User talk:Sujatha Mattur sa.wikisource.org 82
  130. User talk:Sanjanags sa.wikisource.org 79
  131. User talk:Wsgsp sa.wikisource.org 79
  132. User talk:Ruthuswiki sa.wikisource.org 78
  133. User talk:Prakashchandrameher sa.wikisource.org 78
  134. User talk:Indirajwiki sa.wikisource.org 77
  135. User talk:Ranjnishreeng sa.wikisource.org 76
  136. User talk:Veena keshav sa.wikisource.org 75
  137. User talk:प्रसन्न अडिगः sa.wikisource.org 75
  138. User talk:Josa123 sa.wikisource.org 75
  139. User talk:Pushpa Javahar sa.wikisource.org 75
  140. User talk:Shridhar V Hegde sa.wikisource.org 75
  141. User talk:Sahananwiki sa.wikisource.org 74
  142. User talk:Sangeetsuna sa.wikisource.org 74
  143. User talk:Madhusmitamishrawiki sa.wikisource.org 74
  144. User talk:S shankara sharma sa.wikisource.org 74
  145. User talk:Adityaasopa sa.wikisource.org 73
  146. User talk:Akanksharahul sa.wikisource.org 72
  147. User talk:1910183Trisha sa.wikisource.org 72
  148. User talk:Sangeetha joshi sa.wikisource.org 72
  149. User talk:HariRavikumar sa.wikisource.org 72
  150. User talk:Nithyashreev sa.wikisource.org 71
  151. User talk:DrJitendraTiwari sa.wikisource.org 71
  152. User talk:Sivakumar.Seetharaman1910179 sa.wikisource.org 71
  153. User talk:Atul.sonwani sa.wikisource.org 70
  154. User talk:Kamalahulagappa sa.wikisource.org 70
  155. User talk:Rakshahjoshi sa.wikisource.org 69
  156. User talk:Priyadarshiniwiki sa.wikisource.org 69
  157. User talk:Nivedhag sa.wikisource.org 69
  158. User talk:Amruthavalliwiki sa.wikisource.org 69
  159. User talk:Rakshithaswiki sa.wikisource.org 69
  160. User talk:Vijayalakshmivwiki sa.wikisource.org 68
  161. User talk:ShridharHegde276 sa.wikisource.org 68
  162. User talk:Nivedhasswiki sa.wikisource.org 68
  163. User talk:Rishikakrao sa.wikisource.org 68
  164. User talk:Chaitanya Lakkundi sa.wikisource.org 67
  165. User talk:Sampadada sa.wikisource.org 66
  166. User talk:Dwitikrushnapanigrahi sa.wikisource.org 66
  167. User talk:Leelavathi S 1960 sa.wikisource.org 66
  168. User talk:Varalakshmiwiki sa.wikisource.org 65
  169. User talk:Rakshithagbhat sa.wikisource.org 65
  170. User talk:Jayprakash12345 sa.wikisource.org 65
  171. User talk:NoychoH sa.wikisource.org 64
  172. User talk:Aruna mydur sa.wikisource.org 64
  173. User talk:Aishwaryaswiki sa.wikisource.org 64
  174. User talk:Sreemathi V. Hegde sa.wikisource.org 63
  175. User talk:Nandithats sa.wikisource.org 63
  176. User talk:Umakantjoshiwiki sa.wikisource.org 62
  177. User talk:Smrithimohan sa.wikisource.org 62
  178. User talk:Srikantanayakwiki sa.wikisource.org 61
  179. User talk:Maneeshasarma sa.wikisource.org 61
  180. User talk:Vinaykumarshuklawiki sa.wikisource.org 61
  181. User talk:Gajanan Bovikan sa.wikisource.org 61
  182. User talk:Ramachandrabhatwiki sa.wikisource.org 60
  183. User talk:Shashank1810380 sa.wikisource.org 60
  184. User talk:Kavanalwiki sa.wikisource.org 58
  185. User talk:PratikR48 sa.wikisource.org 58
  186. User talk:Ganapatijoshi26 sa.wikisource.org 57
  187. User talk:Ankushvhegde sa.wikisource.org 57
  188. User talk:Bhuvaneshwaripg sa.wikisource.org 57
  189. User talk:Advaitasb sa.wikisource.org 56
  190. User talk:Niharikadash sa.wikisource.org 56
  191. User talk:Ranjulapadhan sa.wikisource.org 56
  192. User talk:Swethaswiki sa.wikisource.org 56
  193. User talk:Sarva sastry sa.wikisource.org 55
  194. User talk:PoojaChoudhary618 sa.wikisource.org 55
  195. User talk:Saparyadh sa.wikisource.org 55
  196. User talk:Shankararama sa.wikisource.org 53
  197. User talk:Sibajisahoo sa.wikisource.org 53
  198. User talk:P.Jayashree sa.wikisource.org 52
  199. User talk:Subhashreemoharana sa.wikisource.org 52
  200. User talk:Anish M. Nagpal sa.wikisource.org 52