Jump to content

Indic Wikisource Community/GuActiveUser

From Meta, a Wikimedia project coordination wiki

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