Untitled query #34087

SQL

SELECT COUNT(DISTINCT(r.rev_page)) as "المستخدمين"
FROM arwiki_p.revision r
WHERE r.rev_timestamp between 20190307000000 and 20190308000000
AND r.rev_user_text not like ucase ("%BOT") collate utf8_general_ci
and r.rev_user != 0
AND r.rev_parent_id = 0;

SELECT COUNT(DISTINCT(r.rev_page)) as "البوتات"
FROM arwiki_p.revision r
WHERE r.rev_timestamp between 20190307000000 and 20190308000000
AND r.rev_user_text like ucase ("%BOT") collate utf8_general_ci
#and r.rev_user != 0
AND r.rev_parent_id = 0;

SELECT COUNT(DISTINCT(r.rev_page)) as "المجهولين"
FROM arwiki_p.revision r
WHERE r.rev_timestamp between 20190307000000 and 20190308000000
and r.rev_user = 0
AND r.rev_parent_id = 0;
SQL

Checking query status...
