Untitled query #36534

SQL

use arwiki_p;
SELECT rev_user_text, page_title #COUNT(*) as arc
FROM categorylinks as cc , revision  as 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
#ORDER BY COUNT(*) > 20 DESC
Limit 500
SQL

Checking query status...
