Untitled query #34963

SQL

use arwiki_p;
select count(rev_id) as "عدد التعديلات باستخدام أوب"
from revision
inner join comment
on comment_id = rev_comment_id
where  comment_text like "%أوب%"
and rev_user_text = "مصعب";

select count(rev_id) as "عدد التعديلات باستخدام إضافة نقل التصانيف"
from revision
inner join comment
on comment_id = rev_comment_id
where  comment_text like "%Cat-a-lot%"
and rev_user_text = "مصعب";

select count(rev_id) as "عدد عمليات الرجوع"
from revision
inner join comment
on comment_id = rev_comment_id
where  comment_text like "%وب:رجوع%"
and rev_user_text = "مصعب";
SQL

Checking query status...
