Untitled query #42652

SQL

use arwiki_p;
SELECT actor_name, count(page.page_title)
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 p2.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
;
SQL

Checking query status...
