Untitled query #36534

SQL

use arwiki_p;
SELECT rev_user_text, COUNT(*) as arc
FROM categorylinks cc , revision r
join page p on p.page_id=r.rev_page
WHERE p.page_namespace=0 and p.page_is_redirect=0 and r.rev_timestamp between 20190420000000 and 20190701000000
and r.rev_parent_id=0 and r.rev_user != 0 AND r.rev_user_text not like ucase ("%BOT") collate utf8_general_ci
#and r.rev_user_text = "Mr. Ibrahem"
and cc.cl_from = p.page_id
and cc.cl_to = "بوابة_لبنان/مقالات_متعلقة"
GROUP BY r.rev_user_text
ORDER BY COUNT(*) DESC
Limit 500
SQL

Checking query status...
