SELECT *
FROM `cmnty_master`
LEFT JOIN `city_master` ON `cmnty_master`.`cmnty_city`=`city_master`.`city_id`
LEFT JOIN `locality_master` ON `cmnty_master`.`cmnty_area`=`locality_master`.`locality_id`
WHERE `cmnty_master`.`is_active` = 1
AND `cmnty_master`.`is_deleted` =0
AND `cmnty_master`.`cmnty_code` = 'TC15125512'
AND `cmnty_master`.`envi` = 1
 LIMIT 1