DAB pages by length

SQL

use fawiki_p;
select page_title
from page as p
where page_namespace = 0
and page_is_redirect = 0
and not exists (
      select null
      from page_props
      where pp_page = page_id and pp_propname = 'disambiguation'
)
and page_title like "_%\_(%"
and not exists (
    select null
    from page as p2
    where (
        p2.page_title = mid(p.page_title, 1, locate('_(', p.page_title) - 1)
        or p2.page_title = concat(
            mid(p.page_title, 1, locate('_(', p.page_title)),
            '(ابهام‌زدایی)'
        )
    )
    and exists (
          select null
          from page_props
          where pp_page = p2.page_id and pp_propname = 'disambiguation'
    )
)
and exists (
    select null
    from page as p3
    where p3.page_title like concat(
        mid(p.page_title, 1, locate('_(', p.page_title)-1),
        '(%'
    )
    and p3.page_namespace = 0
    and p3.page_is_redirect = 0
    having count(*) > 1
)
order by page_title
LIMIT 50;
SQL

Checking query status...
