JavaScript is disable on your browser.For full functionality of this page it is necessary to enable JavaScript. Here are the instructions how to enable JavaScript in your web browser

Hospital, Clinic & Medical Services

Find an extensive list of leading hospitals, clinic and medical services providers at one place. The medical services providers listed here offer treatments and solutions for a wide range of problems and diseases: dental problems, gynecology solutions, orthopedic treatment, cardiology treatment, plastic surgery services and many others. You can contact the suitable clinic or medical services provider to book an appointment.

Database Error

A Database Error Occurred

Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tradexl_sitev1jan15.product_tbl.p_Id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT `product_tbl`.*, `product_by_user`.*, `user_registration`.*, `city`.`city_id`, `city`.`city_name` FROM `product_tbl` JOIN `product_by_user` ON `product_by_user`.`product_By_User_Id`=`product_tbl`.`p_user_Id` JOIN `user_registration` ON `user_registration`.`user_Id`=`product_by_user`.`user_Id` JOIN `city` ON `city`.`city_id`=`user_registration`.`user_City` WHERE `p_cat_Id` = '4' AND `p_subcat_Id` = '95' AND `user_registration`.`live_status` = 1 AND `product_by_user`.`catalog_status` = 0 AND `product_by_user`.`status_Flag` = 'Accepted' GROUP BY `product_by_user`.`product_By_User_url` ORDER BY `p_user_Id` ASC

Filename: models/Common_model.php

Line Number: 235