American villages with paranthesis or comma in their names

Fork of Iranian villages with paranthesis or comma in their names by Huji

This query is marked as a draft This query has been published by Huji.

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 page_is_redirect = 0
) t;

SQL

Checking query status...