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 = "مصعب";

select count(rev_id) as "عدد المقالات المنشأة"
from revision
where
rev_parent_id = 0
and rev_user_text = "مصعب";


select count(page_title) as "مقالات السعودية التي عدلها"
from revision
inner join page
on page_id = rev_page
inner join categorylinks
on cl_from = rev_page
where rev_user_text = "مصعب"
and cl_to = "بوابة_السعودية/مقالات_متعلقة"
and page_namespace = 0
and page_is_redirect = 0;


select count(page_title) as "مقالات الطب التي عدلها"
from revision
inner join page
on page_id = rev_page
inner join categorylinks
on cl_from = rev_page
where rev_user_text = "مصعب"
and cl_to = "بوابة_طب/مقالات_متعلقة"
and page_namespace = 0
and page_is_redirect = 0;
*/
select (cl_to),count(*)
from revision
inner join page
on page_id = rev_page
inner join categorylinks
on cl_from = rev_page
where rev_user_text = "مصعب"
and cl_to = "%/مقالات_متعلقة%"
and page_namespace = 0
and page_is_redirect = 0
group by cl_to
order by count(*)
limit 100;
SQL

Checking query status...
