SELECT `tbl_hospitals_details`.*, `tbl_cities`.`city_name` as `city`, `tbl_states`.`state_name` as `state`, `tbl_countries`.`country_name` as `country`, `tbl_hospital_types`.`types` as `hospital_type`, `tbl_treatment_catogeries`.`catogerie_name` as `treatment_name`, `tbl_procedure_details`.`procedure_name` as `ttreatment_name`, `tbl_disease_details`.`disease_name` as `disease`
FROM `tbl_hospitals_details`
LEFT JOIN `tbl_countries` ON `tbl_countries`.`id` = `tbl_hospitals_details`.`country_id`
LEFT JOIN `tbl_cities` ON `tbl_cities`.`id` = `tbl_hospitals_details`.`city`
LEFT JOIN `tbl_states` ON `tbl_states`.`id` = `tbl_hospitals_details`.`state`
LEFT JOIN `tbl_treatment_catogeries` ON `tbl_treatment_catogeries`.`id` = `tbl_hospitals_details`.`treatment_id`
LEFT JOIN `tbl_procedure_details` ON `tbl_procedure_details`.`id` = `tbl_hospitals_details`.`treatment_ids`
LEFT JOIN `tbl_disease_details` ON `tbl_disease_details`.`id` = `tbl_hospitals_details`.`disease_ids`
LEFT JOIN `tbl_hospital_types` ON `tbl_hospital_types`.`id` = `tbl_hospitals_details`.`hospital_id`
WHERE `tbl_hospitals_details`.`country_id` = '146'
AND `tbl_hospitals_details`.`city` = '4743'
AND FIND_IN_SET('4', tbl_hospitals_details.treatment_type_ids)
AND FIND_IN_SET('1176', tbl_hospitals_details.disease_ids)
AND `tbl_hospitals_details`.`isDeleted` = 0
ORDER BY `order_in_masterlist` ASC, `order_in_masterlist` ASC
 LIMIT 10