SELECT req.*,md.device_name,sc.city_name,mft.facility_type,mft.facility_name,mu.user_name as requested_by_name 
            FROM `edit_purValue_request` as req
            LEFT JOIN master_asset as ma ON(ma.unique_no=req.barcode_no)
            LEFT JOIN master_facility_type as mft ON(ma.city_id=mft.city_id
                                                     AND ma.facility_code=mft.facility_code
                                                     AND ma.facility_id=mft.facility_id)
            LEFT JOIN master_device as md ON(md.device_code=ma.device_code)
            LEFT JOIN setup_city as sc ON(sc.city_id=ma.city_id)
            LEFT JOIN master_user as mu ON(mu.user_id=req.requested_by)
            WHERE 1=1  GROUP BY req.srno ORDER BY req.srno ASC