Jump to content

Indic Wikisource Community/TeActiveUser

From Meta, a Wikimedia project coordination wiki

Script

[edit]

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

USE tewikisource_p;
SELECT
CONCAT("# {{target | user =",actor_name,"| site = te.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

[edit]
  1. User talk:శ్రీరామమూర్తి te.wikisource.org 23761
  2. User talk:Rajasekhar1961 te.wikisource.org 15835
  3. User talk:దేవీప్రసాదశాస్త్రి te.wikisource.org 14962
  4. User talk:Bhaskaranaidu te.wikisource.org 13714
  5. User talk:Nrgullapalli te.wikisource.org 12539
  6. User talk:Arjunaraoc te.wikisource.org 10393
  7. User talk:Ramesam54 te.wikisource.org 7173
  8. User talk:రవిచంద్ర te.wikisource.org 4766
  9. User talk:A.Murali te.wikisource.org 3331
  10. User talk:GGK1960 te.wikisource.org 1110
  11. User talk:Vinod247 te.wikisource.org 999
  12. User talk:Hariwiki23 te.wikisource.org 752
  13. User talk:Pavan santhosh.s te.wikisource.org 630
  14. User talk:Pranayraj1985 te.wikisource.org 578
  15. User talk:B.K.Viswanadh te.wikisource.org 516
  16. User talk:ఇందుశ్రీ ఉషశ్రీ te.wikisource.org 507
  17. User talk:Sudhakarbira te.wikisource.org 476
  18. User talk:Lalitha53 te.wikisource.org 437
  19. User talk:Chaduvari te.wikisource.org 403
  20. User talk:Bhavya ECE te.wikisource.org 390
  21. User talk:Johanmarkraj777 te.wikisource.org 385
  22. User talk:Sushma.Maddipatla te.wikisource.org 273
  23. User talk:Gokulellanki te.wikisource.org 260
  24. User talk:Architha Swetha te.wikisource.org 249
  25. User talk:Saranya lakshmi marreddy te.wikisource.org 245
  26. User talk:Krishnapriya00 te.wikisource.org 238
  27. User talk:Mekala Harika te.wikisource.org 217
  28. User talk:T.sujatha te.wikisource.org 190
  29. User talk:శలాక te.wikisource.org 188
  30. User talk:Nallam.venkata sai pravallika te.wikisource.org 180
  31. User talk:రహ్మానుద్దీన్ te.wikisource.org 180
  32. User talk:Gsvsmurthy te.wikisource.org 177
  33. User talk:Veera.sj te.wikisource.org 149
  34. User talk:Mohana Narahari te.wikisource.org 144
  35. User talk:Eeswaramma Manam te.wikisource.org 116
  36. User talk:అఆ te.wikisource.org 116
  37. User talk:Sri Lekha Pathakamuri te.wikisource.org 112
  38. User talk:INDRAREDDYT te.wikisource.org 105
  39. User talk:Sriram vishnudatta te.wikisource.org 103
  40. User talk:Poojitha manchi te.wikisource.org 94
  41. User talk:Marramai99 te.wikisource.org 92
  42. User talk:Chandra132 te.wikisource.org 87
  43. User talk:Bhavya2207 te.wikisource.org 85
  44. User talk:Mani moraboina te.wikisource.org 83
  45. User talk:Mekala Aruna te.wikisource.org 69
  46. User talk:V Sambasiva Rao te.wikisource.org 63
  47. User talk:Veeraa83 te.wikisource.org 57
  48. User talk:Divyagullapudi te.wikisource.org 54
  49. User talk:RahmanuddinBot te.wikisource.org 53
  50. User talk:MadySneha te.wikisource.org 52
  51. User talk:MSG17 te.wikisource.org 49
  52. User talk:Sureshakella te.wikisource.org 48
  53. User talk:Manaswini2498 te.wikisource.org 39
  54. User talk:Gopuvivek te.wikisource.org 36
  55. User talk:Kattepogu.Anusha te.wikisource.org 35
  56. User talk:Asrija1 te.wikisource.org 34
  57. User talk:Ajaybanbi te.wikisource.org 30
  58. User talk:Udayasri13 te.wikisource.org 24
  59. User talk:Kasyap te.wikisource.org 20
  60. User talk:Ganta.Keerthi te.wikisource.org 18
  61. User talk:Aditya4710 te.wikisource.org 18
  62. User talk:Jahnavi morla te.wikisource.org 18
  63. User talk:Saikumartk te.wikisource.org 17
  64. User talk:Ananth subray te.wikisource.org 17
  65. User talk:Y V S N Murthy te.wikisource.org 17
  66. User talk:Paruchuri Bhanu Chandra Sekhar guptha te.wikisource.org 17
  67. User talk:Gshguru te.wikisource.org 16
  68. User talk:Sudarsanande te.wikisource.org 15
  69. User talk:Hnaluru te.wikisource.org 13
  70. User talk:Dr Josyabhatla Rajasekhara Sarma te.wikisource.org 13
  71. User talk:Benipal hardarshan te.wikisource.org 12
  72. User talk:Padmavathi51 te.wikisource.org 11
  73. User talk:EmausBot te.wikisource.org 11
  74. User talk:K.Venkataramana te.wikisource.org 11
  75. User talk:Mahalakshmiande te.wikisource.org 10
  76. User talk:Avadhanam viswanatha sarma te.wikisource.org 10
  77. User talk:యుఆర్ కె te.wikisource.org 10
  78. User talk:హరిపాదశ్రీనివాసులు te.wikisource.org 9
  79. User talk:Pavan (CIS-A2K) te.wikisource.org 9
  80. User talk:Lellasrinu te.wikisource.org 8
  81. User talk:యిఆర్ కె te.wikisource.org 7
  82. User talk:Bhavani63 te.wikisource.org 7
  83. User talk:Prasadgosala te.wikisource.org 6
  84. User talk:Hrishikes te.wikisource.org 6
  85. User talk:CommonsDelinker te.wikisource.org 6
  86. User talk:బొల్లారెడ్డి శ్రీధర్ రెడ్డి te.wikisource.org 5
  87. User talk:Subhanih te.wikisource.org 5
  88. User talk:Madhupatra sailaja uppaluri te.wikisource.org 4
  89. User talk:Sastryiv te.wikisource.org 4
  90. User talk:శ్రీహర్ష te.wikisource.org 4
  91. User talk:Lalithsistla te.wikisource.org 4
  92. User talk:Vjsuseela te.wikisource.org 3
  93. User talk:Brahmakteja te.wikisource.org 3
  94. User talk:వేంకటేశ్వర te.wikisource.org 3
  95. User talk:Naga sai sravanth te.wikisource.org 3
  96. User talk:వంగలపూడి శివకృష్ణ te.wikisource.org 3
  97. User talk:Ashok Kumar Komuravelli te.wikisource.org 3
  98. User talk:Karthikeya kanala te.wikisource.org 3