Sorting glitch finder

SQL

use rowiki_p;
SELECT pid, title, h.pp_page
FROM (
  SELECT f.cl_from AS pid, f.cl_to AS cl_to, g.page_title AS title
  FROM categorylinks AS f
  INNER JOIN (
    SELECT page_id, page_title FROM page
    WHERE ((page_title LIKE '%Â%') OR (page_title LIKE '%â%') OR (page_title LIKE '%Î%') OR (page_title LIKE '%î%'))
    AND (page_title NOT LIKE '%ândia%')
  ) AS g ON f.cl_from=g.page_id
) AS i
INNER JOIN (
  SELECT pp_page, pp_value
  FROM page_props
  WHERE pp_propname="defaultsort"
) AS h ON i.pid=h.pp_page
WHERE i.cl_to='Cioturi_Localități_în_Maranhão'
SQL

Checking query status...
