eHealth PHS

C-DAC requested a data level checking from UAT1 database for identifying this issue. The query to execute in UAT1 Database follows:
SELECT u.user_id AS id,u.employee_name AS employee_name,u.rank_name AS designation,ab.ashablock_id,
ab.ashablock_name,
ab.ward_id,wm.hospital_id,wm.basic_section_id,mh1.hospital_name AS hospital_name,mh1.hospital_type_id as hospital_type_id,mh2.hospital_name AS basic_section_name,mh2.hospital_type_id as basic_section_id,
ab.no_of_houses,
ab.no_of_members,mw.ward_name,mw.ward_code FROM users u, ph_ashablock_assign aba ph_ashablocks ab, ph_ward_mapping wm mas_hospital mh1, mas_hospital mh2, mas_ward mw where u.user_id=aba.user_id and aba.ashablock_id=ab.ashablock_id and ab.ward_id=wm.ward_id AND mh1.hospital_id=wm.hospital_id AND mh2.hospital_id=wm.basic_section_id AND mw.ward_id=ab.ward_id AND ab.ashablock_id IN(SELECT aba.ashablock_id FROM ph_ashablock_assign aba where
user_id IN)