Untitled query #36534

SQL

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

Checking query status...
