Indic Wikisource Community/GuActiveUser

Script

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

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