Iranian villages with paranthesis or comma in their names

SQL

use fawiki_p;
select count(*), 100 * sum(para) / count(*), 100 * sum(comma) / count(*)
from
(
  select
    page_title,
    case when locate('(', page_title) > 0 then 1 else 0 end as para,
    case when locate('،', page_title) > 0 then 1 else 0 end as comma
  from categorylinks
  join page
    on cl_from = page_id
    and cl_to = 'مقاله‌های_روستاهای_ایران'
  where page_is_redirect = 0
) t;

select
  page_title
from categorylinks
join page
  on cl_from = page_id
  and cl_to = 'مقاله‌های_روستاهای_ایران'
where
  page_is_redirect = 0
  and locate('،', page_title) > 0;

SQL

Checking query status...