Note: Click on numbers to get list of paper(s). You can Download the paper(s) select slno, paper_desc, ifnull(cnt,0) paper_count from research_papers_master
left join
(select c.code, count(*) cnt from cand_semesters a, research_papers b, research_papers_master c, registrations d, states_ut_dists e
where a.cid= d.regid and a.paper_code = b.code and b.code = d.research_paper_type and b.mastcode = c.code
and d.district = e.district_name and
a.status = 'EV' and a.score >= 60 and date_format(status_date, '%Y-%m-%d') between '2025-01-01' and '2025-12-31' and d.district = e.district_name
and district = 'andhrapradesh_palnadu'
group by c.code) paper_counts
on (research_papers_master.code = paper_counts.code)
District Location
