SELECT 

    page1.page_title

FROM

    page page1,langlinks,page page2

  WHERE

    ll_from = page1.page_id and

    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 = 1 and

    page2.page_namespace=0

  ORDER BY 

  page1.page_title