Indic Wikisource Community/GuActiveUser

Script

edit

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

USE guwikisource_p;
SELECT
CONCAT("# {{target | user =",actor_name,"| site = gu.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)
  AND rev_timestamp BETWEEN 20180101000000 AND 20210630235959
GROUP BY actor_id
ORDER BY recent_user_editcount DESC
LIMIT 200;


Active User July 2021

edit
  1. User talk:Sushant savla   gu.wikisource.org 28400
  1. User talk:Vijay Barot   gu.wikisource.org 12249
  2. User talk:Amvaishnav   gu.wikisource.org 9843
  3. User talk:Modern Bhatt   gu.wikisource.org 2763
  4. User talk:Gazal world   gu.wikisource.org 1876
  5. User talk:Kjthaker   gu.wikisource.org 1793
  6. User talk:VikramVajir   gu.wikisource.org 525
  7. User talk:Kalpgna   gu.wikisource.org 482
  8. User talk:Kokilagada1   gu.wikisource.org 367
  9. User talk:92saeedshaikh   gu.wikisource.org 335
  10. User talk:Jayesh.gohel   gu.wikisource.org 256
  11. User talk:મીરા પરમાર   gu.wikisource.org 213
  12. User talk:Drdeepakbhatt   gu.wikisource.org 192
  13. User talk:Kokilagada   gu.wikisource.org 166
  14. User talk:Nizil Shah   gu.wikisource.org 160
  15. User talk:Vyom25   gu.wikisource.org 149
  16. User talk:Alpesh Mardiya   gu.wikisource.org 95
  17. User talk:Sushant savla2   gu.wikisource.org 79
  18. User talk:Jhala shivrajsinh   gu.wikisource.org 78
  19. User talk:Brihaspati   gu.wikisource.org 64
  20. User talk:Prashbjp22   gu.wikisource.org 60
  21. User talk:સતિષચંદ્ર   gu.wikisource.org 46
  22. User talk:Parikshit GSP   gu.wikisource.org 36
  23. User talk:Adv. Prakashkumar Korat   gu.wikisource.org 27
  24. User talk:Hrishikes   gu.wikisource.org 26
  25. User talk:Ravijoshi   gu.wikisource.org 21
  26. User talk:अमिताभ साव   gu.wikisource.org 19
  27. User talk:Shruti.shah   gu.wikisource.org 18
  28. User talk:Maitri Shah1   gu.wikisource.org 17
  29. User talk:Vijaysinh Motbha   gu.wikisource.org 13
  30. User talk:Kundakundakunda   gu.wikisource.org 12
  31. User talk:Drutpal   gu.wikisource.org 10
  32. User talk:DerekWinters   gu.wikisource.org 8
  33. User talk:Dsvyas   gu.wikisource.org 6
  34. User talk:Khandeka satish kumar valji bhai   gu.wikisource.org 6
  35. User talk:Rajal shukle   gu.wikisource.org 6
  36. User talk:TARUN KORAT   gu.wikisource.org 6
  37. User talk:Benipal hardarshan   gu.wikisource.org 5
  38. User talk:Neha Dedhia   gu.wikisource.org 4
  39. User talk:Captain jack2110   gu.wikisource.org 4
  40. User talk:Aniket   gu.wikisource.org 4
  41. User talk:Kaushal Barad   gu.wikisource.org 3
  42. User talk:कन्हाई प्रसाद चौरसिया   gu.wikisource.org 3
  43. User talk:Priyanshup555   gu.wikisource.org 2
  44. User talk:ખુશાલ કોલડિયા   gu.wikisource.org 2
  45. User talk:Bodhisattwa   gu.wikisource.org 2
  46. User talk:Tulsi Bhagat   gu.wikisource.org 2
  47. User talk:Baldevsinh zala   gu.wikisource.org 1
  48. User talk:आर्यावर्त   gu.wikisource.org 1
  49. User talk:Pspathak26   gu.wikisource.org 1
  50. User talk:Nikhil Goswami   gu.wikisource.org 1
  51. User talk:Mandaliya sahil   gu.wikisource.org 1
  52. User talk:Dhshpatel   gu.wikisource.org 1
  53. User talk:Haisebhai   gu.wikisource.org 1
  54. User talk:Dodiya Digvijaysinh   gu.wikisource.org 1
  55. User talk:Gurtej Chauhan   gu.wikisource.org 1
  56. User talk:KartikMistry   gu.wikisource.org 1
  57. User talk:Navigator123w   gu.wikisource.org 1
  58. User talk:શૈલેષભાઈ   gu.wikisource.org 1
  59. User talk:Sohom data   gu.wikisource.org 1
  60. User talk:Tejashkumar Patel   gu.wikisource.org 1
  61. User talk:Maheshdan Gadhvi   gu.wikisource.org 1
  62. User talk:Sharad Mehta   gu.wikisource.org 1