USE fawiki_p;

SELECT page_title, ll_title 

FROM langlinks

INNER JOIN page ON ll_from = page_id

INNER JOIN categorylinks WHERE

    cl_from = page_id

    AND (cl_to like '%روستاهای%' or cl_to like '%مناطق مسکونی%')

   and  page_namespace = 0

    AND page_is_redirect = 0

    And ll_lang="en"

    and page_title LIKE "%)%" and not ll_title like "%,%"

GROUP BY ll_from

ORDER BY count(*) DESC,

    page_title;