Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Mr. Ibrahem
.
Toggle Highlighting
SQL
use arwiki_p; SELECT actor_name, count(actor_name) FROM revision INNER JOIN page ON rev_page = page_id LEFT JOIN actor ON rev_actor = actor_id WHERE page_namespace = 0 AND rev_parent_id = 0 and rev_timestamp between 20200101000000 and 20200401000000 AND page.page_is_redirect = 0 #and page_len > 4990 AND page.page_title in (select page_title from categorylinks , page p2 where cl_to = "مقالات_أنشئت_ضمن_مسابقة_ويكيبيديا_السعودية" and p2.page_id = cl_from) and actor_name in ( "Dr-Taher","يوسف أحمد عادل","فضل إسماعيل","Mohamed.sherif","mohtrev","Mr. Ibrahem","Amr F.Nagy","مينا جمال صبحي","بداح فهد","بنت المستكفي","حسن مهله حسن","Mohamed Belgazem","عبد المغيث","فيصل","Arfaoui Azhar","NEHAOUA","Mustafa Al-Elq","Mustafa","Memelord0","هيثم الصعب","Ruwaym","SADIQUI","البوعناني حاتم","عمر خالد 8888","دنيا","رشا المثيب","محمود صوفان","MohammadHuzam","أمين","همام","Slayym","YmTheSuper","Yaakoub45","Farhadmirza","Faris knight","حاتم العتيبي","Mark Taljbini","ذويزن عبدالله","زياد العربي","Esalm salem","Hamzamathiw","Mohammad al-haddad","Ibrahim Old","Aseel zm","Fatma elzahraa2","Mustafaalacadory97","سمير محمد الليثى","tala_sarabtah","Bilal Hoor","ندى","Salma Salman","HayelKh 2030","Alialbhlol","Ahmad.aea.99","Emad Alassi","Jilet jaun","Ali AEGYpTUS","Sakiv","fahadfta","Nada kareem22","azooz4","عبدالرحمان مسعودي الذئب","Narmeen abul felat","Osamaahaggag","Hiroshi Ayaz","طلال ناصر","علاء فحصي","Manhal Hakr","إسلام","Rashad01tarik","Fouad Fares","AhmadElq","عرين أسد أبو رمان","Yacine dzz","Dr.AlObaili","Ziad Alyousif","آية ابراهيم ","هيثم بلغزال","3limohd1","بندر الشهري ","hamidanos","Muhammad Abul-Futooh","محمد معيض","AQRD","محـمد جـمال","Qrmoo3","آية المرشدي","Aiman titi","obaida mahmoud","alesemi","زياد0","anas.67.1989","Reemnaif1413","رأفت الداجن","FCBlinder" ) group by actor_name ;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...