نقاش المستخدم:Meno25
أضف موضوعًاأحدث تعليق: قبل سنة واحدة من 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 |