SELECT 

    page1.page_title

FROM

    page page1,page page2

  WHERE

    page2.page_title=page1.page_title and

    page1.page_id not in (select ll_from from langlinks where ll_lang = 'en') and

    page2.page_id in (select cl_from from categorylinks where cl_to ="ఆజాదీ_కా_అమృత్•_మహోత్సవం_ప్రాజెక్టులో_సృష్టించిన_పేజీలు") and

    page1.page_namespace = 0 and

    page2.page_namespace=1

  ORDER BY 

  page1.page_title