Columbia Asia Hospital – Palam Vihar, Gurgaon, is a 90 bed multi specialty facility situated in an upscale locality of the National Capital Region. The hospital began its services in July 2008 and has already become a preferred healthcare service provider for the residents and corporate entities of Gurgaon. The hospital offers a wide range of clinical services such as Obstetrics & Gynecology, Internal Medicine, General Surgery, Pediatrics, Ophthalmology, Ear, Nose & Throat, Urology, Gastroenterology, Dermatology, Orthopedics, Reconstructive & Aesthetic Surgery, Smoking Session Clinic, Sleep Lab, Cardiology, Orthopedics, Neuro & spine surgery, Pulmonology. Qualified and experienced medical personnel and technicians ensure healthcare delivery of the highest standards. Columbia Asia Hospital – Palam Vihar is today considered as one of the best hospitals in Gurgaon. The hospital has international standard infrastructure and follows globally benchmarked standards of medical, nursing and operating protocols and is rapidly becoming the preferred healthcare destination for International Patients.
Specialities | Level | Anaesthesia Type | Chances Of Repeat Procedure |
---|---|---|---|
Cardiology | No | Negligible |
Error Number: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'medtrave_travel-med-India.sanjeevani_doctors.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT `sanjeevani_doctors`.`title`, `sanjeevani_doctors`.`surname`, `sanjeevani_doctors`.`slug_url`, `sanjeevani_doctors`.`slug_url_acc`, `sanjeevani_doctors`.`image`, `sanjeevani_doctors`.`specialty`, `sanjeevani_doctors`.`fee`, `sanjeevani_cp_accounts`.`slug_url_city`, `sanjeevani_cp_accounts`.`country` FROM `sanjeevani_doctors` LEFT JOIN `sanjeevani_cp_accounts` ON `sanjeevani_doctors`.`cp_id`=`sanjeevani_cp_accounts`.`cp_id` WHERE `sanjeevani_doctors`.`cp_id` = '59' AND `sanjeevani_doctors`.`del_flag` = '0' AND `sanjeevani_doctors`.`status` = '1' AND `sanjeevani_doctors`.`image` != '' AND `specialty` IN('1') GROUP BY `sanjeevani_cp_accounts`.`cp_id` ORDER BY `sanjeevani_cp_accounts`.`ord_by` DESC LIMIT 6
Filename: models/Usermodel.php
Line Number: 6660