Query: | SELECT c.*,ct.name AS city_name,a.name AS area_name,tl.name AS location_name FROM tbl_centers c INNER JOIN tbl_cities ct ON ct.id=c.city_id
INNER JOIN tbl_areas a ON a.id=c.area_id INNER JOIN tbl_locations tl ON tl.id=c.location_id WHERE c.id = trustedrxsolutions.com AND c.status=1 AND c.is_deleted=0 |