Meno25
اشترك منذ 14 نوفمبر 2006
أحدث تعليق: قبل سنة واحدة من Meno25 في الموضوع طلب قائمة إنشاء المقالات
طلب قائمة إنشاء المقالات
عدلالسلام عليكم، هل من الممكن أن تعرض إحصائيات انشاءات المستخدم؟ حمدى10 (نقاش) 10:05، 1 مارس 2023 (ت ع م)
- وعليكم السلام و رحمة الله و بركاته @حمدى10؛ الاستعلام التالي يعرض المستخدمين حسب عدد إنشاء الصفحات في النطاق الرئيسي (بدون التحويلات و مع تجاهل حسابات البوتات)
SELECT actor_name, COUNT(*) as articles_created
FROM revision r
INNER JOIN actor ON r.rev_actor = actor.actor_id
INNER JOIN page p on r.rev_page = p.page_id
WHERE p.page_namespace = 0
and p.page_is_redirect = 0
and r.rev_parent_id = 0
and ucase(actor_name) not like ucase("%BOT")
and actor_name not like "%بوت%"
and actor_name Not IN (SELECT user_name
FROM user_groups
INNER JOIN user ON user_id = ug_user
WHERE ug_group = "bot")
GROUP BY actor_name
having COUNT(*) > 1
ORDER BY COUNT(*) DESC
LIMIT 500;
وهذا هو ناتج الاستعلام
actor_name | articles_created |
---|---|
Interwicket | 10220 |
TheCheatBot | 9513 |
Zina1 | 7784 |
Yoki Yoki | 7778 |
ExampleBot | 5035 |
Mahaodeh | 3010 |
BD2412 | 1362 |
RJFJR | 1285 |
Lord Anubis | 1231 |
MK~arwiktionary | 1142 |
PlayPus2 | 836 |
DCDuring | 773 |
Connel MacKenzie | 658 |
Connel MacKenzieBot | 653 |
Williamsayers79 | 612 |
AutoFormat | 609 |
Mutante | 516 |
Sewnmouthsecret | 514 |
أسامة عبدالمولى | 486 |
Sa'y | 454 |
Jyril | 451 |
UllmannBot | 432 |
SemperBlotto | 383 |
Ikotobaity | 325 |
EncycloPetey | 316 |
حَوْلَ | 297 |
Doug Hockin | 297 |
روخو | 264 |
ونو | 211 |
Uwe a | 206 |
92.192.76.68 | 193 |
Visviva | 189 |
بن طلحة احمد | 173 |
الناجم العاجم | 171 |
ولد ببال | 166 |
Nehaoua | 144 |
زكريا | 141 |
Doremítzwr | 134 |
Zu | 117 |
KoveytBud | 112 |
Woodendog | 103 |
Ikhlas Qassmi 13336 | 102 |
عبد الله المالكه | 96 |
OsamaK | 94 |
Waseem7 | 93 |
Panda10 | 92 |
Hassan ahachi | 91 |
Goldenrowley | 90 |
Tim Q. Wells | 88 |
Thryduulf | 87 |
فاطمة الزهراء | 86 |
HappyMidnight | 85 |
Ivan Štambuk | 85 |
Mthk | 83 |
نصر الله غانم | 81 |
Mohammed77779 | 80 |
Karloss45 | 76 |
Keene | 76 |
Захаровсергеевич | 74 |
Nadando | 73 |
Teh Rote | 73 |
Ciphers | 71 |
Trivialist | 62 |
Emascandam | 61 |
41.233.172.113 | 58 |
W0 | 54 |
Ruakh | 53 |
Abdulwhab al-mohimeed | 53 |
41.200.229.192 | 50 |
Msh210 | 49 |
إسلام | 49 |
TheDaveRoss | 46 |
Abdul Hamid OpL | 46 |
Bfiras | 44 |
Jeffqyzt | 43 |
لعظم | 42 |
Opiaterein | 41 |
Lexicografer | 41 |
حزم الظامي~arwiktionary | 41 |
81.56.69.59 | 40 |
Rodasmith | 38 |
ولاء | 38 |
Moomkenb3 | 38 |
WikiPedant | 37 |
192.0.215.44 | 37 |
Emara | 37 |
Ahmed Nader | 36 |
41.200.234.5 | 36 |
Karim185.3 | 35 |
Krun | 35 |
Sae1962 | 34 |
Frous | 33 |
Omar2040 | 33 |
Amanda jigs | 32 |
Kwamikagami | 31 |
Abu aamir | 30 |
7eway | 30 |
McBot | 29 |
84.131.231.103 | 29 |
Discjjockey | 28 |
Agari | 27 |
Sarvaturi~arwiktionary | 27 |
206.75.198.6 | 26 |
مساعد~arwiktionary | 26 |
Tasalameh | 25 |
41.233.162.4 | 25 |
Molokabo | 25 |
ВМНС | 24 |
Omda4wady | 24 |
82.213.33.63 | 23 |
Kappa | 23 |
41.233.174.50 | 22 |
Romeo~arwiktionary | 22 |
Menasim | 22 |
Stan Shebs | 21 |
Moomkenb1 | 21 |
Aziza Meriem | 21 |
Andalos | 21 |
Circeus | 21 |
مخنف | 20 |
حمدى10 | 20 |
أبو هشام | 20 |
Tbot | 20 |
Widsith | 20 |
هادي السيد | 20 |
Kzollman | 20 |
TheDaveBot | 19 |
Atelaes | 19 |
عباد ديرانية | 19 |
Barmar | 19 |
عبد الله | 19 |
imported>Angr | 19 |
Meco | 19 |
195.56.225.57 | 18 |
Jaaari | 18 |
96.229.184.69 | 18 |
DerbethBot | 18 |
197.131.222.198 | 18 |
16@r | 17 |
Rhanyeia | 17 |
Octahedron80 | 17 |
Świętokrzyskie3 | 16 |
Robert Ullmann | 16 |
Ritaj Ibrahim | 16 |
41.233.173.69 | 16 |
Nawwas | 16 |
Slacker~arwiktionary | 16 |
Hishamu | 16 |
Medellia | 16 |
Zack wadghiri | 15 |
41.233.173.182 | 15 |
Aya Reyad | 15 |
Moomkenb2 | 15 |
SPQRobin | 15 |
192.116.17.51 | 15 |
Stephen G. Brown | 15 |
أحمد ناجي | 14 |
ابن أحمد | 14 |
Versageek | 14 |
Harris Morgan | 14 |
ساسوكي أوتشيها | 14 |
محمد مصطفى | 14 |
Conrad.Irwin | 14 |
Atcovi | 14 |
213.244.124.19 | 13 |
Dvortybot | 13 |
Algrif | 13 |
Amirzaoula81 | 13 |
Avicenno | 13 |
213.6.16.105 | 13 |
192.118.11.112 | 13 |
140.247.46.87 | 12 |
Eltoum | 12 |
CloudNine | 12 |
Cynewulf | 12 |
Bequw | 12 |
86.51.51.178 | 12 |
217.132.223.143 | 12 |
Manar Kurdia | 12 |
71.229.110.71 | 12 |
Engy Rashdan | 12 |
666rayan | 11 |
Yokohama~arwiktionary | 11 |
Wafaashohdy | 11 |
Mike Dillon | 11 |
Menna kamal Ahmed | 11 |
Mohammad Kamal Shady | 11 |
علاء | 11 |
64.50.84.194 | 11 |
67.39.206.25 | 11 |
Dina Wael98 | 10 |
Naderyousry | 10 |
Mariam Wahba | 10 |
دينا علي مصطفي | 10 |
Sammarashraf | 10 |
Maie Ahmed Samir | 10 |
MariamDiaa14 | 10 |
مريم سعيد 777 | 10 |
Shams Abdulaziz | 10 |
Makearney | 10 |
Mr. Ibrahem | 10 |
77.126.30.189 | 10 |
Rania Saed | 10 |
86.143.196.184 | 10 |
IsraakhaledG | 10 |
حسن | 10 |
197.129.232.213 | 10 |
MariamHassan98 | 10 |
YomnaAkmal | 10 |
ONH~arwiktionary | 10 |
YomnaAlAdawy | 10 |
Lydia Eskander | 10 |
Kholoud elFeky | 10 |
Fady james | 10 |
Enjie Abdel-khaleq | 10 |
Aiman titi | 10 |
سارة إسلام | 10 |
Haidyyousry | 10 |
Nirvana Gamal | 10 |
Mirna Aboouf | 10 |
أمنية خالدمجمد العادل | 10 |
Ibrahim.ID | 10 |
Carsrac | 10 |
Menna Ashraff | 10 |
مريام وليم | 10 |
Roba Ehab | 10 |
Walaa Othman | 10 |
Nadine mohamed swilm | 10 |
Conversion script | 10 |
Aya El Nozahy | 10 |
Lama Shams | 10 |
Noura Zamzam | 10 |
ياسمين هاني | 10 |
لانا ايهاب | 10 |
Salma Mohamed Salah | 10 |
Moh.Akram154 | 10 |
Yasmin hesham salah | 10 |
Roba Khedr | 10 |
روان سعيدد | 9 |
فادي كامل | 9 |
213.42.2.27 | 9 |
Amal Muhana | 9 |
Passantsami | 9 |
هبة الله مصطفى البشير | 9 |
ZeinobiousG | 9 |
MariiamSalahh | 9 |
أمينة أحمد | 9 |
210.106.22.59 | 9 |
Miretteayman | 9 |
Ice-t | 9 |
Monak | 9 |
محمد أحمد عبد الفتاح | 9 |
Israa mohamed zakaria | 9 |
83.244.78.76 | 9 |
Aya Houssen Saad | 9 |
213.6.19.83 | 9 |
Mai mohamed galal | 9 |
Natox | 9 |
Youmna Nabil | 9 |
Habiba Fouad | 9 |
Sara Aboelezz | 9 |
Hagar Ibrahim7 | 9 |
Omar Darwish 1914 | 9 |
مها ممدوح | 9 |
Rawan El Hefny | 9 |
83.244.77.192 | 9 |
Nada Abdelmoneam | 9 |
Shrouq Ameen | 9 |
ماريا الفريد | 8 |
Maria Sefeen | 8 |
Rana Al Kalamawy | 8 |
خادم العربية | 8 |
ورقة | 8 |
هانيا أيمن محمود محمد بدر | 8 |
61.102.33.213 | 8 |
Gehad Amin | 8 |
محمدبن عمر المختار | 8 |
Nada El-Ansary | 8 |
M.amr21 | 8 |
Menna Ousam | 8 |
83.244.79.183 | 8 |
94.98.7.65 | 8 |
Ahmed H. Sayyed | 8 |
Nadine.fouda | 8 |
Mostafa Khalid Imam | 8 |
Alaa Faramawy | 8 |
82.213.33.82 | 7 |
86.148.150.40 | 7 |
Yasser Atef Muhammad | 7 |
176.45.202.140 | 7 |
212.117.142.227 | 7 |
87.101.145.77 | 7 |
70.171.204.251 | 7 |
Amira Refaee | 7 |
Thisis0 | 7 |
82.148.97.69 | 7 |
Ola Habiba | 7 |
105.202.85.36 | 7 |
Azzoug lyes | 7 |
Match-m-f~arwiktionary | 7 |
Psychless | 7 |
سلمى المدغري | 7 |
Mohammedjibril | 7 |
Nordin far | 7 |
5.108.79.158 | 7 |
208.69.41.186 | 7 |
Hekaheka | 7 |
Beobach972 | 7 |
Hippietrail | 7 |
KiwiFarmsfun | 7 |
Jonathan Webley | 7 |
imported>Daniel Polansky | 7 |
Mohamed MF007 | 6 |
Hamaryns | 6 |
محمد بوعلام عصامي | 6 |
2Amar0 | 6 |
AFlorence | 6 |
A user-bot | 6 |
X911 | 6 |
71.184.115.99 | 6 |
105.156.144.169 | 6 |
Grendelkhan | 6 |
Cst~arwiktionary | 6 |
Piolinfax | 6 |
Chaos | 6 |
رضا باقری چاهورزی | 6 |
105.73.25.75 | 6 |
MarinaHamdy7 | 6 |
Soufian.hd | 6 |
67.72.98.26 | 6 |
Salam32 | 6 |
M I Idrees | 6 |
196.12.244.143 | 5 |
Asaifm | 5 |
Ajwaan | 5 |
Roggy | 5 |
AhmedBenlakhdhar | 5 |
Keene2 | 5 |
Falcon747 | 5 |
MasharyReema | 5 |
134.95.251.202 | 5 |
علي | 5 |
BiT | 5 |
Kahhar87~arwiktionary | 5 |
216.183.93.162 | 5 |
Maryem Azioual | 5 |
Aboodi Aliraqi | 5 |
مصطفى أوخديل | 5 |
PierreAbbat | 5 |
89.150.202.174 | 5 |
شادي | 5 |
Menna Alshorbagy | 5 |
GerardM | 5 |
2A00:5400:E266:4B2F:1C39:63BA:9D3D:B53E | 5 |
105.150.71.56 | 5 |
213.244.124.16 | 5 |
Alifshinobi | 5 |
Meno25 | 5 |
213.6.11.38 | 5 |
Rrffddcc | 5 |
أحمد الياباني | 5 |
Anthurium | 5 |
Tofeiku | 5 |
Globish | 5 |
105.66.132.42 | 5 |
158.146.64.2 | 5 |
83.244.78.81 | 5 |
109.224.13.74 | 5 |
Pathoschild | 5 |
Dubaduba~arwiktionary | 5 |
Madhero88 | 5 |
Phatom87 | 4 |
212.150.193.187 | 4 |
Jeffamaname | 4 |
84.131.221.9 | 4 |
213.244.124.18 | 4 |
Dictionarybuilder | 4 |
Flying Saucer | 4 |
195.56.224.213 | 4 |
41.233.174.148 | 4 |
80.184.28.24 | 4 |
Mmmmm mmmmm6299 | 4 |
217.29.209.13 | 4 |
213.6.10.93 | 4 |
Mabuodah | 4 |
105.73.25.144 | 4 |
41.221.17.46 | 4 |
Tarawneh | 4 |
196.202.71.71 | 4 |
81.151.103.194 | 4 |
41.200.232.120 | 4 |
213.6.15.250 | 4 |
72.93.95.26 | 4 |
82.102.205.154 | 4 |
على المزارقه | 4 |
195.229.242.54 | 4 |
Neskaya | 4 |
Mzajac | 4 |
محمد بن تركي الفيصل | 4 |
163.121.56.6 | 4 |
70.55.84.13 | 4 |
Medo292009 | 4 |
احمد اولحاج | 4 |
41.221.17.1 | 4 |
咽頭べさ | 4 |
212.138.48.245 | 4 |
Tygrrr | 4 |
زهرة | 4 |
38.119.107.73 | 4 |
196.218.4.246 | 4 |
86.108.108.6 | 4 |
188.247.79.73 | 4 |
197.129.157.133 | 4 |
105.71.3.168 | 4 |
201.30.91.2 | 4 |
ابوحاتم | 4 |
197.129.17.75 | 4 |
31.49.132.193 | 4 |
68.76.117.69 | 4 |
عربستاني | 4 |
Mxn | 4 |
Lettre87 | 4 |
85.226.76.111 | 4 |
90.1.252.232 | 4 |
WisiW | 3 |
Daniel. | 3 |
41.233.209.98 | 3 |
Zeitlupe | 3 |
41.196.222.166 | 3 |
86.96.228.89 | 3 |
ديفيد عادل وهبة خليل 2 | 3 |
85.64.70.22 | 3 |
85.154.153.237 | 3 |
Tohru | 3 |
Oleg Katsitadze | 3 |
Makaokalani | 3 |
Beru7 | 3 |
41.221.17.145 | 3 |
86.96.226.89 | 3 |
77.30.239.106 | 3 |
كهيرب | 3 |
82.233.229.34 | 3 |
41.238.185.183 | 3 |
195.229.236.214 | 3 |
82.102.204.60 | 3 |
154.151.171.227 | 3 |
Pamputt | 3 |
Hakamadare | 3 |
196.86.71.25 | 3 |
AugPi | 3 |
Fo0odan | 3 |
Dr.Sameh Youssef | 3 |
Atropos | 3 |
217.23.47.128 | 3 |
Imksa~arwiktionary | 3 |
83.244.80.68 | 3 |
85.250.91.231 | 3 |
Mkhabbaz | 3 |
117.89.47.236 | 3 |
Omlil | 3 |
Kenyon | 3 |
J Milburn | 3 |
Pumpie | 3 |
212.138.47.17 | 3 |
Yasser Youssef | 3 |
Ahmed712 | 3 |
Doddebot | 3 |
Zigzig20s | 3 |
باسم | 3 |
212.138.48.246 | 3 |
T. Mazzei | 3 |
SOLAIMAN ANIR | 3 |
2605:6000:EEC0:6500:10C4:B2A6:130A:A289 | 3 |
71.174.54.247 | 3 |
Pious7 | 3 |
المصطفى كحلاوي | 3 |
83.244.79.101 | 3 |
German arabic teaching sami | 3 |
منصورالواقدي | 3 |
DAVilla | 3 |
84.114.171.115 | 3 |
محمد مصطفى عودة | 3 |
Baraa ahmad | 3 |
88.154.190.26 | 3 |
196.83.142.93 | 3 |
Haytham Morsy | 3 |
197.131.121.90 | 3 |
Ptcamn | 3 |
212.138.47.29 | 3 |
Venere | 3 |
134.169.78.2 | 3 |
197.131.216.56 | 3 |
مصعوب | 3 |
105.128.8.138 | 3 |
Dvortygirl | 3 |
Dmcdevit | 3 |
46.185.175.17 | 3 |
OpL 666 | 3 |
الدومي~arwiktionary | 3 |
217.255.222.41 | 3 |