most linked redirects (space to non-space)

SQL

use fawiki_p;
select distinct concat('# [[', page_title, ']]')
from page
left join langlinks on page_id = ll_from
right join categorylinks on page_id = cl_from
where page_namespace = 0
and page_is_redirect = 0
/* The selected page has an unhidden dab category. */
and cl_to like '%ابهام%'
and exists (
  select null from page as catpage
  where catpage.page_title = cl_to
  and catpage.page_namespace = 14
  and not exists (
    select null
    from page_props as catprops
    where catprops.pp_page = catpage.page_id
    and catprops.pp_propname = 'hiddencat'
  )
)
and not exists ( /* The selected page is not a dab page. */
  select null from page_props
  where pp_page = page_id
  and pp_propname = 'disambiguation'
);
SQL

Checking query status...
