American villages with paranthesis or comma in their names

SQL

use fawiki_p;
select count(*), 100 * sum(para) / count(*), 100 * sum(comma) / count(*)
from
(
  select
    p1.page_title,
    case when locate('(', p1.page_title) > 0 then 1 else 0 end as para,
    case when locate('،', p1.page_title) > 0 then 1 else 0 end as comma
  from categorylinks c1
  join page p1
    on c1.cl_from = p1.page_id
  join page p2
    on c1.cl_to = p2.page_title
    and p2.page_namespace = 14
  join categorylinks c2
    on p2.page_id = c2.cl_from
    and c2.cl_to = 'روستاها_در_ایالات_متحده_آمریکا_بر_پایه_ایالت'
  where p1.page_is_redirect = 0
) t;

select
  p1.page_title
from categorylinks c1
join page p1
  on c1.cl_from = p1.page_id
join page p2
  on c1.cl_to = p2.page_title
  and p2.page_namespace = 14
join categorylinks c2
  on p2.page_id = c2.cl_from
  and c2.cl_to = 'روستاها_در_ایالات_متحده_آمریکا_بر_پایه_ایالت'
where
  p1.page_is_redirect = 0
  and locate('(', p1.page_title) > 0
SQL

Checking query status...
